MySQL master-Slave synchronization configuration

1. Note: Before synchronizing, be sure to authorize the operation to the from server grant all slave on * * to [E- Mail protected] identified by ' Pass ' view Binlog show Master Stat us Clear Binlogreset Master;2, General master server to add, delete, change, read from the server. If the demand for real-time operation is high, then read data directly from the primary server 3, modify the Binlog from the server my.cnf, and set server-idlog-bin = Mysql-binserver-id = 2master-host= 192.168.0.1master-user=usermaster-password=pass 4, restart MySQL service pkill mysqld/usr/local/mysql/bin/mysqld_safe--user= mysql& 5, view status show slave status\g

MySQL master-Slave synchronization configuration