MySQL Replication

MySQL replication is what is being slowly replaced by MySQL clustering. MySQL replication has a single master server which can do read and write queries. The other slave servers are only able to do read queries. In order to fully utilize this solution the software application should be coded in a way that separate servers are used for read queries versus write queries. The MySQL replication is supported in MySQL 4.