mysql 5.7/5.6 gtid环境建立主从,从库没有数据

一、mysql 5.7/5.6  gtid环境:
通过mysqldump方式建立主从,发现从库没有表结构/数据,原因: 
mysqldump 添加参数 --set-gtid-purged=on/auto,会在dump的文件中添加 SET @@SESSION.SQL_LOG_BIN= 0;
This option enables control over global transaction ID (GTID) information written to the dump file, by indicating whether to add a SET @@global.gtid_purged statement to the output. This option may also cause a statement to be written to the output that disables binary logging while the dump file is being reloaded.
https://bugs.mysql.com/bug.php?id=77845
https://dev.mysql.com/doc/refm ... urged

0 个评论

要回复文章请先登录注册