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

您的位置:首頁(yè)技術(shù)文章
文章詳情頁(yè)

MySQL MGR搭建過(guò)程中常遇見(jiàn)的問(wèn)題及解決辦法

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

MGR搭建過(guò)程中遇到的一些故障

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

01 常見(jiàn)故障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’

解決方案:

根據(jù)提示打開(kāi)set global group_replication_allow_local_disjoint_gtids_join=ON;

02 常見(jiàn)故障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的不同之處在于該問(wèn)題出現(xiàn)時(shí),參數(shù)group_replication_allow_local_disjoint_gtids_join已經(jīng)設(shè)置成為on了。解決該問(wèn)題的方法是執(zhí)行reset master就行,然后重新在主節(jié)點(diǎn)和從節(jié)點(diǎn)開(kāi)啟通道,即

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

03 常見(jiàn)故障3

本機(jī)測(cè)試時(shí),遇到下面的問(wèn)題

[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 /’

解決方案:

這個(gè)問(wèn)題是由于測(cè)試環(huán)境上三臺(tái)主機(jī)的hostname設(shè)置成為了同一個(gè)名稱,改了hostname之后,這個(gè)問(wèn)題就解決了。

04 常見(jiàn)故障4

#在線上正式環(huán)境操作時(shí),出現(xiàn)下面的錯(cuò)誤,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文件,發(fā)現(xiàn)只有一個(gè)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 常見(jiàn)問(wèn)題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參數(shù)即可解決

06 常見(jiàn)問(wèn)題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中的參數(shù)group_replication_group_seeds設(shè)置為只包含除自身外其他group成員的ip地址以及內(nèi)部通信端口,如果寫(xiě)成group所有成員的IP地址,則會(huì)出現(xiàn)這個(gè)錯(cuò)誤,這和相同網(wǎng)段的MGR部署方式有些差異。

07 常見(jiàn)問(wèn)題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: ’.’

解決方案:

未開(kāi)通防火墻上的固定端口,開(kāi)通防火墻之后即可解決

08 常見(jiàn)問(wèn)題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

解決方案:

漏掉了某個(gè)節(jié)點(diǎn)的用戶,為了保險(xiǎn)起見(jiàn),在group節(jié)點(diǎn)上執(zhí)行

CREATE USER rpl_user@’%’;

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

09 常見(jiàn)問(wèn)題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 ’’

解決方案:

這個(gè)錯(cuò)誤是由于slave節(jié)點(diǎn)由于某種原因?qū)е抡也坏絩elay-log的位置了,需要重新reset slave

以上就是MySQL MGR搭建過(guò)程中常遇見(jiàn)的問(wèn)題及解決辦法的詳細(xì)內(nèi)容,更多關(guān)于MySQL MGR搭建的資料請(qǐng)關(guān)注好吧啦網(wǎng)其它相關(guān)文章!

標(biāo)簽: MySQL 數(shù)據(jù)庫(kù)
相關(guān)文章:
主站蜘蛛池模板: 防勒索软件_数据防泄密_Trellix(原McAfee)核心代理商_Trellix(原Fireeye)售后-广州文智信息科技有限公司 | 灰板纸、灰底白、硬纸板等纸品生产商-金泊纸业| 电子万能试验机_液压拉力试验机_冲击疲劳试验机_材料试验机厂家-济南众标仪器设备有限公司 | 档案密集柜_手动密集柜_智能密集柜_内蒙古档案密集柜-盛隆柜业内蒙古密集柜直销中心 | 数字展示在线_数字展示行业门户网站 | 食药成分检测_调料配方还原_洗涤剂化学成分分析_饲料_百检信息科技有限公司 | 医院专用门厂家报价-医用病房门尺寸大全-抗菌木门品牌推荐 | 深圳市八百通智能技术有限公司官方网站 | 滑石粉,滑石粉厂家,超细滑石粉-莱州圣凯滑石有限公司 | 喷码机,激光喷码打码机,鸡蛋打码机,手持打码机,自动喷码机,一物一码防伪溯源-恒欣瑞达有限公司 | 垃圾处理设备_餐厨垃圾处理设备_厨余垃圾处理设备_果蔬垃圾处理设备-深圳市三盛环保科技有限公司 | 压片机_高速_单冲_双层_花篮式_多功能旋转压片机-上海天九压片机厂家 | 陕西安闸机-伸缩门-车牌识别-广告道闸——捷申达门业科技 | C形臂_动态平板DR_动态平板胃肠机生产厂家制造商-普爱医疗 | 自动检重秤-动态称重机-重量分选秤-苏州金钻称重设备系统开发有限公司 | 楼承板-开口楼承板-闭口楼承板-无锡海逵| 真空冷冻干燥机_国产冻干机_冷冻干燥机_北京四环冻干 | 金属检测机_金属分离器_检针验针机_食品药品金属检探测仪器-广东善安科技 | 无味渗透剂,泡沫抑尘剂,烷基糖苷-威海威能化工有限公司 | 洗石机-移动滚筒式,振动,螺旋,洗矿机-青州冠诚重工机械有限公司 | 环保袋,无纺布袋,无纺布打孔袋,保温袋,环保袋定制,环保袋厂家,环雅包装-十七年环保袋定制厂家 | 私人别墅家庭影院系统_家庭影院音响_家庭影院装修设计公司-邦牛影音 | 电子厂招聘_工厂招聘_普工招聘_小时工招聘信息平台-众立方招工网 | 冲击式破碎机-冲击式制砂机-移动碎石机厂家_青州市富康机械有限公司 | 双舌接地线-PC68数字式高阻计-ZC36|苏海百科 | 洗石机-移动滚筒式,振动,螺旋,洗矿机-青州冠诚重工机械有限公司 | 磁力抛光研磨机_超声波清洗机厂家_去毛刺设备-中锐达数控 | 招商帮-一站式网络营销服务|互联网整合营销|网络推广代运营|信息流推广|招商帮企业招商好帮手|搜索营销推广|短视视频营销推广 | 护腰带生产厂家_磁石_医用_热压护腰_登山护膝_背姿矫正带_保健护具_医疗护具-衡水港盛 | 智能交通网_智能交通系统_ITS_交通监控_卫星导航_智能交通行业 | 学习虾-免费的学习资料下载平台 雪花制冰机(实验室雪花制冰机)百科 | TPE_TPE热塑性弹性体_TPE原料价格_TPE材料厂家-惠州市中塑王塑胶制品公司- 中塑王塑胶制品有限公司 | 合肥花魁情感婚姻咨询中心_挽回爱情_修复婚姻_恋爱指南 | 缓蚀除垢剂_循环水阻垢剂_反渗透锅炉阻垢剂_有机硫化物-郑州威大水处理材料有限公司 | 工作服定制,工作服定做,工作服厂家-卡珀职业服装(苏州)有限公司 | 电动高尔夫球车|电动观光车|电动巡逻车|电动越野车厂家-绿友机械集团股份有限公司 | 全国国际化学校_国际高中招生_一站式升学择校服务-国际学校网 | 骁龙云呼电销防封号系统-axb电销平台-外呼稳定『免费试用』 | 澳威全屋定制官网|极简衣柜十大品牌|衣柜加盟代理|全屋定制招商 百度爱采购运营研究社社群-店铺托管-爱采购代运营-良言多米网络公司 | 不干胶标签-不干胶贴纸-不干胶标签定制-不干胶标签印刷厂-弗雷曼纸业(苏州)有限公司 | 浙江工业冷却塔-菱电冷却塔厂家 - 浙江菱电冷却设备有限公司 |