MySQL master-slave replication configuration (Lite)

First, to prepare two servers, virtual machine can be, to the author as an example: master:192.168.1.105 slave:192.168.1.106

Two. Ensure that the two virtual functions ping each other, first shut down the firewall: service iptables stop

Three. Install MySQL, can refer to the author Linux fast installation MySQL

Four. Configure master-slave editing/etc/my.cnf files

(1) Configure Master to add the following configuration:

Server-id = 1 #Server标识
Log-bin #打开 MySQL Binary Log
Binlog-do-db=test #指定需要日志的数据库

(2) Configure Slave to add the following configuration:

server-id=2
master-host=192.168.1.105
Master-user=xxx
Master-password=xxx
master-port=3306
Master-connect-retry=60 #预设重试间隔60秒
Replicate-do-db=test #告诉slave只做backup数据库的更新

Five. Restart the master slave service mysqld Restart to verify

MySQL master-slave replication configuration (Lite)