Hi Gleb, I understand that the replication shouldn't break, but restarting master means losing the updates made to the master database, which we can't afford to do that.
TA > >Hello. > >Why are you afraid of shutting down the server for a while? >Is it so critical? If yes, send more detailed description of your >situation. Replication shouldn't break. From: > http://dev.mysql.com/doc/refman/5.0/en/replication-features.html > >"It is safe to shut down a master server and restart it later." > > >Tedy Aulia wrote: > > >>Hi Gleb, >> >>Thanks for your reply. >> >>I am using MySQL 3.23.33. >> >>The ones that I will need to add in my.cnf are the syncronisation >>parameters as follow: >> >>binlog-do-db=XYZ >>replicate-do-db=XYZ >>replicate-ignore-table=XYZ.table1 >>replicate-ignore-table=XYZ.table2 >>replicate-ignore-table=XYZ.table3 >> >> >>Database XYZ was in synch for the past 12 months, I have found database >>is not in synch anymore as the parameters I mentioned above are missing >>in my.cnf. I want to put back those parameters but I can't afford to >>restart the server as MySQL server is also used by other database which >>is currently in synch and runs happily. >> >> >> >> >>Cheers, >>TA >> >> >>Hello. >> >>You can change some variables without restarting the server. See: >> http://dev.mysql.com/doc/refman/5.0/en/dynamic-system-variables.html >> >>Tedy Aulia wrote: >> >> >> >>>Hi All, >>> >>>I will need to change my.cnf in master machine, but I can't afford to >>>restart MySQL server as the server has been used for heavy traffic >>>databases. >>>Can anyone tell me how to do it? >>> >>> >>>Cheers, >>> >>>*Tedy Aulia* >>> >>> >>> >>> >> >>
