Evening all,

We have a requirement to turn some MySQL databases into something more rugged - specifically fully redundant.

The best option I think would be a small cluster - with one single IP address to connect to (VRRP?), multiple hardware behind it, each node fully synchronised with its peers.

Problem: how? MySQL Master/slave replication isn't what I'm looking for. Googling turns up a couple of commercial solutions:

emicnetworks.com openminds.co.uk

But they are proprietary and could cause problems by themselves.

Has anyone here looked into this, or better solved the problem and if so how?

Thanks,

James P.S. Got my USB camera working - needed scsi disk support in the kernel - doh!