Replication overhead

[steez977]

Hello,

is there anyone who has experiences to share about replicating Mysql? Master-Slave set up? ...

We have this setup running smoothly, though my concern is a 30% CPU increase due to the replication (even at night when DB usage is minimal)

Anything on this is appreciated!

 

[parkers]

Hi,

I also run a Master-Slave setup and have noticed memory usage has increased dramtically:

see:
thread436-779766 any help appreciated...

 

[rab54]

Can either of you guys advise me on how to enable binary logging on the master ?

I have added the log-bin line but it has had no effect !

cheers in advance !

Rab

 

[parkers]

Hi steez977,

This is going back a while now ...

I don't know if you were able to resolve the memory usage problems running a Master - Slave replication setup?

I eventually stumbled across a solution this morning! The problems I found were caused by an ever increasing replication_binlog file. As it turned out the binlog file maintained by the database server was > 400MB !! which if opened and closed continually will drastically reduce available memory and also have an impact on CPU usage. To resolve you can run the following:

mysqladmin -p refresh

My recommendation would be to run a nightly cron job (if *nix) to flush all tables and start a new log file.

I hope this is of use!
SP