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*
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@/stripped/
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
