mysql 清理主同步日志_mysql主从同步及清除信息

主:reset master;

从:reset slave all;

mysql主从配置：

1.MySQL主配置文件增加如下：

default-storage-engine = innodb

innodb_flush_log_at_trx_commit = 2

sort_buffer_size = 2M

server-id = 1

log-bin=/data1/mysql3336/mysql3336-bin

binlog-do-db=tc_selflot

binlog-ignore-db=mysql

2.MySQL从配置文件增加如下：

default-storage-engine = innodb

innodb_flush_log_at_trx_commit = 2

sort_buffer_size = 2M

server-id = 2

log-bin=/data1/mysql3336/mysql3336-bin

binlog-do-db=tc_selflot

binlog-ignore-db=mysql

3.重启主从mysql服务

4.进入MySQL主数据库授权同步账号；

use mysql;

grant file,select,replication slave on *.* to slave@'192.168.188.%' identified by '111111';

flush privileges;

5.查看主库状态并记录File 及Position值&#x