时间:2021-07-01 10:21:17 帮助过:18人阅读
- <span style="color: #000000;">#主库参数</span><span style="color: #000000;">
- # 主库增加参数
- [mysqld]<br>log-error_verbosity=3
- log_bin</span>=/mysql/log/<span style="color: #800080;">3306</span>/mysql-<span style="color: #000000;">bin #开启binlog
- log_bin_index</span>=/mysql/log/<span style="color: #800080;">3306</span>/mysql-<span style="color: #000000;">bin.index
- binlog_format</span>=<span style="color: #000000;">row
- binlog_rows_query_log_events</span>=<span style="color: #000000;">on
- max_binlog_size</span>=<span style="color: #800080;">2048</span><span style="color: #000000;">
- #主库修改参数
- bind</span>-address=<span style="color: #800080;">192.168</span>.<span style="color: #800080;">1.201</span><span style="color: #000000;">
- server_id</span>=<span style="color: #800080;">2013306</span><span style="color: #000000;">
- expire_logs_days</span>=<span style="color: #800080;">7</span><span style="color: #000000;"> #超过7天的binlog清理
- innodb_support_xa</span>=<span style="color: #800080;">1</span><span style="color: #000000;">
- binlog_cache_size</span>=<span style="color: #000000;">1M
- log_bin_trust_function_creators</span>=<span style="color: #800080;">1</span><span style="color: #000000;"> #同步存储过程、函数、触发器
- innodb_flush_log_at_trx_commit</span>=<span style="color: #800080;">1</span><span style="color: #000000;">
- sync_binlog</span>=<span style="color: #800080;">1</span><span style="color: #000000;">
- transaction</span>-isolation=read-<span style="color: #000000;">committed
- #从库参数<br></span>
- <span>bind-address=192.168.1.202<span>
- server_id=2023306</span></span>
- <span style="color: #000000;"><br>log-error_verbosity=3
- relay_log</span>=/mysql/log/<span style="color: #800080;">3306</span>/relaylog/mysql-<span style="color: #000000;">relay.log
- log</span>-slave-updates=<span style="color: #800080;">1</span><span style="color: #000000;">
- read_only</span>=<span style="color: #800080;">1</span><span style="color: #000000;">
- slave</span>-parallel-type=<span style="color: #000000;">LOGICAL_GLOCK
- slave</span>-parallel-workers=<span style="color: #800080;">4</span><span style="color: #000000;">
- master_info_repository</span>=<span style="color: #000000;">table
- relay_log_info_repository</span>=<span style="color: #000000;">table
- relay_log_recovery</span>=<span style="color: #800080;">1</span><span style="color: #000000;">
- slave_skip_error</span>=<span style="color: #000000;">ddl_exist_errors
- slave_preserve_commit_order</span>=<span style="color: #800080;">1<br><br>#注意,设置完参数之后,必须要记得重启mysql,否则不生效。<br><br>#【2.2】在主库创建复制通信需要的账户<br><span style="color: #000000;">create user ‘rpl‘@‘192.168.1.%‘ identified by ‘123456‘;<br>grants replication on *.* to ‘rpl‘@‘192.168.1.*‘;<br></span>select user,host from mysql.user;<br>#使用该账户在从库上对主库进行登录,能登录上才算成功;<br><br>#【2.3】核验复制账户是否成功,在从库上运行<br><span style="color: #000000;">mysql -u‘rpl‘ -p123456 -h192.168.1.201<br><br>#如果不行请核验</span></span>
(1)网络可以互相ping通
(2)双方端口是否侦听开启:netstat -an|grep 3306
(3)防火墙策略:service iptables stop;(这里只是测试,我就直接关闭了哈)
(4)selinux策略:getenforce(查看状态) setenforce 0 (关闭)
- <span style="color: #800080;"> </span>
(5.4)mysql高可用系列——MySQL异步复制
标签:需要 注意 状态 repo fun mysq ORC events server