8.4 中文镜像

MySQL 8.4 参考手册 · 中文镜像

正文为中文,英文原文默认隐藏。点击任意中文段落即可展开 / 收起对应英文原文。

打开官方英文原文 ↗

译文由机器翻译生成,仅供理解参考;有疑问请以官方英文原文为准。

MySQL 8.4 参考手册 / 19 复制 / 19.4 复制解决方案 / 19.4.1 使用复制进行备份
中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 100%

19.4.1 使用复制进行备份19.4.1 Using Replication for Backups

要将复制用作备份解决方案,请将数据从源复制到副本,然后备份副本。副本可以暂停并关闭而不影响源的正常运行,因此您可以生成“实时” data that would otherwise require the source to be shut down.To use replication as a backup solution, replicate data from the source to a replica, and then back up the replica. The replica can be paused and shut down without affecting the running operation of the source, so you can produce an effective snapshot of “live” data that would otherwise require the source to be shut down.

如何备份数据库取决于其大小,以及您是仅备份数据,还是备份数据和副本状态,以便在发生故障时可以重建副本。因此有两种选择:How you back up a database depends on its size and whether you are backing up only the data, or the data and the replica state so that you can rebuild the replica in the event of failure. There are therefore two choices:

另一种备份策略,可用于源服务器或副本服务器,是将服务器置于只读状态。备份是在只读服务器上执行的,然后服务器恢复到通常的读/写操作状态。请参见第 19.4.1.3 节,“通过将源或副本设置为只读来备份”。Another backup strategy, which can be used for either source or replica servers, is to put the server in a read-only state. The backup is performed against the read-only server, which then is changed back to its usual read/write operational status. See Section 19.4.1.3, “Backing Up a Source or Replica by Making It Read Only”.