电脑知识|欧美黑人一区二区三区|软件|欧美黑人一级爽快片淫片高清|系统|欧美黑人狂野猛交老妇|数据库|服务器|编程开发|网络运营|知识问答|技术教程文章 - 好吧啦网

您的位置:首頁技術文章
文章詳情頁

MySQL MGR搭建過程中常遇見的問題及解決辦法

瀏覽:4日期:2023-10-04 12:48:23

MGR搭建過程中遇到的一些故障

實際中我一共部署了三套MGR環境,分別是單機多實例的MGR環境,多機同網段的MGR環境,多機不同網段的MGR環境,部署的過程大同小異,但是還是有一些有出入的地方,這里把部署過程遇到的故障列舉出來,供大家參考,如果能有幸解決您在部署時候的問題,那是極好的。

01 常見故障1

[ERROR] Plugin group_replication reported: ’This member has more executed transactions than those present in the group. Local transactions: bb874065-c485-11e8-8b52-000c2934472e:1 > Group transactions: 3db33b36-0e51-409f-a61d-c99756e90155:1-11’[ERROR] Plugin group_replication reported: ’The member contains transactions not present in the group. The member will now exit the group.’[Note] Plugin group_replication reported: ‘To force this member into the group you can use the group_replication_allow_local_disjoint_gtids_join option’

解決方案:

根據提示打開set global group_replication_allow_local_disjoint_gtids_join=ON;

02 常見故障2

[ERROR] Plugin group_replication reported: ’This member has more executed transactions than those present in the group. Local transactions: bb874065-c485-11e8-8b52-000c2934472e:1 > Group transactions: 3db33b36-0e51-409f-a61d-c99756e90155:1-15’[Warning] Plugin group_replication reported: ’The member contains transactions not present in the group. It is only allowed to join due to group_replication_allow_local_disjoint_gtids_join option’[Note] Plugin group_replication reported: ’This server is working as secondary member with primary member address localhost.localdomaion:3306.’

解決方案:

該故障和故障1的不同之處在于該問題出現時,參數group_replication_allow_local_disjoint_gtids_join已經設置成為on了。解決該問題的方法是執行reset master就行,然后重新在主節點和從節點開啟通道,即

CHANGE MASTER TO MASTER_USER=’rpl_user’, MASTER_PASSWORD=’rpl_pass’ FOR CHANNEL ’group_replication_recovery’;

03 常見故障3

本機測試時,遇到下面的問題

[Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the ’START SLAVE Syntax’ in the MySQL Manual for more information. [ERROR] Slave I/O for channel ’group_replication_recovery’: error connecting to master ’rpl_user@localhost.localdomaion:’ - retry-time: 60 retries: 1, Error_code: 2005 [ERROR] Plugin group_replication reported: ’There was an error when connecting to the donor server. Please check that group_replication_recovery channel credentials and all MEMBER_HOST column values of performance_schema.replication_group_members table are correct and DNS resolvable.’ [ERROR] Plugin group_replication reported: ’For details please check performance_schema.replication_connection_status table and error log messages of Slave I/O for channel group_replication_recovery.’ [Note] Plugin group_replication reported: ’Retrying group recovery connection with another donor. Attempt /’

解決方案:

這個問題是由于測試環境上三臺主機的hostname設置成為了同一個名稱,改了hostname之后,這個問題就解決了。

04 常見故障4

#在線上正式環境操作時,出現下面的錯誤,mysql--root@localhost:(none) ::>>START GROUP_REPLICATION;ERROR (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log.#查看log文件,發現只有一個warning:2019-02-20T07::30.233937Z [Warning] Plugin group_replication reported: ’Group Replication requires slave-preserve-commit-order to be set to ON when using more than 1 applier threads.

解決方案:

mysql--root@localhost:(none) ::>>show variables like '%preserve%';+--------------------------------+---------+| Variable_name | Value |+--------------------------------+---------+| slave_preserve_commit_order | OFF |+--------------------------------+---------+ row in set (0.01 sec)mysql--root@localhost:(none) ::>>set global slave_preserve_commit_order=;Query OK, rows affected (0.00 sec)05 常見問題5

2019-02-20T08::31.088437Z [Warning] Plugin group_replication reported: ’[GCS] Connection attempt from IP address 192.168.9.208 refused. Address is not in the IP whitelist.’2019-02-20T08::32.088676Z [Warning] Plugin group_replication reported: ’[GCS] Connection attempt from IP address 192.168.9.208 refused. Address is not in the IP whitelist.’

解決方法:

在my.cnf中配置group_replication_ip_whitelist參數即可解決

06 常見問題6

2019-02-20T08::44.087492Z [Warning] Plugin group_replication reported: ’read failed’2019-02-20T08::44.096171Z [ERROR] Plugin group_replication reported: ’[GCS] The member was unable to join the group. Local port: 24801’2019-02-20T08::14.065775Z [ERROR] Plugin group_replication reported: ’Timeout on wait for view after joining group

解決方案:

將my.cnf中的參數group_replication_group_seeds設置為只包含除自身外其他group成員的ip地址以及內部通信端口,如果寫成group所有成員的IP地址,則會出現這個錯誤,這和相同網段的MGR部署方式有些差異。

07 常見問題7

[ERROR] Plugin group_replication reported: ‘[GCS] Error on opening a connection to oceanbase07: on local port: ’.’ [ERROR] Plugin group_replication reported: ‘[GCS] Error on opening a connection to oceanbase08: on local port: ’.’ [ERROR] Plugin group_replication reported: ‘[GCS] Error on opening a connection to oceanbase07: on local port: ’.’

解決方案:

未開通防火墻上的固定端口,開通防火墻之后即可解決

08 常見問題8

[Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the ’START SLAVE Syntax’ in the MySQL Manual for more information. [ERROR] Slave I/O for channel ’group_replication_recovery’: Master command COM_REGISTER_SLAVE failed: Access denied for user ’rpl_user’@’%’ (using password: YES) (Errno: 1045), Error_code: 1597 [ERROR] Slave I/O thread couldn’t register on master [Note] Slave I/O thread exiting for channel ’group_replication_recovery’, read up to log ’FIRST’, position

解決方案:

漏掉了某個節點的用戶,為了保險起見,在group節點上執行

CREATE USER rpl_user@’%’;

GRANT REPLICATION SLAVE ON *.* TO rpl_user@’%’ IDENTIFIED BY ’rpl_pass’;

09 常見問題9

[ERROR] Failed to open the relay log ’./localhost-relay-bin.000011’ (relay_log_pos ). [ERROR] Could not find target log file mentioned in relay log info in the index file ’./work_NAT_1-relay-bin. index’ during relay log initialization. [ERROR] Slave: Failed to initialize the master info structure for channel ’’; its record may still be present in ’mysql.slave_master_info’ table, consider deleting it. [ERROR] Failed to open the relay log ’./localhost-relay-bin-group_replication_recovery.000001’ (relay_log_pos ). [ERROR] Could not find target log file mentioned in relay log info in the index file ’./work_NAT_1-relay-bin-group_replication_recovery.index’ during relay log initialization. [ERROR] Slave: Failed to initialize the master info structure for channel ’group_replication_recovery’; its record may still be present in ’mysql.slave_master_info’ table, consider deleting it. [ERROR] Failed to create or recover replication info repositories. [ERROR] Slave SQL for channel ’’: Slave failed to initialize relay log info structure from the repository, Error_code: [ERROR] /usr/local/mysql/bin/mysqld: Slave failed to initialize relay log info structure from the repository [ERROR] Failed to start slave threads for channel ’’

解決方案:

這個錯誤是由于slave節點由于某種原因導致找不到relay-log的位置了,需要重新reset slave

以上就是MySQL MGR搭建過程中常遇見的問題及解決辦法的詳細內容,更多關于MySQL MGR搭建的資料請關注好吧啦網其它相關文章!

標簽: MySQL 數據庫
相關文章:
主站蜘蛛池模板: 快速门厂家批发_PVC快速卷帘门_高速门_高速卷帘门-广州万盛门业 快干水泥|桥梁伸缩缝止水胶|伸缩缝装置生产厂家-广东广航交通科技有限公司 | 软文发布平台 - 云软媒网络软文直编发布营销推广平台 | 碳化硅,氮化硅,冰晶石,绢云母,氟化铝,白刚玉,棕刚玉,石墨,铝粉,铁粉,金属硅粉,金属铝粉,氧化铝粉,硅微粉,蓝晶石,红柱石,莫来石,粉煤灰,三聚磷酸钠,六偏磷酸钠,硫酸镁-皓泉新材料 | 螺旋丝杆升降机-SWL蜗轮-滚珠丝杆升降机厂家-山东明泰传动机械有限公司 | 玖容气动液压设备有限公司-气液增压缸_压力机_增压机_铆接机_增压器 | IIS7站长之家-站长工具-爱网站请使用IIS7站长综合查询工具,中国站长【WWW.IIS7.COM】 | 多功能三相相位伏安表-变压器短路阻抗测试仪-上海妙定电气 | 气体热式流量计-定量控制流量计(空气流量计厂家)-湖北南控仪表科技有限公司 | 山东聚盛新型材料有限公司-纳米防腐隔热彩铝板和纳米防腐隔热板以及钛锡板、PVDF氟膜板供应商 | 橡胶接头_橡胶软接头_套管伸缩器_管道伸缩器厂家-巩义市远大供水材料有限公司 | 环保袋,无纺布袋,无纺布打孔袋,保温袋,环保袋定制,环保袋厂家,环雅包装-十七年环保袋定制厂家 | 柔性测斜仪_滑动测斜仪-广州杰芯科技有限公司 | 智能风向风速仪,风速告警仪,数字温湿仪,综合气象仪(气象五要素)-上海风云气象仪器有限公司 | 湖南自考_湖南自学考试| 针焰试验仪,灼热丝试验仪,漏电起痕试验仪,水平垂直燃烧试验仪 - 苏州亚诺天下仪器有限公司 | 【ph计】|在线ph计|工业ph计|ph计厂家|ph计价格|酸度计生产厂家_武汉吉尔德科技有限公司 | 防水套管-柔性防水套管-刚性防水套管-上海执品管件有限公司 | 青岛侦探调查_青岛侦探事务所_青岛调查事务所_青岛婚外情取证-青岛狄仁杰国际侦探公司 | 润滑脂-高温润滑脂-轴承润滑脂-食品级润滑油-索科润滑油脂厂家 | 半容积式换热器_北京浮动盘管换热器厂家|北京亿丰上达 | 尚为传动-专业高精密蜗轮蜗杆,双导程蜗轮蜗杆,蜗轮蜗杆减速机,蜗杆减速机生产厂家 | 洛阳装修公司-洛阳整装一站式品牌-福尚云宅装饰 | 进口便携式天平,外校_十万分之一分析天平,奥豪斯工业台秤,V2000防水秤-重庆珂偌德科技有限公司(www.crdkj.com) | 航空铝型材,7系铝型材挤压,硬质阳*氧化-余润铝制品 | 防爆大气采样器-防爆粉尘采样器-金属粉尘及其化合物采样器-首页|盐城银河科技有限公司 | 「阿尔法设计官网」工业设计_产品设计_产品外观设计 深圳工业设计公司 | 西门子气候补偿器,锅炉气候补偿器-陕西沃信机电工程有限公司 | 旋片真空泵_真空泵_水环真空泵_真空机组-深圳恒才机电设备有限公司 | 济南宣传册设计-画册设计_济南莫都品牌设计公司 | UV-1800紫外光度计-紫外可见光度计厂家-翱艺仪器(上海)有限公司 | 北京网站建设公司_北京网站制作公司_北京网站设计公司-北京爱品特网站建站公司 | 粘度计,数显粘度计,指针旋转粘度计 | 智能化的检漏仪_气密性测试仪_流量测试仪_流阻阻力测试仪_呼吸管快速检漏仪_连接器防水测试仪_车载镜头测试仪_奥图自动化科技 | 等离子空气净化器_医用空气消毒机_空气净化消毒机_中央家用新风系统厂家_利安达官网 | 干洗加盟网-洗衣店品牌排行-干洗设备价格-干洗连锁加盟指南 | 苹果售后维修点查询,苹果iPhone授权售后维修服务中心 – 修果网 拼装地板,悬浮地板厂家,悬浮式拼装运动地板-石家庄博超地板科技有限公司 | 优宝-汽车润滑脂-轴承润滑脂-高温齿轮润滑油脂厂家 | 可程式恒温恒湿试验箱|恒温恒湿箱|恒温恒湿试验箱|恒温恒湿老化试验箱|高低温试验箱价格报价-广东德瑞检测设备有限公司 | 99文库_实习生实用的范文资料文库站 | 喷砂机厂家_自动除锈抛丸机价格-成都泰盛吉自动化喷砂设备 | 【同风运车官网】一站式汽车托运服务平台,验车满意再付款 |