Ooo to mirror a database.
Posted: Thu Dec 11, 2003 5:26 am
Being thick - but what the hell- LONG week!
Trying to mirror the mysql DB on one Apache2 win2000 server to that on another.
Found an article about it and failed misserably
The article told me to make amendment to the my.cnf file. Took me ages to even sort that out. My server was showing .cnf files as Speeddial short cuts. In my version of MYSQL i had 4 .cnf files located in the mysql folder.
I renamed one of these file to my.cnf, made the appropriate amends and moved the file to c:/. The 3 .cnf file where called my-huge, my-large, my-medium and my-small.
I placed the following line in to make the machine a master :'log-bin'
I placed the following lines(similar) in to make machine2 the slave :
master-host=10.1.1.1
master-user=replicate
master-password=password
Am i off the mark? Why was there not a MY.cnf in the installation? Why the 4 seperate ones?
Trying to mirror the mysql DB on one Apache2 win2000 server to that on another.
Found an article about it and failed misserably
The article told me to make amendment to the my.cnf file. Took me ages to even sort that out. My server was showing .cnf files as Speeddial short cuts. In my version of MYSQL i had 4 .cnf files located in the mysql folder.
I renamed one of these file to my.cnf, made the appropriate amends and moved the file to c:/. The 3 .cnf file where called my-huge, my-large, my-medium and my-small.
I placed the following line in to make the machine a master :'log-bin'
I placed the following lines(similar) in to make machine2 the slave :
master-host=10.1.1.1
master-user=replicate
master-password=password
Am i off the mark? Why was there not a MY.cnf in the installation? Why the 4 seperate ones?