How to delete slave database in mysql

Step 1: Query the slave library information

Execute the following command in the main library to query the current slave library information:

SHOW SLAVE HOSTS;

Return a message containing the current slave library IP A table of addresses, port numbers, and some other information. Record the "Server_id" value of the row containing the slave database you want to delete.

Step 2: Stop replication with the slave library

Execute the following command in the main library to stop replication with the slave library:

STOP SLAVE;

Step 3: Delete the slave library record

Execute the following command in the main library to delete the slave library record:

DELETE FROM mysql.slave_master_info WHERE master_host='IP地址' AND master_port=端口号;
DELETE FROM mysql.slave_relay_log_info WHERE master_host='IP地址' AND master_port=端口号;
DELETE FROM mysql.slave_worker_info WHERE host='IP地址' AND port=端口号;

Replace "IP address" and "port number" with the actual values ​​of the slave library you want to delete.

Step 4: Delete the slave user

Execute the following command in the main library to delete the slave user:

DROP USER '用户名'@'IP地址';

Replace "user name" and "IP address" It is the actual value of the slave database user.

Step 5: Delete the binary log file of the slave library in the main library

Execute the following command in the main library to delete the binary log file of the slave library in the main library:

PURGE BINARY LOGS TO '主日志文件名称.日志文件编号';

Replace "main log file name" and "log file number" with the actual value of the last log file of the slave library in the main library.

Step 6: Delete the log files of the slave library in the slave library

Execute the following command in the slave library to delete the log files of the slave library in the slave library:

RESET SLAVE ALL;

Step 7: Restart master-slave replication

Execute the following command in the master database to restart master-slave replication:

START SLAVE;

Now, you have successfully deleted a slave in the MySQL master-slave architecture library. Please note that before deleting the slave database, please make sure that there are no important tasks and data transfers between your master database and other slave databases to avoid data loss during deletion.

The above is the detailed content of How to delete slave database in mysql. For more information, please follow other related articles on the PHP Chinese website!