复制可以在许多不同的环境中用于各种目的。本节提供了一般性说明以及在特定解决方案类型中使用复制的建议。Replication can be used in many different environments for a range of purposes. This section provides general notes and advice on using replication for specific solution types.

有关在备份环境中使用复制的信息，包括设置说明、备份程序和需要备份的文件，请参见 第 19.4.1 节，“使用复制进行备份”。For information on using replication in a backup environment, including notes on the setup, backup procedure, and files to back up, see Section 19.4.1, “Using Replication for Backups”.

有关在源和副本上使用不同存储引擎的建议和技巧，请参见 第 19.4.4 节，“在不同源和副本存储引擎上使用复制”。For advice and tips on using different storage engines on the source and replica, see Section 19.4.4, “Using Replication with Different Source and Replica Storage Engines”.

将复制用作扩展解决方案需要在使用该解决方案的应用程序的逻辑和操作上进行一些更改。请参见 第 19.4.5 节，“使用复制进行扩展”。Using replication as a scale-out solution requires some changes in the logic and operation of applications that use the solution. See Section 19.4.5, “Using Replication for Scale-Out”.

出于性能或数据分发的原因，您可能希望将不同的数据库复制到不同的副本。请参见 第 19.4.6 节，“将不同数据库复制到不同副本”For performance or data distribution reasons, you may want to replicate different databases to different replicas. See Section 19.4.6, “Replicating Different Databases to Different Replicas”

随着副本数量的增加，源服务器的负载可能增加，从而导致性能下降（因为需要将二进制日志复制到每个副本）。有关提高复制性能的提示，包括使用单个辅助服务器作为源，请参见 第 19.4.7 节，“提高复制性能”。As the number of replicas increases, the load on the source can increase and lead to reduced performance (because of the need to replicate the binary log to each replica). For tips on improving your replication performance, including using a single secondary server as the source, see Section 19.4.7, “Improving Replication Performance”.

有关切换源或将副本转换为源以作为紧急故障切换解决方案的一部分的指导，请参见第 19.4.8 节，“故障切换期间切换源”。For guidance on switching sources, or converting replicas into sources as part of an emergency failover solution, see Section 19.4.8, “Switching Sources During Failover”.

有关复制拓扑中服务器的特定安全措施的信息，请参见第 19.3 节，“复制安全”。For information on security measures specific to servers in a replication topology, see Section 19.3, “Replication Security”.