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

This article mainly tells you about the detailed steps of switching from mysql and gtid replication to traditional replication. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope this article on mysql and gtid replication switching to traditional replication detailed steps can bring you some practical help.

Slave library

Stop slave

# # get Relay_Master_Log_File,Exec_Master_Log_Pos

Show slave status\ G

# close master_auto_position and start replication

Change master to master_host='192.168.56.100',master_port=3306,master_user='repl',master_password='rep123',master_log_file='mysql-bin.000010',master_log_pos=93784,master_auto_position=0

Start slave

# execute in master database and slave database respectively

Set global gtid_mode=ON_PERMISSIVE

# switch binlog when the master database executes and then execute in the slave database

Set global gtid_mode=OFF_PERMISSIVE

# execute in the master / slave library, and the result is empty

Select @ @ global.gtid_owned

# execute slave execution in the master database

Set global gtid_mode=OFF

Set global enforce_gtid_consistency=0

In the configuration file

[mysqld] partial add

Gtid-mode= OFF

Enforce_gtid_consistency=0

Mysql, gtid replication switch to traditional replication detailed steps to tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

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.