MySQL 8.4 Release Notes
- 19.1.1 基于二进制日志文件位置的复制配置概述19.1.1 Binary Log File Position Based Replication Configuration Overview
- 19.1.2 设置基于二进制日志文件位置的复制19.1.2 Setting Up Binary Log File Position Based Replication
- 19.1.3 使用全局事务标识符进行复制19.1.3 Replication with Global Transaction Identifiers
- 19.1.4 在线服务器上更改 GTID 模式19.1.4 Changing GTID Mode on Online Servers
- 19.1.5 MySQL 多源复制19.1.5 MySQL Multi-Source Replication
- 19.1.6 复制和二进制日志选项与变量19.1.6 Replication and Binary Logging Options and Variables
- 19.1.7 常见的复制管理任务19.1.7 Common Replication Administration Tasks
本节介绍如何配置 MySQL 中可用的不同类型的复制，并包括建立和配置复制环境所需的步骤，包括创建新的复制环境的逐步说明。本节的主要内容包括：This section describes how to configure the different types of replication available in MySQL and includes the setup and configuration required for a replication environment, including step-by-step instructions for creating a new replication environment. The major components of this section are:
关于使用二进制日志文件位置设置两个或多个服务器进行复制的指南，第 19.1.2 节，“设置基于二进制日志文件位置的复制”，涉及服务器的配置，并提供在源服务器和副本之间复制数据的方法。For a guide to setting up two or more servers for replication using binary log file positions, Section 19.1.2, “Setting Up Binary Log File Position Based Replication”, deals with the configuration of the servers and provides methods for copying data between the source and replicas.
有关使用 GTID 事务设置两个或更多服务器进行复制的指南，请参见第 19.1.3 节，“使用全局事务标识符进行复制”，该部分涉及服务器的配置。For a guide to setting up two or more servers for replication using GTID transactions, Section 19.1.3, “Replication with Global Transaction Identifiers”, deals with the configuration of the servers.
二进制日志中的事件使用多种格式记录。这些方式被称为基于语句的复制 (SBR) 或基于行的复制 (RBR)。第三种类型是混合格式复制 (MIXED)，它会根据情况自动使用 SBR 或 RBR 复制，以利用 SBR 和 RBR 格式的优点。不同的格式在 第 19.2.1 节，“复制格式” 中进行了讨论。Events in the binary log are recorded using a number of formats. These are referred to as statement-based replication (SBR) or row-based replication (RBR). A third type, mixed-format replication (MIXED), uses SBR or RBR replication automatically to take advantage of the benefits of both SBR and RBR formats when appropriate. The different formats are discussed in Section 19.2.1, “Replication Formats”.
有关适用于复制的不同配置选项和变量的详细信息，请参阅第 19.1.6 节，“复制和二进制日志选项及变量”。Detailed information on the different configuration options and variables that apply to replication is provided in Section 19.1.6, “Replication and Binary Logging Options and Variables”.
一旦启动，复制过程应几乎不需要管理或监控。然而，关于您可能想执行的常见任务的建议，请参阅第 19.1.7 节，“常见复制管理任务”。Once started, the replication process should require little administration or monitoring. However, for advice on common tasks that you may want to execute, see Section 19.1.7, “Common Replication Administration Tasks”.