cd /app/
tar -czvf /app/packages/binlog_tar.gz.20210303 /app/database/mysql/database/mysql/data/3306/binlog*
tar -czvf /app/packages/database_bak_tar.gz.20210303 database
mysql> show global variables like '%timeout%';
mysql> set global net_read_timeout = 120;
mysql> set global net_write_timeout = 900;
mysql> set global wait_timeout=2880000;
mysql> set global interactive_timeout=2880000;
mysql> max_allowed_packet = 500M
4.配置文件添加
vi /etc/my.cnf
server-id=1
log-bin=/app/database/mysql/data/3306/binlog
5.创建主从同步用户
创建同步用户slave
create user 'slave'@'IP' identified by 'PWD';
GRANT REPLICATION SLAVE ON *.* TO 'slave'@'IP';
flush privileges;
撤销授权
REVOKE all PRIVILEGES on *.* from 'root'@'%' ;
检查配置
select user,host from mysql.user where user='slave';
重启数据库
kill -9 数据库进程PID
/bin/sh /usr/local/mysql/bin/mysqld_safe &
如果数据库没有使用主从复制,那么就可以将参数log_bin_trust_function_creators设置为1
SET GLOBAL log_bin_trust_function_creators = 1;
跳过slave上的1个错误,------若报错的条数很多,可调整参数
set global sql_slave_skip_counter =1;
若报错:Got fatal error 1236 from master when reading data from binary log: ‘Could not find first log file name in binary log index file’