开发者

MySQL Master-Slave and slave as master - slave configuration

开发者 https://www.devze.com 2023-04-04 15:52 出处:网络
Currently I have nor开发者_运维技巧mal MySQL Master - Slave configured. For ex :- Server 1 as Master and Server 2 as Slave.

Currently I have nor开发者_运维技巧mal MySQL Master - Slave configured. For ex :- Server 1 as Master and Server 2 as Slave. Now I want Server 2 as Master (Which is already a slave for Server 1) and Server 3 as Slave.

I have setup replication between Server 2 as Master and server 3 as Slave. But the replication changes which happens on server 2 are not getting replicated on Server 3.

If I add a new table on Server 2 using Create table on Server 1 then it gets create on Server 2 but I want it to get created on Server 3 as well...... Is there any param which I need to set for this.

Please help.... I need to setup this kind of replication where whatever is getting replicated on Server 2 should get replicated to Server 3


add --log-slave-updates to the Server2


perform ddl commands seperatly on slave dbs and dont rely it. only rely on dml operations.

2nd option is re-configure slave again for slave 2.

0

精彩评论

暂无评论...
验证码 换一张
取 消