（5.4）mysql高可用系列——MySQL异步复制

<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