The other Master is configured to quickly be promoted to be the writable
master.
Each of the two Masters is configured to be both a master (writing to
the binlog), and be a slave (replicating from the other machine). Data
is actually flowing only one direction, but everything is in place for
failover.
Master-Slave could do the same stuff, but you would have to turn on
writing to the binlog, etc before you could promote the Slave to be Master.
On 4/5/12 6:02 PM, Kaushal Shriyan wrote:
>
>
> On Fri, Apr 6, 2012 at 6:11 AM, Rick James <rjames@stripped
> <mailto:rjames@stripped>> wrote:
>
> Slaves are useful for scaling reads.
>
> Master-Master, with one of them writable, is the best config for
> quickly failing over if one machine dies.
> Any number of Slaves can be hung off them; it is best to split the
> slaves evenly.
>
> Master-Relay-Slave -- the middle guy is a "single point of
> failure", hence not advisable
>
> Circular Replication (3+ machines replicating in one direction) is
> not advised -- if one dies, you have a mess.
>
> Writing to two masters (Dual or Circular) does not give you write
> scaling -- all writes have to be performed by all servers. That
> is, you cannot scale writes by any Replication configuration.
>
>
> Hi Rick
>
> Typically Master Master Replication is the preferred over the other
> replication methods ? Any documentation please. Master-Master, with
> one of them writable, not sure i understand that so write on one
> master and what about the other master.
>
> Regards,
>
> Kaushal
>
>
> On 4/5/12 5:15 PM, Kaushal Shriyan wrote:
>
> Hi,
>
> Any documentation regarding setting up MySQL Replication. I
> have been
> referring to
> http://dev.mysql.com/doc/refman/5.5/en/replication.html and
> also what are the typical scenarios to be setup viz Master
> Master Slave or
> Master Slave or Master Slave Slave. Help me understand the
> pros and cons of
> this various combinations.
>
> Thanks and Regards,
>
> Kaushal
>
>
> --
> Rick James - MySQL Geek
>
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe: http://lists.mysql.com/replication
>
>
--
Rick James - MySQL Geek
