mysql delete slave database

In the MySQL database master-slave architecture, the slave database (Slave) is usually used to back up the data of the master database (Master) and provide reading services. In some cases, it is necessary to temporarily or permanently delete the backup or read service of a slave database. This article will introduce how to delete the slave database on the master database.

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;

This will return a table containing the current slave library IP address, port number and some other information. Find the row containing the slave database you want to delete and note its “Server_id” value.

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 mysql delete slave database. For more information, please follow other related articles on the PHP Chinese website!