mgr8.0.32 从节点删数据后 主节点数据也没了
mgr8.0.32 从节点删数据后 主节点数据也没了{
"clusterName": "test01",
"defaultReplicaSet": {
"name": "default",
"primary": "10.33.0.18:3306",
"ssl": "REQUIRED",
"status": "OK",
"statusText": "Cluster is ONLINE and can tolerate up to ONE failure.",
"topology": {
"10.33.0.17:3306": {
"address": "10.33.0.17:3306",
"memberRole": "ARBITRATOR",
"mode": "R/O",
"readReplicas": {},
"replicationLag": null,
"role": "HA",
"status": "ONLINE",
"version": "8.0.32"
},
"10.33.0.18:3306": {
"address": "10.33.0.18:3306",
"memberRole": "PRIMARY",
"mode": "R/W",
"readReplicas": {},
"replicationLag": null,
"role": "HA",
"status": "ONLINE",
"version": "8.0.32"
},
"10.33.0.19:3306": {
"address": "10.33.0.19:3306",
"instanceErrors": [
"WARNING: Instance is NOT a PRIMARY but super_read_only option is OFF."
],
"memberRole": "SECONDARY",
"mode": "R/W",
"readReplicas": {},
"replicationLag": null,
"role": "HA",
"status": "ONLINE",
"version": "8.0.32"
}
},
"topologyMode": "Single-Primary"
},
"groupInformationSourceMember": "10.33.0.18:3306"
}
# ./gt-checksum -f gc.conf
-- gt-checksum init configuration files --
-- gt-checksum init log files --
-- gt-checksum init check parameter --
-- gt-checksum init check table name --
-- gt-checksum init check table column --
-- gt-checksum init check table index column --
-- gt-checksum init source and dest transaction snapshoot conn pool --
-- gt-checksum init cehck table query plan and check data --
begin checkSum index table C_STATION.LANE_EXIT_TRADE
[███████ ]100%task: 7/7
table C_STATION.LANE_EXIT_TRADE checksum complete
** gt-checksum Overview of results **
Check time:9.43s (Seconds)
Schema Table IndexCol checkMod Rows Differences Datafix
C_STATION LANE_EXIT_TRADE trade_id rows 63463,63557 no file
这里的row跟实际count(1)的数据量完全不对 请注意提问的艺术 mgr集群数据同步取决于节点的binlog，而不是集群的角色，事物没有忽略binlog是会在mgr节点间相互同步的。
-- Instance is NOT a PRIMARY but super_read_only option is OFF
说明mgr从节点的 super_read_only =off,超级用户权限在从节点是可以发生事物的 且 产生binlog ，该事物会同步到mgr的其他非操作节点
页:
[1]