First, a bit of middleware for MySQL that acts as a proxy which
automatically handles failover as well as sending transactional queries
to one machine and read only queries to another machine etc.
http://forge.mysql.com/wiki/MySQL_Proxy
http://jan.kneschke.de/2007/8/1/mysql-proxy-learns-r-w-splitting
Second, check this out:
http://meta.slashdot.org/article.pl?sid=07/10/18/1641203
Slashdot uses MySQL 5 running on 7 machines with multi-master
replication with all writes going to one and reads going to the others.
More info on how to setup multi-master:
http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html
Combine these and you have one killer relational database cluster.
And of course for non-relational database needs (where MySQL is usually
pressed into service anyway) there is the very cool highly available and
replicated CouchDB which I look forward to playing with someday soon:
http://couchdb.org
Not ready for serious production use but definitely getting there.
Should be interesting.
[bcc'd to various potentially interested friends]
--
Tracy R Reed Read my blog at http://ultraviolet.org
Key fingerprint = D4A8 4860 535C ABF8 BA97 25A6 F4F2 1829 9615 02AD
Non-GPG signed mail gets read only if I can find it among the spam.
--
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
