MySQL 5.7如何使用GTID方式搭建复制环境( 二 )


SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set: cf291e84-2c89-11e6-b6f0-000c29631605:1
Executed_Gtid_Set: cf291e84-2c89-11e6-b6f0-000c29631605:1
Auto_Position: 1
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
1 row in set (0.00 sec)
【MySQL 5.7如何使用GTID方式搭建复制环境】mysql show processlist;
+ -+ -+ + + + + + +
| Id | User| Host| db| Command | Time | State| Info|
+ -+ -+ + + + + + +
|4 | root| localhost | fire | Query|0 | starting| show processlist |
|6 | system user || NULL | Connect |480 | Waiting for master to send event| NULL|
|7 | system user || NULL | Connect |153 | Slave has read all relay log; waiting for more updates | NULL|
+ -+ -+ + + + + + +
3 rows in set (0.02 sec)
以上是“MySQL 5.7如何使用GTID方式搭建复制环境”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注行业资讯频道!

推荐阅读