Re: Basic questions on slave servers

[Andy Smith]

Hi All,

  thanks for all your comments, always good to get opinions from those who've had to
implement stuff
before and fromm people who have different solutions and have encountered different
problems etc...
From the discussion so far I think my plan to achieve a reasonable degree of availability
will be:

Create a master-master system (systems in different locations) 
Set global read_only on the secondary master
Manually change DNS or move a floating IP in event of failure of primary master

I think this will be great as will be very simple, allow quick and easy failover in event
of system failure and 
also allow maintenance for upgrading etc of MySQL or OS with little or no impact to
running systems.

thanks! Andy.