469,265 Members | 1,966 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,265 developers. It's quick & easy.

Master/Slave restoration.


I have 2 servers (A and B) setup as Master and Slave respectively.
Upon A's failure, all client's request will be directed to B.

How can I set A to become master again after its been restored from
its failure? In chapter 4.10 of mysql docs, it mentioned (vaguely)
that A will become B's slave to sync all operations that had happened
after the failure. Finally, upon full sync switch A to become Master
again and B to slave.

How can I setup A to be a slave of B? The problem I faced is that I
can't find out what the bin log and position is from B since "show
master status" is always empty. I guess B still thinks its a slave.

All comments/advices are very much appreciated. Thanks!
Jul 19 '05 #1
0 1912

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Primaria Falticeni | last post: by
reply views Thread by flubdgub | last post: by
reply views Thread by Winston Ng | last post: by
3 posts views Thread by ram09 | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.