This morning Emilio and me have been playing with mysql 4.0.x replication capabilities. It’s incredible what can be done with this feature. We’ve tested the most simple way: a master and a slave. So, when you update, insert on the master, the slave is automagically updated too. You could be thinking… what happens if the server breaks down? well, the slave is there for you to be alive. And what if the slave breaks down? Then, the master keeps all updates in a binary file, and when the slave gets back, it AUTOMATICALLY receives all updates from master, and the life goes on :-).
There are lot of possibilities to replicate data through a “computer farm”, but perhaps wait for mysql Cluster technology is worthy, so we can have balanced load as well as reliability.