List:Replication« Previous MessageNext Message »
From:Andy Smith Date:March 21 2008 7:48pm
Subject:Re: Basic questions on slave servers
View as plain text  
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.

Thread
Basic questions on slave serversAndy Smith18 Mar
  • Re: Basic questions on slave serversChris.Leeworthy18 Mar
    • Re: Basic questions on slave serversEd W23 Mar
      • Re: Basic questions on slave serversArthur Fuller23 Mar
        • Re: Basic questions on slave serversEd W23 Mar
  • RE: Basic questions on slave serversEdward F. Pauley II18 Mar
Re: Basic questions on slave serversAndy Smith18 Mar
  • RE: Basic questions on slave serversRick James19 Mar
Re: Basic questions on slave serversAndy Smith20 Mar
  • Re: Basic questions on slave serversMartin MC Brown20 Mar
Re: Basic questions on slave serversAndy Smith20 Mar
  • Re: Basic questions on slave serversMarcus Bointon20 Mar
  • RE: Basic questions on slave serversRick James20 Mar
    • Re: Basic questions on slave serversEric Frazier20 Mar
      • RE: Basic questions on slave serversRick James20 Mar
        • Re: Basic questions on slave serversMoon's Father21 Mar
Re: Basic questions on slave serversAndy Smith21 Mar