mysql搭建主从2

1.stop slave

2.reset slave

3.mysqldump -h192.168.2.11 -uroot -padmin888 --default-character-set=utf8 --databases test --single-transaction --master-data=2 > test.sql

4.mysql -uroot -padmin888 --default-character-set=utf8 < test.sql

5.change master to master_host='192.168.2.11',master_port=3306,master_user='hanlf',master_password='123456',master_log_file='mysql-bin.000001',master_log_pos=1996

6.start slave

7.mysql查看binlog日志（带v查看具体内容，不带v只能看到base64加密内容）

mysqlbinlog /var/lib/mysql/mysql-bin.000001 -v

mysqlbinlog /var/lib/mysql/mysql-bin.000001 -v --base64-output=decode-rows

8.查看binlog目录
show variables like '%log_%'

show variables like '%log_bin%'

9.查看格式
show variables like '%format%'

10.查看事务隔离级别

show variables like '%isolation%'

select @@tx_isolation

11.查看编码

show variables like '%char%'