Dual hot standby method settings from the server

We want to set up the server hot standby, you must first understand the main demand from the version of the database server. To achieve hot standby mysql version should be higher than 3.2, there is a basic principle is that a version of the database from the database may be higher than the main server database version, but not lower than the main server database version. Settings from the server requires the following five steps: Step one set from the server - first set the configuration file for the database server-id = n // Set the default database id is a primary server can easily set up, but if there are multiple slave servers can not be repeated . master-host = db-master.mycompany.com // master server IP address or domain master-port = port number of the master-user 3306 // master database = master-password pertinax // user database synchronization = freitag // database synchronization password master-connect-retry = 60 // If the primary server cut off from the server, re-connection time difference report-host = db-slave.mycompany.com // report errors hot standby server more relevant Information See: Hot Standby software (http://www.expresscluster.net.cn/)