MySql database synchronization

I have two different servers for mysql databases. First server is for master database and second serv开发者_开发问答er to act as slave. Now i need to synchronization all the changes being done on my master database to be applied to the slave database on real time basis.

Please guide me with all the steps to implement real time mysql database synchronization.

---

Sometimes errors that occur silently/louding on the MASTER will cause the replication to break on the SLAVE (if the query was invalid on the master it will also be invalid on the slave). There are two solutions: 1. prevent bad entry on the MASTER by fixing the table (ie required fields) or the logic that allows inserts. 2. ignore certain errors that occur by modifying the my.ini file on the slave.

On a related note: The book High Performance MySQL is a excellent resource on how to setup replication.