相关Ip
master : 192.168.153.132
slave :192.168.153.131
结合目前情况,只取部分工具进行使用。
准备工作
创建用户checksums 权限: GRANT SELECT, PROCESS, SUPER, REPLICATION SLAVE ON *.* TO 'admin'@'%' IDENTIFIED BY '123456'; select 查看所有库的表,原理可加 --explain选项查看 process show processlist super set binlog_format='statement' replication slave show slave hosts