【MySQL】ERROR 1872 (HY000) Replica failed to initialize applier metadata structure from the repository

问题现象

主机异常重启后，mysql数据库8.0.36可以正常启动，但是start slave报错：ERROR 1872 (HY000): Replica failed to initialize applier metadata structure from the repository

截图如下：

问题原因

ERROR 1872 (HY000): Replica failed to initialize applier metadata structure from the repository 是通常表示从库在初始化复制元数据时遇到问题。可能的原因是
1、复制元数据损坏：从库的复制元数据（如中继日志信息）可能已损坏。
2、网络或连接问题：主从库之间的网络连接不稳定或从库无法正确连接到主库。
3、残留的旧复制配置：从库可能之前配置过复制，但未正确清理旧的复制元数据。

处理过程

1、保存主从复制状态信息：

mysql> show replica status \G;
*************************** 1. row ***************************
             Replica_IO_State: 
                  Source_Host: *.*.*.1
                  Source_User: repl
                  Source_Port: 3306
                Connect_Retry: 10
              Source_Log_File: mysql-bin.021503
          Read_Source_Log_Pos: 401115479
               Relay_Log_File: host-*-*-*-*-relay-bin.031628
                Relay_Log_Pos: 401677891
        Relay_Source_Log_File: mysql-bin.021503
           Replica_IO_Running: No
          Replica_SQL_Running: No
              Replicate_Do_DB: 
          Replicate_Ignore_DB: 
           Replicate_Do_Table: 
       Replicate_Ignore_Table: 
      Replicate_Wild_Do_Table: 
  Replicate_Wild_Ignore_Table: 
                   Last_Errno: 13124
                   Last_Error: Replica failed to initialize applier metadata structure from the repository
                 Skip_Counter: 0
          Exec_Source_Log_Pos: 401678003
              Relay_Log_Space: 0
              Until_Condition: None
               Until_Log_File: 
                Until_Log_Pos: 0
           Source_SSL_Allowed: No
           Source_SSL_CA_File: 
           Source_SSL_CA_Path: 
              Source_SSL_Cert: 
            Source_SSL_Cipher: 
               Source_SSL_Key: 
        Seconds_Behind_Source: NULL
Source_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error: 
               Last_SQL_Errno: 13124
               Last_SQL_Error: Replica failed to initialize applier metadata structure from the repository
  Replicate_Ignore_Server_Ids: 
             Source_Server_Id: 0
                  Source_UUID: e63fb3d3-d561-11ec-903f-fa163e3a2e10
             Source_Info_File: mysql.slave_master_info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
    Replica_SQL_Running_State: 
           Source_Retry_Count: 3
                  Source_Bind: 
      Last_IO_Error_Timestamp: 
     Last_SQL_Error_Timestamp: 241223 11:55:22
               Source_SSL_Crl: 
           Source_SSL_Crlpath: 
           Retrieved_Gtid_Set: 
            Executed_Gtid_Set: 192e0886-fd51-11ed-907e-fa163e019833:1-3177,
52db70d3-8d51-11ee-b067-fa163e019833:1-6863,
68839d23-fe38-11ed-911c-fa163e8fa5fa:9-44:46-112:114-173:175-316:318-929:931-946:948-969:971-985:987-999:1001-1025:1027-1057:1059-1073:1075-1099:1101-1115:1117-1131:1133-1145:1147-1159:1161-1218:1220-2649:2651-2862:2864-2876:2878-2986:2988-3018:3020-3048:3050-3082:3084-3098:3100-4237743:4237746-4237809:4237811:4237813-4237815:4237817-4237818:4237821-4338470:4338472-4350453:4350455-4353088:4353090-4420774:4420776-4420835:4420837-28493553:28493555-28561766:28561768-28561774:28561776-28561786:28561788-31699768:31699770-31699782:31699784-31699824:31699826-31699890:31699892-31699917:31699919-31699968:31699970-31700030:31700032-31700044:31700046-31700260:31700262-31700299:31700301-31700313:31700315-31700339:31700341-31700365:31700367-31700380:31700383-31700397:31700399-31700423:31700425-31700439:31700441-31700464:31700466-31700480:31700482-31700507:31700509-31700535:31700537-31700549:31700551-31700565:31700567-31700581:31700583-31700607:31700609-31700610:31700612-31700623:31700625-31700636:31700638-31700718:31700720-31700732:31700734-31700747:31700749-31700808:31700810-31700825:31700827-31707060:31707062-31707232:31707234-31707245:31707247-31707292:31707294-31707305:31707307-31707317:31707319-31707443:31707445-31707524:31707526-31707547:31707549-31707561:31707563-31707577:31707579-31707635:31707637-31707676:31707678-31707702:31707704-31707717:31707719-31707734:31707736-31707751:31707753-31707768:31707770-31707784:31707786-31707796:31707798-31707808:31707810-31707820:31707822-31707832:31707834-31707848:31707850-31707864:31707866-31707880:31707882-31707896:31707898-31707961:31707963-31707974:31707976-31707999:31708001-31708023:31708025-31708071:31708073-31708106:31708108-31708119:31708121-31708132:31708134-31708145:31708147-31708160:31708162-31708174:31708176-31708206:31708208-31708222:31708224-31708234:31708236-31708246:31708248-31708276:31708278-31708292:31708294-31708305:31708307-31708320:31708322-31708350:31708352-31708410:31708412-31708432:31708434-31708455:31708457:31708459-31708480:31708482:31708484-31708505:31708508-31708530:31708532-31708544:31708546-31708553:31708555-31708566:31708568-31708581:31708583-31708596:31708598-31708609:31708611-31708622:31708624-31708635:31708637-31708648:31708650-31708661:31708663-31708676:31708678-31708692:31708694-31708707:31708709-31708722:31708724-31708733:31708735-31708744:31708746-31708760:31708762-31708776:31708778-31708791:31708793-31708802:31708804-31708813:31708815-31708828:31708830-31708843:31708845-31708858:31708860-31708915:31708917-31708928:31708930-31708951:31708953-31708966:31708968-31708979:31708981-31708997:31708999-31709018:31709020-31709043:31709045-31709082:31709084-31709095:31709097-31709108:31709110-31709119:31709121-31709131:31709133-31709147:31709149-31709163:31709165-31709179:31709181-31709193:31709195-31709208:31709210-31709224:31709226-31709240:31709242-31709255:31709257-31709266:31709268-31709277:31709279-31709288:31709290-31709299:31709301-31709314:31709316-31709330:31709332-31709345:31709347-31709379:31709382-31709392:31709394-31709406:31709408-31709452:31709454-31709465:31709467-31709486:31709488-31709505:31709507-31709600:31709602-31709642:31709644-31709714:31709716-31709752:31709754-31709813:31709815-31709828:31709830-31709851:31709853-31709870:31709872-31709894:31709896-31709913:31709915-31709927:31709929-31709955:31709957-31709971:31709973-31709985:31709987-31710001:31710003-31710017:31710019-31710033:31710035-31710045:31710047-31710057:31710059-31710069:31710071-31710085:31710087-31710102:31710104-31710118:31710120-31710134:31710136-31710173:31710175-31710280:31710282-31710295:31710297-31710342:31710344-31710358:31710360-31710407:31710409-31710489:31710492-31710621:31710623-31711440:31711442-31711457:31711459-31711471:31711473-31711502:31711504-31711531:31711533-31711547:31711549-31711563:31711565-31711579:31711581-31711593:31711595-31711610:31711612-31711627:31711629-31711674:31711676-31711713:31711715-31711779:31711781-31711817:31711819-31711843:31711845-31711909:31711911-31711923:31711925-31711937:31711939-31711995:31711997-31712007:31712009-31712019:31712021-31712034:31712036-31712050:31712052-31712067:31712069-31712079:31712081-31712091:31712093-31712103:31712105-31712137:31712139-31712207:31712209-31712273:31712275-31712299:31712301-31712329:31712331-31712343:31712345-31712358:31712360-31712399:31712401-31712415:31712417-31712431:31712433-31712443:31712445-31712467:31712469-31712483:31712485-31712497:31712499-31712512:31712514-31712528:31712530-31712546:31712548-31712563:31712565-31712617,
72a88277-e9b7-11ed-84ef-fa163e8fa5fa:1-21500,
e63fb3d3-d561-11ec-903f-fa163e3a2e10:1-134465377:134465379-900065153:900065155-1034360842:1034360844-1319424325:1319424327-2376664724:2376664726-2688275731:2688275733-2942117893:2942117895-3055610734:3055610736-3110516887:3110516889-3162789321:3162789323-3194017029:3194017031-3377170244:3377170246-3516021990:3516021992-3601595567:3601595569-3676436574:3676436576-4072837184:4072837186-4105023721:4105023723-4105281121:4105281123-4171423004:4171423006-4171427461:4171427463-4312402279:4312402281-4357118940:4357118942-4377520822:4377520824-4443472687:4443472689-4660449692:4660449694-4794520348:4794520350-4825296099:4825296101-5416736425:5416736427-5530274803:5530274805-5565913624:5565913626-5635200656:5635200658-5754309089:5754309091-5982841559:5982841561-6011739614:6011739616-6099119901:6099119903-6099121013:6099121015-6130983497:6130983499-6184623322:6184623324-6184634915:6184634917-6228825865:6228825867-6314343058:6314343060-6314544281:6314544283-6349178487:6349178489-6399608352:6399608354-6587916983:6587916985-6952360632:6952360634-7082998907:7082998909-7082999019:7082999021-7083278206:7083278208-7116953104:7116953106-7117037452:7117037454-7279598596:7279598598-7308361972:7308361974-7356967937:7356967939-7378393202:7378393204-7553206685:7553206687-7627358235:7627358237-7678538522:7678538524-7749717078:7749717080-7809852289:7809852291-7856817525:7856817527-7856963020:7856963022-7901939177:7901939179:7901939181-7902114454:7902114456-7902115159:7902115161-7938637393:7938637395-8375568507:8375568509-8722598218:8722598220-8722837417:8722837419-8757109064:8757109066-8757577096:8757577098-8794786669:8794786671-8863789470:8863789472-8898080526:8898080528-8898095122:8898095124-8932067496:8932067498-9041774183:9041774185-9119991174:9119991176-9418627051:9418627053-9462060087:9462060089-9585237049:9585237051-9585459303:9585459305-9629912806:9629912808-9679094160:9679094162-9720405221:9720405223-9755947587:9755947589-9756098768:9756098770-9790742974:9790742976-9790901040:9790901042-9823533072:9823533074-9933553822:9933553824-9960892018:9960892020-10043661742:10043661744-10067758765:10067758767-10091070014:10091070016-10117968095:10117968097-10144638308:10144638310-10170301185:10170301187-10222580048:10222580050-10249314722:10249314724-10271498257:10271498259-10343660883:10343660885-10343665555:10343665557-10437658342:10437658344-10476925027:10476925029-10557028314:10557028316-10732024438:10732024440-10762285251:10762285253-10850660539:10850660541-11204464793:11204464795-11230279566:11230279568-11309391965:11309391967-11362171239:11362171241-11464384650:11464384652-11464865385:11464865387-11542140333:11542140335-11578434090:11578434092-11647413333:11647413335-13283173988:13283173990-13378439617:13378439619-13570862014:13570862016-13660237746:13660237748-13723586435:13723586437-13848211958:13848211960-13880591796:13880591798-13915801341:13915801343-13958838616:13958838618-13958977327:13958977329-13993518199:13993518201-14025098284:14025098286-14114884647:14114884649-14327360622:14327360624-14743487326:14743487328-14745017949:14745017951-14826133383:14826133385-14945983638:14945983640-14946150055:14946150057-14946151467:14946151469-15168594975:15168594977-15335776300:15335776302-15668413988
                Auto_Position: 0
         Replicate_Rewrite_DB: 
                 Channel_Name: 
           Source_TLS_Version: 
       Source_public_key_path: 
        Get_Source_public_key: 1
            Network_Namespace: 
1 row in set (0.00 sec)

ERROR: 
No query specified

复制

2、停止slave、reset slave、change replication source、启动slave

mysql> stop slave;
mysql> reset slave;
mysql> CHANGE REPLICATION SOURCE TO
  SOURCE_HOST='主库ip',
  SOURCE_USER='repl',
  SOURCE_PASSWORD='******',
  SOURCE_PORT=端口,
  SOURCE_AUTO_POSITION=1,
  get_master_public_key=1;

mysql> start slave;
复制

但是，start slave后发现Source_Log_File（mysql-bin.021400）和reset之前的Source_Log_File（mysql-bin.02153）相比落后了100多个文件，如下图所示：

很显然这是有问题的，再进一步检查show replica status的输出：可以看到Auto_Position=0，说明最开始搭建主从复制环境的时候并没有使用gtid搭建（别人挖的坑啊），使用的binlog位点信息，因此不能使用上面的基于GTID（全局事务标识符）的复制命令。

需要使用基于位点信息的复制命令：

mysql> CHANGE REPLICATION SOURCE TO SOURCE_LOG_FILE='mysql-bin.021503', SOURCE_LOG_POS=401678003;
mysql> start slave;
复制

位点信息的确定需参考下图：

3、查看主从复制状态信息：

mysql> show replica status \G;
*************************** 1. row ***************************
             Replica_IO_State: Waiting for source to send event
                  Source_Host: *.*.*.*
                  Source_User: repl
                  Source_Port: 3306
                Connect_Retry: 10
              Source_Log_File: mysql-bin.021508
          Read_Source_Log_Pos: 606783147
               Relay_Log_File: host-*-*-*-*-relay-bin.000002
                Relay_Log_Pos: 287007748
        Relay_Source_Log_File: mysql-bin.021503
           Replica_IO_Running: Yes
          Replica_SQL_Running: Yes
              Replicate_Do_DB: 
          Replicate_Ignore_DB: 
           Replicate_Do_Table: 
       Replicate_Ignore_Table: 
      Replicate_Wild_Do_Table: 
  Replicate_Wild_Ignore_Table: 
                   Last_Errno: 0
                   Last_Error: 
                 Skip_Counter: 0
          Exec_Source_Log_Pos: 688685425
              Relay_Log_Space: 5573819262
              Until_Condition: None
               Until_Log_File: 
                Until_Log_Pos: 0
           Source_SSL_Allowed: No
           Source_SSL_CA_File: 
           Source_SSL_CA_Path: 
              Source_SSL_Cert: 
            Source_SSL_Cipher: 
               Source_SSL_Key: 
        Seconds_Behind_Source: 15125
Source_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error: 
               Last_SQL_Errno: 0
               Last_SQL_Error: 
  Replicate_Ignore_Server_Ids: 
             Source_Server_Id: 348020445
                  Source_UUID: e63fb3d3-d561-11ec-903f-fa163e3a2e10
             Source_Info_File: mysql.slave_master_info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
    Replica_SQL_Running_State: Waiting for dependent transaction to commit
           Source_Retry_Count: 3
                  Source_Bind: 
      Last_IO_Error_Timestamp: 
     Last_SQL_Error_Timestamp: 
               Source_SSL_Crl: 
           Source_SSL_Crlpath: 
           Retrieved_Gtid_Set: e63fb3d3-d561-11ec-903f-fa163e3a2e10:15668413983-15675768093
            Executed_Gtid_Set: 192e0886-fd51-11ed-907e-fa163e019833:1-3177,
52db70d3-8d51-11ee-b067-fa163e019833:1-6863,
68839d23-fe38-11ed-911c-fa163e8fa5fa:9-44:46-112:114-173:175-316:318-929:931-946:948-969:971-985:987-999:1001-1025:1027-1057:1059-1073:1075-1099:1101-1115:1117-1131:1133-1145:1147-1159:1161-1218:1220-2649:2651-2862:2864-2876:2878-2986:2988-3018:3020-3048:3050-3082:3084-3098:3100-4237743:4237746-4237809:4237811:4237813-4237815:4237817-4237818:4237821-4338470:4338472-4350453:4350455-4353088:4353090-4420774:4420776-4420835:4420837-28493553:28493555-28561766:28561768-28561774:28561776-28561786:28561788-31699768:31699770-31699782:31699784-31699824:31699826-31699890:31699892-31699917:31699919-31699968:31699970-31700030:31700032-31700044:31700046-31700260:31700262-31700299:31700301-31700313:31700315-31700339:31700341-31700365:31700367-31700380:31700383-31700397:31700399-31700423:31700425-31700439:31700441-31700464:31700466-31700480:31700482-31700507:31700509-31700535:31700537-31700549:31700551-31700565:31700567-31700581:31700583-31700607:31700609-31700610:31700612-31700623:31700625-31700636:31700638-31700718:31700720-31700732:31700734-31700747:31700749-31700808:31700810-31700825:31700827-31707060:31707062-31707232:31707234-31707245:31707247-31707292:31707294-31707305:31707307-31707317:31707319-31707443:31707445-31707524:31707526-31707547:31707549-31707561:31707563-31707577:31707579-31707635:31707637-31707676:31707678-31707702:31707704-31707717:31707719-31707734:31707736-31707751:31707753-31707768:31707770-31707784:31707786-31707796:31707798-31707808:31707810-31707820:31707822-31707832:31707834-31707848:31707850-31707864:31707866-31707880:31707882-31707896:31707898-31707961:31707963-31707974:31707976-31707999:31708001-31708023:31708025-31708071:31708073-31708106:31708108-31708119:31708121-31708132:31708134-31708145:31708147-31708160:31708162-31708174:31708176-31708206:31708208-31708222:31708224-31708234:31708236-31708246:31708248-31708276:31708278-31708292:31708294-31708305:31708307-31708320:31708322-31708350:31708352-31708410:31708412-31708432:31708434-31708455:31708457:31708459-31708480:31708482:31708484-31708505:31708508-31708530:31708532-31708544:31708546-31708553:31708555-31708566:31708568-31708581:31708583-31708596:31708598-31708609:31708611-31708622:31708624-31708635:31708637-31708648:31708650-31708661:31708663-31708676:31708678-31708692:31708694-31708707:31708709-31708722:31708724-31708733:31708735-31708744:31708746-31708760:31708762-31708776:31708778-31708791:31708793-31708802:31708804-31708813:31708815-31708828:31708830-31708843:31708845-31708858:31708860-31708915:31708917-31708928:31708930-31708951:31708953-31708966:31708968-31708979:31708981-31708997:31708999-31709018:31709020-31709043:31709045-31709082:31709084-31709095:31709097-31709108:31709110-31709119:31709121-31709131:31709133-31709147:31709149-31709163:31709165-31709179:31709181-31709193:31709195-31709208:31709210-31709224:31709226-31709240:31709242-31709255:31709257-31709266:31709268-31709277:31709279-31709288:31709290-31709299:31709301-31709314:31709316-31709330:31709332-31709345:31709347-31709379:31709382-31709392:31709394-31709406:31709408-31709452:31709454-31709465:31709467-31709486:31709488-31709505:31709507-31709600:31709602-31709642:31709644-31709714:31709716-31709752:31709754-31709813:31709815-31709828:31709830-31709851:31709853-31709870:31709872-31709894:31709896-31709913:31709915-31709927:31709929-31709955:31709957-31709971:31709973-31709985:31709987-31710001:31710003-31710017:31710019-31710033:31710035-31710045:31710047-31710057:31710059-31710069:31710071-31710085:31710087-31710102:31710104-31710118:31710120-31710134:31710136-31710173:31710175-31710280:31710282-31710295:31710297-31710342:31710344-31710358:31710360-31710407:31710409-31710489:31710492-31710621:31710623-31711440:31711442-31711457:31711459-31711471:31711473-31711502:31711504-31711531:31711533-31711547:31711549-31711563:31711565-31711579:31711581-31711593:31711595-31711610:31711612-31711627:31711629-31711674:31711676-31711713:31711715-31711779:31711781-31711817:31711819-31711843:31711845-31711909:31711911-31711923:31711925-31711937:31711939-31711995:31711997-31712007:31712009-31712019:31712021-31712034:31712036-31712050:31712052-31712067:31712069-31712079:31712081-31712091:31712093-31712103:31712105-31712137:31712139-31712207:31712209-31712273:31712275-31712299:31712301-31712329:31712331-31712343:31712345-31712358:31712360-31712399:31712401-31712415:31712417-31712431:31712433-31712443:31712445-31712467:31712469-31712483:31712485-31712497:31712499-31712512:31712514-31712528:31712530-31712546:31712548-31712617,
72a88277-e9b7-11ed-84ef-fa163e8fa5fa:1-21500,
e63fb3d3-d561-11ec-903f-fa163e3a2e10:1-134465377:134465379-900065153:900065155-1034360842:1034360844-1319424325:1319424327-2376664724:2376664726-2688275731:2688275733-2942117893:2942117895-3055610734:3055610736-3110516887:3110516889-3162789321:3162789323-3194017029:3194017031-3377170244:3377170246-3516021990:3516021992-3601595567:3601595569-3676436574:3676436576-4072837184:4072837186-4105023721:4105023723-4105281121:4105281123-4171423004:4171423006-4171427461:4171427463-4312402279:4312402281-4357118940:4357118942-4377520822:4377520824-4443472687:4443472689-4660449692:4660449694-4794520348:4794520350-4825296099:4825296101-5416736425:5416736427-5530274803:5530274805-5565913624:5565913626-5635200656:5635200658-5754309089:5754309091-5982841559:5982841561-6011739614:6011739616-6099119901:6099119903-6099121013:6099121015-6130983497:6130983499-6184623322:6184623324-6184634915:6184634917-6228825865:6228825867-6314343058:6314343060-6314544281:6314544283-6349178487:6349178489-6399608352:6399608354-6587916983:6587916985-6952360632:6952360634-7082998907:7082998909-7082999019:7082999021-7083278206:7083278208-7116953104:7116953106-7117037452:7117037454-7279598596:7279598598-7308361972:7308361974-7356967937:7356967939-7378393202:7378393204-7553206685:7553206687-7627358235:7627358237-7678538522:7678538524-7749717078:7749717080-7809852289:7809852291-7856817525:7856817527-7856963020:7856963022-7901939177:7901939179:7901939181-7902114454:7902114456-7902115159:7902115161-7938637393:7938637395-8375568507:8375568509-8722598218:8722598220-8722837417:8722837419-8757109064:8757109066-8757577096:8757577098-8794786669:8794786671-8863789470:8863789472-8898080526:8898080528-8898095122:8898095124-8932067496:8932067498-9041774183:9041774185-9119991174:9119991176-9418627051:9418627053-9462060087:9462060089-9585237049:9585237051-9585459303:9585459305-9629912806:9629912808-9679094160:9679094162-9720405221:9720405223-9755947587:9755947589-9756098768:9756098770-9790742974:9790742976-9790901040:9790901042-9823533072:9823533074-9933553822:9933553824-9960892018:9960892020-10043661742:10043661744-10067758765:10067758767-10091070014:10091070016-10117968095:10117968097-10144638308:10144638310-10170301185:10170301187-10222580048:10222580050-10249314722:10249314724-10271498257:10271498259-10343660883:10343660885-10343665555:10343665557-10437658342:10437658344-10476925027:10476925029-10557028314:10557028316-10732024438:10732024440-10762285251:10762285253-10850660539:10850660541-11204464793:11204464795-11230279566:11230279568-11309391965:11309391967-11362171239:11362171241-11464384650:11464384652-11464865385:11464865387-11542140333:11542140335-11578434090:11578434092-11647413333:11647413335-13283173988:13283173990-13378439617:13378439619-13570862014:13570862016-13660237746:13660237748-13723586435:13723586437-13848211958:13848211960-13880591796:13880591798-13915801341:13915801343-13958838616:13958838618-13958977327:13958977329-13993518199:13993518201-14025098284:14025098286-14114884647:14114884649-14327360622:14327360624-14743487326:14743487328-14745017949:14745017951-14826133383:14826133385-14945983638:14945983640-14946150055:14946150057-14946151467:14946151469-15168594975:15168594977-15335776300:15335776302-15668800373
                Auto_Position: 0
         Replicate_Rewrite_DB: 
                 Channel_Name: 
           Source_TLS_Version: 
       Source_public_key_path: 
        Get_Source_public_key: 1
            Network_Namespace: 
1 row in set (0.00 sec)

ERROR: 
No query specified

mysql> 
复制

从库的IO THREAD 和 SQL THREAD已经恢复正常。
Replica_IO_Running: Yes
Replica_SQL_Running: Yes

但是从库还是落后于主库一段时间（Seconds_Behind_Source: 15125），等待从库慢慢追平主库即可。

等待的时间可以喝杯咖啡（自由发挥），干点别的…

最后检查主从复制状态，正常，整个问题处理过程到此结束！

总结

整个处理过程主要是依次执行stop slave、reset slave、change replication source、start slave命令，但是在执行change replication source的时候要检查是否使用了基于gtid的复制，如果没使用基于gtid的复制，就要找到合适的binlog位点信息。总之，做维护操作一定知道自己在干啥，要做好检查，并确保每一步操作都是行之有效的。

关于作者：
网名：飞天，墨天轮2024年度优秀原创作者，拥有 Oracle 10g OCM 认证、PGCE认证以及OBCA、KCP、ACP、磐维等众多国产数据库认证证书，目前从事Oracle、Mysql、PostgresSQL、磐维数据库管理运维工作，喜欢结交更多志同道合的朋友，热衷于研究、分享数据库技术。
微信公众号：飞天online
墨天轮：https://www.modb.pro/u/15197
如有任何疑问，欢迎大家留言，共同探讨~~~