my.cnf配置
- [mysqld]
- character-set-server=utf8mb4
- thread_handling=pool-of-threads
- thread_pool_max_threads=1000
- thread_pool_idle_timeout=900
- max_connections=3001
- server-id=153
- log_bin = mysql-bin
- relay_log = /var/lib/mysql/mysql-relay-bin
- log_slave_updates = 1
- read_only =1
ini
数据库设置
- create user slave identified by 'slave
- grant replication slave,replication client on *.* to 'slave'@'192.168.1.%' identified by 'slave
- flush privileges;
- STOP SLAVE IO_THREAD FOR CHANNEL '';
- show slave status\G;
- show master status\G;
- change master to master_host='192.168.1.12',master_user='slave',master_password='slave
- start slave;
crmsh
binlog内容查看
- mysqlbinlog -v --base64-output=DECODE-ROWS /home/log/mysql/bin-file.000448 | grep -A '20' 210812275
作者
jnan77
发表于
2017-08-25 10:33:23
,添加在分类
数据库
下
,并被添加「
linux
数据库
」标签
,最后修改于
2017-08-25 10:33:23
Comments
热评话题