<solved> MySQL Replication A->B->C

Posted by nonus25 on Server Fault See other posts from Server Fault or by nonus25
Published on 2012-12-12T06:32:06Z Indexed on 2012/12/13 11:07 UTC
Read the original article Hit count: 369

I was setting the MySQL Replication for master -> slave/master -> slave and Replication for master -> slave its works fine but when i have enable this option in my.cnf

log-slave-updates=1

for updating the master bin log my replications is starting be slower and the time

Seconds_Behind_Master

is growing.

I use innodb engine but the DB is big. Any idea how i can improve the replication, looks like the network is not the issue. Also i was think to use

binlog_format=ROW

but master is using default setting for replication 'statement' and i cant reset master ;)

Thanks ...

© Server Fault or respective owner

Related posts about mysql

Related posts about replication