Setting up MySQL Replication for High Availability

[ Thanks to Ramsai for this link. ]

"MySQL Replication is a feature of the MySQL server that allows you to replicate data from one MySQL database server (called the master) to one or more MySQL database servers (slaves). MySQL Replication has been supported in MySQL for a very long time and is an extremely flexible and powerful technology. Depending on the configuration, you can replicate all databases, selected databases, or even selected tables within a database.

"Replication is asynchronous, that is, the process of replication is not immediate and there is no guarantee that slaves have the same contents as the master (this is in contrast to MySQL Cluster)."

Complete Story

Related Stories:

• Oracle presents "much faster" MySQL beta(Apr 19, 2010)
• Installing PowerDNS (With MySQL Backend) And Poweradmin On Ubuntu 9.10(Apr 18, 2010)
• Oracle MySQL Investment Aims at Microsoft(Apr 14, 2010)
• MySQL Admin Cookbook (Apr 12, 2010)
• MySQL Exotic Storage Engines(Apr 08, 2010)