记一次 dr_auto_sync 计划内的切换测试过程

[{  "group_id": "pd",  "group_index": 0,  "group_override": false,  "rules": [    {      "group_id": "pd",      "id": "voters",      "start_key": "",      "end_key": "",      "role": "voter",      "count": 2,      "location_labels": ["dc", "logic", "rack", "host"],      "label_constraints": [{"key": "dc", "op": "in", "values": ["dc2"]}]    },    {      "group_id": "pd",      "id": "followers",      "start_key": "",      "end_key": "",      "role": "follower",      "count": 1,      "location_labels": ["dc", "logic", "rack", "host"],      "label_constraints": [{"key": "logic", "op": "in", "values": ["logic2"]}]    },    {      "group_id": "pd",      "id": "learners",      "start_key": "",      "end_key": "",      "role": "learner",      "count": 1,      "location_labels": ["dc", "logic", "rack", "host"],      "label_constraints": [{"key": "logic", "op": "in", "values": ["logic1"]}]    }  ]}]

[tidb@tidb1 dr_auto_sync]$ tiup ctl:v7.1.5 pd -u http://10.211.55.20:2379 member leader transfer pd-10.211.55.23-2379Starting component ctl: /home/tidb/.tiup/components/ctl/v7.1.5/ctl pd -u http://10.211.55.20:2379 member leader transfer pd-10.211.55.23-2379Success![tidb@tidb1 dr_auto_sync]$ tiup ctl:v7.1.5 pd -u http://10.211.55.20:2379 member leader showStarting component ctl: /home/tidb/.tiup/components/ctl/v7.1.5/ctl pd -u http://10.211.55.20:2379 member leader show{"name": "pd-10.211.55.23-2379","member_id": 11296243912059560318,"peer_urls": [  "http://10.211.55.23:2380"],"client_urls": [  "http://10.211.55.23:2379"]}

[tidb@tidb1 dr_auto_sync]$ tiup ctl:v7.1.5 pd -u http://10.211.55.20:2379 member leader_priority pd-10.211.55.20-2379 1Starting component ctl: /home/tidb/.tiup/components/ctl/v7.1.5/ctl pd -u http://10.211.55.20:2379 member leader_priority pd-10.211.55.20-2379 1Success![tidb@tidb1 dr_auto_sync]$ [tidb@tidb1 dr_auto_sync]$ tiup ctl:v7.1.5 pd -u http://10.211.55.20:2379 member leader_priority pd-10.211.55.23-2379 5Starting component ctl: /home/tidb/.tiup/components/ctl/v7.1.5/ctl pd -u http://10.211.55.20:2379 member leader_priority pd-10.211.55.23-2379 5Success!

[tidb@tidb1 dr_auto_sync]$ tiup ctl:v7.1.5 pd -u http://10.211.55.20:2379 config placement-rules rule-bundle save --in="/home/tidb/dr_auto_sync/rules_reverse.json" Starting component ctl: /home/tidb/.tiup/components/ctl/v7.1.5/ctl pd -u http://10.211.55.20:2379 config placement-rules rule-bundle save --in=/home/tidb/dr_auto_sync/rules_reverse.json"Update rules and groups successfully."​[tidb@tidb1 dr_auto_sync]$ tiup ctl:v7.1.5 pd -u http://10.211.55.20:2379 config placement-rules show Starting component ctl: /home/tidb/.tiup/components/ctl/v7.1.5/ctl pd -u http://10.211.55.20:2379 config placement-rules show[{  "group_id": "pd",  "id": "followers",  "start_key": "",  "end_key": "",  "role": "follower",  "is_witness": false,  "count": 1,  "label_constraints": [    {      "key": "logic",      "op": "in",      "values": [        "logic2"      ]    }  ],  "location_labels": [    "dc",    "logic",    "rack",    "host"  ],  "create_timestamp": 1719635156},{  "group_id": "pd",  "id": "learners",  "start_key": "",  "end_key": "",  "role": "learner",  "is_witness": false,  "count": 1,  "label_constraints": [    {      "key": "logic",      "op": "in",      "values": [        "logic1"      ]    }  ],  "location_labels": [    "dc",    "logic",    "rack",    "host"  ],  "version": 1},{  "group_id": "pd",  "id": "voters",  "start_key": "",  "end_key": "",  "role": "voter",  "is_witness": false,  "count": 2,  "label_constraints": [    {      "key": "dc",      "op": "in",      "values": [        "dc2"      ]    }  ],  "location_labels": [    "dc",    "logic",    "rack",    "host"  ],  "version": 1}]​

[tidb@tidb1 dr_auto_sync]$ mysql -h10.211.55.20 -P4000 -uroot -prootWelcome to the MariaDB monitor. Commands end with ; or \g.Your MySQL connection id is 405Server version: 5.7.25-TiDB-v7.1.5 TiDB Server (Apache License 2.0) Enterprise Edition, MySQL 5.7 compatibleCopyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.​Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -A​Database changedMySQL [test]> select count(*) from test_part;+----------+| count(*) |+----------+| 1190420 |+----------+1 row in set (0.78 sec)​