master/slave 相同server_id引起的同步失败
mysql> SHOW RELAYLOG EVENTS in 'sht-sgmhadoopdn-02-relay-bin.000005';+-------------------------------------+------+----------------+-----------+-------------+---------------------------------------------------------------------+
| Log_name | Pos| Event_type | Server_id | End_log_pos | Info |
+-------------------------------------+------+----------------+-----------+-------------+---------------------------------------------------------------------+
| sht-sgmhadoopdn-02-relay-bin.000005 | 4 | Format_desc | 593306 | 123 | Server ver: 5.7.21-log, Binlog ver: 4 |
| sht-sgmhadoopdn-02-relay-bin.000005 |123 | Previous_gtids | 593306 | 194 | 8b94d944-34c8-11e8-9e15-0050568211bd:1-144 |
| sht-sgmhadoopdn-02-relay-bin.000005 |194 | Rotate | 583306 | 0 | mysql-bin.000001;pos=4 |
| sht-sgmhadoopdn-02-relay-bin.000005 |241 | Format_desc | 583306 | 123 | Server ver: 5.7.21-log, Binlog ver: 4 |
| sht-sgmhadoopdn-02-relay-bin.000005 |360 | Rotate | 0 | 407 | mysql-bin.000001;pos=154 |
| sht-sgmhadoopdn-02-relay-bin.000005 |407 | Rotate | 0 | 454 | mysql-bin.000001;pos=37623 |
| sht-sgmhadoopdn-02-relay-bin.000005 |454 | Gtid | 583306 | 37688 | SET @@SESSION.GTID_NEXT= '8b94d944-34c8-11e8-9e15-0050568211bd:145' |
| sht-sgmhadoopdn-02-relay-bin.000005 |519 | Query | 583306 | 37807 | use `testdb`; DROP TABLE `t1` /* generated by server */ |
| sht-sgmhadoopdn-02-relay-bin.000005 |638 | Gtid | 583306 | 37872 | SET @@SESSION.GTID_NEXT= '8b94d944-34c8-11e8-9e15-0050568211bd:146' |
| sht-sgmhadoopdn-02-relay-bin.000005 |703 | Query | 583306 | 37964 | use `testdb`; create table t1 like t2 |
| sht-sgmhadoopdn-02-relay-bin.000005 |795 | Gtid | 583306 | 38029 | SET @@SESSION.GTID_NEXT= '8b94d944-34c8-11e8-9e15-0050568211bd:147' |
| sht-sgmhadoopdn-02-relay-bin.000005 |860 | Query | 583306 | 38148 | use `testdb`; DROP TABLE `t1` /* generated by server */ |
| sht-sgmhadoopdn-02-relay-bin.000005 |979 | Gtid | 583306 | 38213 | SET @@SESSION.GTID_NEXT= '8b94d944-34c8-11e8-9e15-0050568211bd:148' |
| sht-sgmhadoopdn-02-relay-bin.000005 | 1044 | Query | 583306 | 38329 | use `testdb`; create table t1(c1 int,c2 varchar(20)) |
| sht-sgmhadoopdn-02-relay-bin.000005 | 1160 | Gtid | 583306 | 38394 | SET @@SESSION.GTID_NEXT= '8b94d944-34c8-11e8-9e15-0050568211bd:149' |
| sht-sgmhadoopdn-02-relay-bin.000005 | 1225 | Query | 583306 | 38468 | BEGIN |
| sht-sgmhadoopdn-02-relay-bin.000005 | 1299 | Table_map | 583306 | 38518 | table_id: 228 (testdb.t1) |
| sht-sgmhadoopdn-02-relay-bin.000005 | 1349 | Write_rows | 583306 | 38562 | table_id: 228 flags: STMT_END_F |
| sht-sgmhadoopdn-02-relay-bin.000005 | 1393 | Xid | 583306 | 38593 | COMMIT /* xid=3689 */ |
+-------------------------------------+------+----------------+-----------+-------------+---------------------------------------------------------------------+
页:
[1]