There is a good HOWO available on the MySQL Developer Zone titled:
MySQL Cluster: Two webserver setup.
MySQL has supported Master->Slave replication for some time now. With the latest version of MySQL you can now run Master-Master replication. This allows you to load balance multiple MySQL servers for redundancy and scalability without having to write specific code for the insert/select sections of your application.
