mysql 主从的配置方式

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;

留存速查