2021 年 1月 17 日随笔档案 - InnoLeo

2021年1月17日

摘要：坑：用keepalived 时，双主或是主从的PORT是相同的，因为keepalived 不会转发PORT 1. 配置双主：双机名 win89.inno.com win88.inno.com 准备账号 SET SQL_LOG_BIN=0; set password for 'root'@'loca 阅读全文

posted @ 2021-01-17 22:00 InnoLeo 阅读(436) 评论(0) 推荐(0)

Last_SQL_Errno: 1050 Last_SQL_Error: Error 'Table 'events' already exists' on query. Default database: 'eygle'. Query: 'create table events

摘要：主从复制Last_SQL_Errno: 1050 mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master 阅读全文

posted @ 2021-01-17 20:10 InnoLeo 阅读(621) 评论(0) 推荐(0)

[MY-011522] [Repl] Plugin group_replication reported: 'The member contains transactions not present in the group.

摘要： error: mysql> start group_replication; ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more 阅读全文

posted @ 2021-01-17 12:10 InnoLeo 阅读(888) 评论(0) 推荐(0)