I'll second Zawodny's book. It's a quick read.
http://www.bookpool.com/sm/0596003064
OT, A decent backup scheme mentioned in it is to run a slave on a separate machine, and then do all your backups off that (as you wont have to shut the main machine down, and it will resync up when brought back online)
He explains it much better than me.
On Apr 5, 2005, at 7:13 PM, Perrin Harkins wrote:
It's a bit different from just clustering an existing MySQL database.
It involves using an entirely separate table type which is designed just
for clustering. Suitable for some applications, but most of what people
think of as database clustering would be easier to do using replication
(which MySQL supports) and some kind of external failover. Zawodny's
MySQL book covers the subject well.
- Perrin
