| Mysql Replication [message #3552] |
Sat, 20 September 2008 02:27  |
 surendharsurya
Messages: 1
Registered: September 2008
Location: India |
Junior Member |
|
|
Hi all,
1) now working on mysql replication setup. i have doubt when my master server goes down how do i make my slave server to act as a master.
2) once crashed server is now ready to serve, how do i will change current master server to old master server.
|
|
|
| Re: Mysql Replication [message #3657 is a reply to message #3552 ] |
Mon, 27 October 2008 01:44  |
debug
Messages: 132
Registered: March 2008 |
Senior Member |
|
|
1) you can do it manually - 'stop slave' on server 2, ensure that read_only is set to 0, and send queries to server 2.
2) once server 1 is up, you should re-synchronize it from server 2 (the same way as you setup replication), configure server 2 to act as slave for server 1, and switch queries back to server1.
Probably it makes sense to look at MMM: http://code.google.com/p/mysql-master-master/ - it can help to do things automatically.
Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting
|
|
|
Members
Search
Help
Register
Login
Home
