List:Replication« Previous MessageNext Message »
From:Ricardo Date:September 21 2011 10:27pm
Subject:Re: confirm subscribe to replication@lists.mysql.com
View as plain text  
> The benefit comes when your active master dies and mmm switches to the passive one
> without (hopefully!) your app even noticing

Stop the presses, sold. This will save me not only a lot of time implementing this
structure but also allows me to actually sit back and relax if the master stops working.

With the regular master-slave, if the master somehow crashed I manually had to change the
web server writing db ip from master to slave, this with people shouting at your ears 'no
records are getting saved!!' 

Thanks a lot for the info, will try to implement this tomorrow!!!

Ricardo
Thread
RE: confirm subscribe to replication@lists.mysql.comRicardo Freitas21 Sep
  • Re: confirm subscribe to replication@lists.mysql.comWagner Bianchi21 Sep
    • Re: confirm subscribe to replication@lists.mysql.comMarcus Bointon21 Sep
      • Re: confirm subscribe to replication@lists.mysql.comRicardo21 Sep
        • Re: confirm subscribe to replication@lists.mysql.comWagner Bianchi21 Sep
        • Re: confirm subscribe to replication@lists.mysql.comMarcus Bointon21 Sep
          • Re: confirm subscribe to replication@lists.mysql.comRicardo21 Sep
            • Re: confirm subscribe to replication@lists.mysql.comPrabhat Kumar21 Sep
            • Re: confirm subscribe to replication@lists.mysql.comMarcus Bointon21 Sep
              • Re: confirm subscribe to replication@lists.mysql.comRicardo21 Sep
                • Re: confirm subscribe to replication@lists.mysql.comMarcus Bointon21 Sep
                  • Re: confirm subscribe to replication@lists.mysql.comRicardo22 Sep
      • Re: confirm subscribe to replication@lists.mysql.comWagner Bianchi21 Sep
  • Re: confirm subscribe to replication@lists.mysql.comRick James21 Sep