List:Replication« Previous MessageNext Message »
From:Kaushal Shriyan Date:April 6 2012 1:02am
Subject:Re: MySQL Replication
View as plain text  
On Fri, Apr 6, 2012 at 6:11 AM, Rick James <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<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<http://lists.mysql.com/replication>
> To unsubscribe:   
> http://lists.mysql.com/**replication<http://lists.mysql.com/replication>
>
>

Thread
MySQL ReplicationKaushal Shriyan6 Apr
  • Re: MySQL ReplicationRick James6 Apr
    • Re: MySQL ReplicationKaushal Shriyan6 Apr
      • Re: MySQL Replicationnhadie ramos6 Apr
      • Re: MySQL ReplicationRick James6 Apr