mysql semi sync_mysql5.5主从同步配置(semi_sync)

向右看齐 2022-10-25 01:24 135阅读 0赞

好久不折腾mysql主从了，发现5.5交之前的版本，配置上有些变化，趁着夜深人静，重温一下，顺便简单记录一下配置过程。 主从同步 master端配置 修改 my.cnf 文件 12345678910 vim /etc/my.cnf\[mysqld\]server-id = 1log-bin = mysql-binbinlog\_format = mixede

好久不折腾mysql主从了，发现5.5交之前的版本，配置上有些变化，趁着夜深人静，重温一下，顺便简单记录一下配置过程。

主从同步

master端配置

修改my.cnf文件

10vim /etc/my.cnf

\[mysqld\]

server-id = 1

log-bin = mysql-bin

binlog\_format = mixed

expire-logs-days = 7

binlog-do-db = luxtarget

binlog-ignore-db = mysql

replicate-do-db = luxtarget

replicate-ignore-db = mysql

新建授权复制用户

2grant replication slave on \*.\* to 'slave'@'xxx.xxx.xxx.xxx' identified by 'slave';

flush privileges;

重启mysql

1service mysqld restart

锁定数据库，将数据打包并拷贝至slave

1flush tables with read lock;

查看master上二进制日志情况，记录File与Position

1show master status;

当数据打包拷贝完毕，解除锁定；

1ublock tables;

当数据较大时，将数据打包备份比使用mysqldump导入时效率更高

slave端配置

修改my.cnf文件

10vim /etc/my.cnf

\[mysqld\]

server-id = 2

log-bin = mysql-bin

binlog\_format = mixed

expire-logs-days = 7

binlog-do-db = luxtarget

binlog-ignore-db = mysql

replicate-do-db = luxtarget

replicate-ignore-db = mysql

重启mysql

1service mysqld restart

将从master拷贝来的数据导入slave

连接master开始同步

5change master to master\_host='xxx.xxx.xxx.xxx',master\_user='slave',master\_password='slave',master\_log\_file='master-bin.xxxxxx,master\_log\_pos=xxx;

start slave;

show slave status\\G;

当Slave\_IO\_Running与Slave\_SQL\_Running的状态都为Running时即可。

半同步配置

master端配置

安装mysql半同步插件

3INSTALL PLUGIN rpl\_semi\_sync\_master SONAME 'semisync\_master.so';

SET GLOBAL rpl\_semi\_sync\_master\_enabled = 1;

SET GLOBAL rpl\_semi\_sync\_master\_timeout = 1000;

修改my.cnf文件

4vim /etc/my.cnf

\[mysqld\]

rpl\_semi\_sync\_master\_enabled=1 \#启用半同步

rpl\_semi\_sync\_master\_timeout=1000 \#超时时间为1s

重启mysql

1service mysqld restart

slave端配置

安装mysql半同步插件

4INSTALL PLUGIN rpl\_semi\_sync\_slave SONAME 'semisync\_slave.so';

SET GLOBAL rpl\_semi\_sync\_slave\_enabled = 1;

STOP SLAVE IO\_THREAD;

START SLAVE IO\_THREAD;

修改my.cnf文件

1rpl\_semi\_sync\_slave\_enabled=1 \#启用半同步复制

重启mysql

1service mysqld restart

检查配置

master

20SHOW GLOBAL STATUS LIKE 'rpl\_semi%';

\+--------------------------------------------+-------+

| Variable\_name | Value |

\+--------------------------------------------+-------+

| Rpl\_semi\_sync\_master\_clients | 1 |

| Rpl\_semi\_sync\_master\_net\_avg\_wait\_time | 0 |

| Rpl\_semi\_sync\_master\_net\_wait\_time | 0 |

| Rpl\_semi\_sync\_master\_net\_waits | 0 |

| Rpl\_semi\_sync\_master\_no\_times | 0 |

| Rpl\_semi\_sync\_master\_no\_tx | 0 |

| Rpl\_semi\_sync\_master\_status | ON |

| Rpl\_semi\_sync\_master\_timefunc\_failures | 0 |

| Rpl\_semi\_sync\_master\_tx\_avg\_wait\_time | 0 |

| Rpl\_semi\_sync\_master\_tx\_wait\_time | 0 |

| Rpl\_semi\_sync\_master\_tx\_waits | 0 |

| Rpl\_semi\_sync\_master\_wait\_pos\_backtraverse | 0 |

| Rpl\_semi\_sync\_master\_wait\_sessions | 0 |

| Rpl\_semi\_sync\_master\_yes\_tx | 0 |

\+--------------------------------------------+-------+

14 rows in set (0.00 sec)

slave

7mysql> SHOW GLOBAL STATUS LIKE 'rpl\_semi%';

\+----------------------------+-------+

| Variable\_name | Value |

\+----------------------------+-------+

| Rpl\_semi\_sync\_slave\_status | ON |

\+----------------------------+-------+

1 row in set (0.01 sec)

好久不折腾mysql主从了，发现5.5交之前的版本，配置上有些变化，趁着夜深人静，重温一下，顺便简单记录一下配置过程。

主从同步

master端配置

修改my.cnf文件

10vim /etc/my.cnf

\[mysqld\]

server-id = 1

log-bin = mysql-bin

binlog\_format = mixed

expire-logs-days = 7

binlog-do-db = luxtarget

binlog-ignore-db = mysql

replicate-do-db = luxtarget

replicate-ignore-db = mysql

mysql semi sync_mysql5.5主从同步配置(semi_sync)

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 MySQL主从同步配置

相关 mysql semi sync_mysql5.5主从同步配置(semi_sync)

相关 MySQL主从同步配置

相关 [转] MySQL 5.5+ 主从同步 Semisync Replication

相关基于semisync实现MySQL的主从半同步复制

相关 mysql主从同步配置

相关 mysql 主从同步配置

相关 Mysql主从同步配置

相关 mysql主从同步配置

相关 mysql主从同步配置