master
install 5.6.15
设置密码和用户名以及访问的主机
/etc/my.cnf
[mysqld]
log-bin=mysql-bin
binlog_format=mixed
server-id = 1
#innodb_flush_log_at_trx_commit=1
sync_binlog=1
/etc/init.d/mysqld restart
/alidata/server/mysql/bin/mysql -u root -p
查看状态
SHOW MASTER STATUS;
SHOW PROCESSLIST\G;
slave
install 5.6.15
$sudo vim /etc/my.cnf
$/mysql/bin/mysql -u root -p
CHANGE MASTER TO MASTER_HOST='182.2.9.1’,
MASTER_USER='root',
MASTER_PASSWORD=‘123456’,
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=0;
Query OK, 0 rows affected, 2 warnings (0.01 sec)
mysql> SHOW ERRORS;
mysql> SHOW WARNINGS;
START SLAVE;
SHOW SLAVE STATUS\G;
STOP SLAVE;
SET GLOBAL sql_slave_skip_counter =1;
START slave;
留存速查