qq_18913471的博客

一.编译前准备下载地址https://dev.mysql.com/downloads/file/?id=492161解压安装包#tar -xvf mysql-5.6.47.tar创建编译目录#cd mysql-5.6.47#mkdir work二.cmake编译打开cmake（mac版本安装自行百度）选择源码目录和build目录单击configu...

1.设置数据一致性参数：SET PERSIST group_replication_consistency='BEFORE_ON_PRIMARY_FAILOVER';2.group_replication_consistency可选值EVENTUAL（默认）BEFORE_ON_PRIMARY_FAILOVERBEFOREAFTERBEFORE_AND_AFTER3....

1.查看各节点gtid_executed集合，并对比集合差异select @@gtid_executed;2.新主低于旧主GTID_SET集合，并且存在新的GTID_SET集合生成处理办法2.1定位差异GTID_SET旧主：'5751729e-0a78-11ea-bb1b-951dd1c15154:1-25'新主：‘'5751729e-0a78-11ea-bb1b-951dd1...

1.GTID_SET正常生成涉及到的堆栈信息-do_command(THD*)--dispatch_command(THD*,COM_DATA const*,enum_server_command)---mysql_parse(THD*,Parser_state*)----mysql_execute_command(THD*,bool)-----trans_commit_stm...

[MY-011526]报错信息：Error number: MY-011526; Symbol: ER_GRP_RPL_MEMBER_TRANS_GREATER_THAN_GRP; SQLSTATE: HY000Message: This member has more executed transactions than those present in the group. Loc...

一：报错信息：[Warning] [MY-011493] [Repl] Plugin group_replication reported: 'Member with address 172.29.12.79:24803 has become unreachable.'[Warning] [MY-011493] [Repl] Plugin group_replication reporte...

服务组成1:创建密钥方式1:mysql_ssl_rsa_setup样例：mysql_ssl_rsa_setup --uid xxx --datadir xxxx参数说明：--uid ：指定文件所属用户名--datadir:指定密钥文件生成的路径生成的密钥文件ca.pem ：ca证书签名ca-key.pem ：ca私钥server-cert.pe...