Re: i need advice on redundancy of mysql server.

[Shawn Green]

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