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).