High Availability for MySQL: Considering the Options
March 9, 2009[From Enterprise Networking Planet]
Running a basic MySQL setup is quite simple, but as soon as you begin thinking about the best way to provide redundancy, things quickly get complex. There are many layers to consider when it comes to databases, and the variety of solutions is difficult to choose from. Depending on your availability goals, the storage system back-ends you wish to use, and the type of MySQL tables used, the answer will vary. Let's try to untangle this mess.
The article continues at http://www.enterprisenetworkingplanet.com/netos/article.php/3809331