MYSQL能否实现如下复制模式A<==>B<==>C

yueliangdao0608

A<====>B<====>C

这种是完全可以的！
不过B上要有两个实例。

suxiangkun

能否说明一下~

yueliangdao0608

原帖由 suxiangkun 于 2008-3-14 09:26 发表
能否说明一下~

两个实例就是用MYSQLD_MULTI管理的两个MYSQL实例。

端口不同。
具体见：
http://blog.chinaunix.net/u/29134/showart_470685.html

suxiangkun

谢谢，已经明白了

fan12

呵呵，高级，开眼界了

gucuiwen

B上不需要两个实例，一个就可以了mysql5完全支持，手册里有说明：

--log-slave-updates

Normally, a slave does not log to its own binary log any updates that are received from a master server. This option tells the slave to log the updates performed by its SQL thread to its own binary log. For this option to have any effect, the slave must also be started with the --log-bin option to enable binary logging. --log-slave-updates is used when you want to chain replication servers. For example, you might want to set up replication servers using this arrangement:

A -> B -> C

Here, A serves as the master for the slave B, and B serves as the master for the slave C. For this to work, B must be both a master and a slave. You must start both A and B with --log-bin to enable binary logging, and B with the --log-slave-updates option so that updates received from A are logged by B to its binary log.

yueliangdao0608

原帖由 gucuiwen 于 2008-3-18 18:02 发表
B上不需要两个实例，一个就可以了mysql5完全支持，手册里有说明：

--log-slave-updates

Normally, a slave does not log to its own binary log any updates that are received from a master server. T ...

仔细看看LZ的要求！

gucuiwen

呵呵，确实看错了。只看了前面，后面没仔细看。