当前位置:Gxlcms > 数据库问题 > (5.4)mysql高可用系列——MySQL异步复制

(5.4)mysql高可用系列——MySQL异步复制

时间:2021-07-01 10:21:17 帮助过:18人阅读

  1. <span style="color: #000000;">#主库参数</span><span style="color: #000000;">
  2. # 主库增加参数
  3. [mysqld]<br>log-error_verbosity=3
  4. log_bin</span>=/mysql/log/<span style="color: #800080;">3306</span>/mysql-<span style="color: #000000;">bin #开启binlog
  5. log_bin_index</span>=/mysql/log/<span style="color: #800080;">3306</span>/mysql-<span style="color: #000000;">bin.index
  6. binlog_format</span>=<span style="color: #000000;">row
  7. binlog_rows_query_log_events</span>=<span style="color: #000000;">on
  8. max_binlog_size</span>=<span style="color: #800080;">2048</span><span style="color: #000000;">
  9. #主库修改参数
  10. bind</span>-address=<span style="color: #800080;">192.168</span>.<span style="color: #800080;">1.201</span><span style="color: #000000;">
  11. server_id</span>=<span style="color: #800080;">2013306</span><span style="color: #000000;">
  12. expire_logs_days</span>=<span style="color: #800080;">7</span><span style="color: #000000;"> #超过7天的binlog清理
  13. innodb_support_xa</span>=<span style="color: #800080;">1</span><span style="color: #000000;">
  14. binlog_cache_size</span>=<span style="color: #000000;">1M
  15. log_bin_trust_function_creators</span>=<span style="color: #800080;">1</span><span style="color: #000000;"> #同步存储过程、函数、触发器
  16. innodb_flush_log_at_trx_commit</span>=<span style="color: #800080;">1</span><span style="color: #000000;">
  17. sync_binlog</span>=<span style="color: #800080;">1</span><span style="color: #000000;">
  18. transaction</span>-isolation=read-<span style="color: #000000;">committed
  19. #从库参数<br></span>
  1. <span>bind-address=192.168.1.202<span>
  2. server_id=2023306</span></span>
  1. <span style="color: #000000;"><br>log-error_verbosity=3
  2. relay_log</span>=/mysql/log/<span style="color: #800080;">3306</span>/relaylog/mysql-<span style="color: #000000;">relay.log
  3. log</span>-slave-updates=<span style="color: #800080;">1</span><span style="color: #000000;">
  4. read_only</span>=<span style="color: #800080;">1</span><span style="color: #000000;">
  5. slave</span>-parallel-type=<span style="color: #000000;">LOGICAL_GLOCK
  6. slave</span>-parallel-workers=<span style="color: #800080;">4</span><span style="color: #000000;">
  7. master_info_repository</span>=<span style="color: #000000;">table
  8. relay_log_info_repository</span>=<span style="color: #000000;">table
  9. relay_log_recovery</span>=<span style="color: #800080;">1</span><span style="color: #000000;">
  10. slave_skip_error</span>=<span style="color: #000000;">ddl_exist_errors
  11. 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 (关闭)

  1. <span style="color: #800080;"> </span>

 

(5.4)mysql高可用系列——MySQL异步复制

标签:需要   注意   状态   repo   fun   mysq   ORC   events   server   

人气教程排行