From: Shawn Green
Date: June 11 2012 4:57pm
Subject: Re: i need advice on redundancy of mysql server.
List-Archive: http://lists.mysql.com/mysql/227620
Message-Id: <4FD62379.5040300@oracle.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 6/11/2012 12:02 PM, Joey L wrote:
> You listed a lot of things - but no solution - i am looking for master
> - master configuration.
> Any tools you have used ?
> Anything concrete you can offer?
>

There is no "one-size-fits-all" approach to the problem you are 
attempting to solve. However, there are some documented solutions in the 
manual for you to review

Let's start with the basics:

    http://dev.mysql.com/doc/refman/5.5/en/faqs-replication.html

 
http://dev.mysql.com/doc/refman/5.5/en/replication-solutions-scaleout.html

    http://dev.mysql.com/doc/refman/5.5/en/replication-solutions-switch.html

    http://dev.mysql.com/doc/refman/5.5/en/replication-howto.html

    http://dev.mysql.com/doc/refman/5.5/en/replication-problems.html

We also document some more exotic configurations:

    http://dev.mysql.com/doc/refman/5.5/en/ha-overview.html

Which one you opt for depends on many factors that we cannot determine 
for you.

Warmest wishes,
-- 
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN