MySQL репликация master-slave

MySQL репликация master-slave

Master

server-id = 5372578

log-bin = mysql-bin

log-bin-index = mysql-bin.index

log-error = mysql-bin.err

relay-log = relay-bin

relay-log-info-file = relay-bin.info

relay-log-index = relay-bin.index

expire_logs_days=7

binlog-do-db = mikbill

Slave

server-id = 1494630322
master-host = 192.168.10.100
master-user = test
master-password = 1394
master-port = 3306
relay-log = relay-bin
relay-log-info-file = relay-log.info
relay-log-index = relay-log.index
replicate-do-db = mikbill
slave-skip-errors = 1062

stop slave;

RESET SLAVE;

RESET MASTER;

FLUSH TABLES WITH READ LOCK;

SET GLOBAL read_only = ON;

SET GLOBAL read_only = OFF;