Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Looking at building redundancy into our system, as we are currently, um, exposed should anything blow up.

We have a large-ish DB (150G), consisting of a mix of innoDB and myISAM table types. We want to build redundancy in, with a pair of DB servers, with silent failover should one go down. Clustering looked good, but docs imply new NDB table type, and I don't want to have to change anything.

MySQLProxy looks a bit, well, new and fragile (am I mistaken?) and we need this to be stable, high availability DB.

Which way should we go ? (speccing server purchase at the moment, so early days).

share|improve this question
add comment

2 Answers 2

up vote 0 down vote accepted

Last I checked mysql proxy was still a beta :-). What about master-master replication where the servers share the same IP using either CARP or Heartbeat? And if needed, you can have a third pure slave for read-only queries too! I haven't used this in production, but I know it's not that uncommon with problems when running master-master, so I think one would prevent most of the problems if running shared virtual IP.

share|improve this answer
    
Looks good, many thanks. 3 Techs now reading up on heartbeat and DRBD. –  David Shields Nov 2 '10 at 9:57
add comment

Take a look at mmm also. I'm studying it now to use on production.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.