List:Replication« Previous MessageNext Message »
From:Marcus Bointon Date:September 21 2011 6:57pm
Subject:Re: confirm subscribe to replication@lists.mysql.com
View as plain text  
On 21 Sep 2011, at 20:39, Wagner Bianchi wrote:

> A good solution could be to use a MASTER <=> MASTER topology, using MySQL
> 5.1 or 5.5, in order to split writes between servers, operation will
> decrease a little more your workload.

I really wouldn't do that. Writing to both masters will not gain you any performance and
asks for all kinds of split-brain trouble. I've been there, it's not pretty. If you
manage your masters with MMM, you won't be able to do it anyway as it sets passive
masters to read-only.

It's been said many times - MySQL replication is NOT a scaling solution. MySQL Cluster and
sharding are scaling solutions, but they are unrelated to replication.

Marcus
-- 
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK resellers of info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/



Attachment: [application/pkcs7-signature] smime.p7s
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