November 11, 2014

MySQL 5.7.5 : GTID_EXECUTED系统表

Gtid是从5.6开始推出的杀手级特性,通过GTID特性,极大的提升了主备切换的效率和一致性,想了解GTID内部实现的朋友可以参阅我之前写的这篇博客:http://mysqllover.com/?p=594 在MySQL5.7.5里引入了一个新的系统表GTID_EXECUTED: root@mysql 11:29:40>SHOW CREATE TABLE mysql.gtid_executed\G *************************** 1. row ***************************        Table: gtid_executed Create Table: CREATE TABLE `gtid_executed` (   `source_uuid` char(36) NOT NULL COMMENT ‘uuid of the source where the transaction was originally executed.’,   `interval_start` bigint(20) NOT NULL COMMENT ‘First number of interval.’,   `interval_end` bigint(20) NOT NULL COMMENT ‘Last […]