<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: 551
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