mysql 5.6 disable GTID replication

                                                                          mysql 5.6 disable GTID replication

disable GTID replication (mysql 5.6)

1. 设置从库read_only

SET GLOBAL read_only=1;
从库read_only=1不会影响sql_thread线程，read_only是GLOBAL参数设置后会立即对所有连接生效(包括之前已存在的连接)

2. 停从库复制线程

stop slave;

3.  使用MASTER_LOG_FILE和MASTER_LOG_POS 进行change master

change master to master_host='172.172.178.75',master_port=3306,master_user='repl',master_password='root',master_log_file='3306-bin.000056',master_log_pos=897553222,MASTER_AUTO_POSITION = 0;
##以从库的Relay_Master_Log_File和Exec_Master_Log_Pos 作为MASTER_LOG_FILE和MASTER_LOG_POS 来指定复制开始位置。
##必须要指定MASTER_AUTO_POSITION = 0，否则会有如下报错:
ERROR 1776 (HY000): Parameters MASTER_LOG_FILE, MASTER_LOG_POS, RELAY_LOG_FILE and RELAY_LOG_POS cannot be set when MASTER_AUTO_POSITION is active.

4. 开始从库复制线程

start slave;

##注意这里我们并没有关闭主从库的GTID_MODE
##因为我们没有关闭主从库的GTID_MODE,log_slave_update,enforce-gtid-consistency 等GTID必须的参数，所以如果此时我们想重新切换为GTID复制就很简单了
先停从库复制,再通过MASTER_AUTO_POSITION = 1指定从库并启动复制
stop slave;

CHANGE MASTER TO
    MASTER_HOST = '172.172.178.75',
    MASTER_PORT = 3306,
    MASTER_USER = 'repl',
    MASTER_PASSWORD = 'root',
    MASTER_AUTO_POSITION = 1;
    
start slave;

mysql 5.6官方文档上关于怎么关闭GTID replication 只找到下面这一句话：

"To revert to the older file-based replication protocol after using GTIDs, you can issue a new CHANGE MASTER TO statement that specifies MASTER_AUTO_POSITION = 0, as well as at least one of MASTER_LOG_FILE or MASTER_LOG_POS."

参考链接：

http://blog.youkuaiyun.com/shaochenshuo/article/details/54862603
http://blog.youkuaiyun.com/shaochenshuo/article/details/54138317
http://blog.youkuaiyun.com/shaochenshuo/article/details/54138317
http://dev.mysql.com/doc/mysql-replication-excerpt/5.6/en/replication-gtids-concepts.html
http://dev.mysql.com/doc/mysql-replication-excerpt/5.7/en/replication-gtids-concepts.html?ff=nopfpls
https://dev.mysql.com/worklog/task/?spm=5176.100239.blogcont41200.6.xtY06T&id=7083