Re: How to accelerate mysql restart speed if change mysql ip?
I havn't executed above command due to other reason, but has the following log:
2022-07-01T07:01:23.569098Z 4 [System] [MY-010558] [Repl] Slave for channel '': received end packet from server due to dump thread being killed on master. Dump threads are killed for example during master shutdown, explicitly by a user, or when the master receives a binlog send request from a duplicate server UUID <dc21e33f-bd7f-22ea-8fa0-fa152e67a1d5> : Error
2022-07-01T07:01:23.569188Z 4 [Warning] [MY-010897] [Repl] 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.
2022-07-01T07:01:23.569346Z 4 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error reconnecting to master 'replication@172.16.70.100:3306' - retry-time: 60 retries: 1 message: Can't connect to MySQL server on '172.16.70.100' (111), Error_code: MY-002003
2022-07-01T07:02:23.578159Z 4 [System] [MY-010592] [Repl] Slave for channel '': connected to master 'replication@172.16.70.100:3306',replication resumed in log 'mysql-bin.000136' at position 155
2022-07-01T07:25:03.107091Z 4 [System] [MY-010558] [Repl] Slave for channel '': received end packet from server due to dump thread being killed on master. Dump threads are killed for example during master shutdown, explicitly by a user, or when the master receives a binlog send request from a duplicate server UUID <dc21e33f-bd7f-22ea-8fa0-fa152e67a1d5> : Error
2022-07-01T07:25:03.107188Z 4 [Warning] [MY-010897] [Repl] 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.
2022-07-01T07:25:03.112502Z 4 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error reconnecting to master 'replication@172.16.70.100:3306' - retry-time: 60 retries: 1 message: Can't connect to MySQL server on '172.16.70.100' (111), Error_code: MY-002003
2022-07-01T07:25:28.832744Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.
Subject
Written By
Posted
Re: How to accelerate mysql restart speed if change mysql ip?
July 30, 2022 12:35AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.