Re: Masters in HA and slaves in LB
Good setup.
When you restart a slave or do FLUSH LOGS, a "relay log" is started. This will necessarily make _slave_ filenames/positions in SHOW SLAVE STATUS change and be inconsistent with other slaves. Is that what you are seeing?
One slight improvement on the setup: Have half the slaves hang off the readonly master. That way, if you lose the writable master, you will still have a correctly setup Master-Slave to fail over to. The dead master and any Slave(s) hanging off can't replicate until they are rebuilt.
Are all the machines in the same building? (I'm thinking of carrying HA to the next level.)
Subject
Views
Written By
Posted
3075
May 17, 2010 06:09AM
Re: Masters in HA and slaves in LB
1185
May 18, 2010 08:39AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.