MySQL复制 [英] MySQL Replication

问题描述

我应该使用MySQL复制来同步本地数据库和远程数据库吗?如果是这样，我该如何设置主机和从机?还有其他方法可以做到这一点吗?

Shall I use MySQL replication to synchronize a local database and a remote database? If so, how do I setup both master and slave? Are there any other methods available to do this?

推荐答案

如何设置主/从?

how to setup master/slave?

此复制:方法指南兼有您需要在主机和从机上执行的操作.

This Replication: How to guide has both what you need to do on the master and the slave.

任何其他可用于执行此操作的方法

any other methods available to do this

还有 Multi-Master和循环复制(适用于MySQL群集).

There is also Multi-Master and Circular Replication for MySQL Cluster.

这篇关于MySQL复制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！