Shulou(Shulou.com)06/01 Report--

RESET MASTER can be used to clear the execution history of GTID. If you want to add a node that has performed a local transaction to Group Replication, execute RESET MASTER.

Executing RESET MASTER has the following effects:

The global system variable gtid_purged is set to null.

The global system variable gtid_executed is set to null.

The system table mysql.gtid_executed is cleared.

·If binary logging is enabled, binary logs and log index files are cleaned.

When you say RESET MASTER, you might think RESET SLAVE, but executing RESET SLAVE doesn't clear the execution history of GTID, it clears mysql.slave_relay_log_info, mysql.slave_worker_info tables, and cleans relay logs.

RESET SLAVE is often associated with RESET SLAVE ALL, which, in addition to completing the RESET SLAVE action, clears the mysql.slave_master_info table, deletes all replication channels, and then creates the default channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.