Google "MySQL Circular Replication".
The replication part isn't particularly difficult, what IS difficult is making sure your application is written in a manner that is replication friendly, especially if you're using Master/Master replication for load balancing.
|