mysql主从复制异步半同步实例
建立mysql的复制
node1:
mysql> show master status;
+------------------+----------+--------------+------------------+-------------------+
| file | position | binlog_do_db | binlog_ignore_db | executed_gtid_set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000003 | 120 | | | |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)
mysql>
node2:
mysql> change master to master_host='192.168.56.102',master_user='qwer',master_password='system',master_log_file='mysql-bin.000003',master_log_pos=120,master_port=3306;
query ok, 0 rows affected, 2 warnings (0.04 sec)
mysql> start slave;
query ok, 0 rows affected (0.03 sec)
mysql> show slave status\g
*************************** 1. row ***************************
slave_io_state: waiting for master to send event
master_host: 192.168.56.102
master_user: qwer
master_port: 3306
connect_retry: 60
master_log_file: mysql-bin.000003
read_master_log_pos: 120
relay_log_file: node2-relay-bin.000002
relay_log_pos: 283
relay_master_log_file: mysql-bin.000003
slave_io_running: yes
slave_sql_running: yes
replicate_do_db: tongs
2.加载插件
node1:
mysql> install plugin rpl_semi_sync_master soname 'semisync_master.so';
mysql> set global rpl_semi_sync_master_enabled=1; --开启半同步
mysql> set global rpl_semi_sync_master_timeout=1000; --半同步1000毫秒
node2:
mysql> install plugin rpl_semi_sync_slave soname 'semisync_slave.so';
mysql> set global rpl_semi_sync_slave_enabled=1;
3.查看状态
node1:
mysql> show variables like '%rpl_%';
+-------------------------------------------+------------+
| variable_name | value |
+-------------------------------------------+------------+
| rpl_semi_sync_master_enabled | on |
| rpl_semi_sync_master_timeout | 1000 |
| rpl_semi_sync_master_trace_level | 32 |
| rpl_semi_sync_master_wait_for_slave_count | 1 |
| rpl_semi_sync_master_wait_no_slave | on |
| rpl_semi_sync_master_wait_point | after_sync |
| rpl_stop_slave_timeout | 31536000 |
+-------------------------------------------+------------+
7 rows in set (0.00 sec)
mysql>
node2:
mysql> show variables like '%rpl_%';
+---------------------------------+----------+
| variable_name | value |
+---------------------------------+----------+
| rpl_semi_sync_slave_enabled | on |
| rpl_semi_sync_slave_trace_level | 32 |
| rpl_stop_slave_timeout | 31536000 |
+---------------------------------+----------+
3 rows in set (0.00 sec)
mysql>
ubuntu下nginx做负载实现高性能web服务器5---mysql主主同步
生产环境mysql主主同步主键冲突处理
mysql主从失败 错误got fatal error 1236
mysql主从复制，，单台服务器上实施
搭建mysql代理服务器实现读写分离+主从同步
mysql 5.5 主从双向同步
mysql 5.5主从同步排错
本文永久更新链接地址：