\u6211\u5728\u4ee5\u4e0b\u6bcf\u4e2a\u65f6\u95f4\u70b9\u6267\u884c\u4e86SHOW TABLE REGIONS\u547d\u4ee4\uff0c\u5e76\u786e\u8ba4\u4e86\u533a\u57df\u4fe1\u606f\u3002<\/p>\n
<\/p>\n
<\/p>\n
\u6211\u5728\u4ee5\u4e0b\u73af\u5883\u4e2d\u6d4b\u8bd5\u4e86 TiDB v7.0.0 \u7684\u8fd0\u884c\uff1a<\/p>\n
[root@tisim ~]# tiup cluster display demo-cluster\r\ntiup is checking updates for component cluster ...\r\nStarting component `cluster`: \/root\/.tiup\/components\/cluster\/v1.12.1\/tiup-cluster display demo-cluster\r\nCluster type: tidb\r\nCluster name: demo-cluster\r\nCluster version: v7.0.0\r\nDeploy user: tidb\r\nSSH type: builtin\r\nDashboard URL: http:\/\/192.168.3.171:2379\/dashboard\r\nGrafana URL: http:\/\/192.168.3.171:3000\r\nID Role Host Ports OS\/Arch Status Data Dir Deploy Dir\r\n-- ---- ---- ----- ------- ------ -------- ----------\r\n192.168.3.171:3000 grafana 192.168.3.171 3000 linux\/x86_64 Up - \/tidb-deploy\/grafana-3000\r\n192.168.3.171:2379 pd 192.168.3.171 2379\/2380 linux\/x86_64 Up|L|UI \/tidb-data\/pd-2379 \/tidb-deploy\/pd-2379\r\n192.168.3.171:9090 prometheus 192.168.3.171 9090\/12020 linux\/x86_64 Up \/tidb-data\/prometheus-9090 \/tidb-deploy\/prometheus-9090\r\n192.168.3.171:4000 tidb 192.168.3.171 4000\/10080 linux\/x86_64 Up - \/tidb-deploy\/tidb-4000\r\n192.168.3.171:9000 tiflash 192.168.3.171 9000\/8123\/3930\/20170\/20292\/8234 linux\/x86_64 Up \/tidb-data\/tiflash-9000 \/tidb-deploy\/tiflash-9000\r\n192.168.3.171:20160 tikv 192.168.3.171 20160\/20180 linux\/x86_64 Up \/tidb-data\/tikv-20160 \/tidb-deploy\/tikv-20160\r\n192.168.3.171:20161 tikv 192.168.3.171 20161\/20181 linux\/x86_64 Up \/tidb-data\/tikv-20161 \/tidb-deploy\/tikv-20161\r\n192.168.3.171:20162 tikv 192.168.3.171 20162\/20182 linux\/x86_64 Up \/tidb-data\/tikv-20162 \/tidb-deploy\/tikv-20162\r\nTotal nodes: 8\r\n<\/code><\/pre>\n\u786e\u8ba4\u533a\u57df\u4fe1\u606f<\/h1>\n
\u4f7f\u7528SHOW TABLE REGIONS\u8bed\u53e5\u67e5\u770btrips\u8868\u7684\u533a\u57df\u4fe1\u606f\u3002<\/p>\n
mysql> SHOW TABLE trips REGIONS;\r\n+-----------+---------------+--------------------+-----------+-----------------+------------------+------------+---------------+------------+----------------------+------------------+------------------------+------------------+\r\n| REGION_ID | START_KEY | END_KEY | LEADER_ID | LEADER_STORE_ID | PEERS | SCATTERING | WRITTEN_BYTES | READ_BYTES | APPROXIMATE_SIZE(MB) | APPROXIMATE_KEYS | SCHEDULING_CONSTRAINTS | SCHEDULING_STATE |\r\n+-----------+---------------+--------------------+-----------+-----------------+------------------+------------+---------------+------------+----------------------+------------------+------------------------+------------------+\r\n| 3005 | t_94_ | t_94_r_182668 | 3007 | 1 | 3006, 3007, 3008 | 0 | 27 | 0 | 39 | 177442 | | |\r\n| 3009 | t_94_r_182668 | t_94_r_595336 | 3011 | 1 | 3010, 3011, 3012 | 0 | 39 | 0 | 37 | 231736 | | |\r\n| 10 | t_94_r_595336 | t_281474976710654_ | 156 | 1 | 11, 156, 204 | 0 | 35241357 | 149414338 | 37 | 231736 | | |\r\n+-----------+---------------+--------------------+-----------+-----------------+------------------+------------+---------------+------------+----------------------+------------------+------------------------+------------------+\r\n3 rows in set (0.00 sec)\r\n<\/code><\/pre>\n\u53ef\u4ee5\u901a\u8fc7\u6307\u5b9a\u6761\u4ef6\u6765\u7b5b\u9009\u51fa\u6307\u5b9a\u7684\u884c\u3002\u5c06\u884c\u7684region_id\u8bbe\u4e3a3009\u5e76\u6267\u884c\u64cd\u4f5c\u3002<\/p>\n
mysql> SHOW TABLE trips REGIONS WHERE region_id = 3009 \\G\r\n*************************** 1. row ***************************\r\n REGION_ID: 3009\r\n START_KEY: t_94_r_182668\r\n END_KEY: t_94_r_595336\r\n LEADER_ID: 3011\r\n LEADER_STORE_ID: 1\r\n PEERS: 3010, 3011, 3012\r\n SCATTERING: 0\r\n WRITTEN_BYTES: 0\r\n READ_BYTES: 0\r\n APPROXIMATE_SIZE(MB): 60\r\n APPROXIMATE_KEYS: 388612\r\nSCHEDULING_CONSTRAINTS:\r\n SCHEDULING_STATE:\r\n1 row in set (0.00 sec)\r\n<\/code><\/pre>\n\u4ece\u5177\u6709region_id\u4e3a3009\u7684\u533a\u57df\u4fe1\u606f\u4e2d\u53ef\u4ee5\u5f97\u77e5\u4ee5\u4e0b\u4e8b\u9879\u3002<\/p>\n
\n- \n
start_key\u304ct_94_r_182668\u3001\u304b\u3064end_key\u304ct_94_r_595336\u3067\u3042\u308b\u4e8b\u304b\u3089\u3001\u3053\u3061\u3089\u306e\u30ea\u30fc\u30b8\u30e7\u30f3\u306e\u30ad\u30fc\u5024\u306e\u7bc4\u56f2\u304c\u3001182668\u304b\u3089595336\u3067\u3042\u308b\u4e8b\u304c\u308f\u304b\u308a\u307e\u3059\u3002\u307e\u305f\u3001\u30d7\u30ec\u30d5\u30a3\u30c3\u30af\u30b9\u306et_94\u306f\u3001\u30c6\u30fc\u30d6\u30ebid\u304c94\u3067\u3042\u308b\u3053\u3068\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/ul>\n<\/li>\n<\/ul>\n <\/p>\n
\n- \n
leader_id\u304c3011\u3067\u3001peers\u304c3010, 3011, 3012\u3067\u3042\u308b\u4e8b\u304b\u3089\u30013011\u306e\u30ea\u30fc\u30b8\u30e7\u30f3\u304c\u30ea\u30fc\u30c0(\u8aad\u307f\u66f8\u304d\u53ef\u80fd)\u3067\u30013010\u30683012\u306e\u30ea\u30fc\u30b8\u30e7\u30f3\u304c\u3001\u30ea\u30fc\u30c0\u306e\u30ec\u30d7\u30ea\u30ab\u3067\u3042\u308b\u4e8b\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/ul>\n<\/li>\n<\/ul>\n <\/p>\n
\n- \n
leader_store_id\u304c1\u3067\u3042\u308b\u4e8b\u304b\u3089\u30013011\u306e\u30ea\u30fc\u30b8\u30e7\u30f3\u306f\u3001id1\u306eTiKV\u306b\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u4e8b\u304c\u308f\u304b\u308a\u307e\u3059\u3002<\/ul>\n<\/li>\n<\/ul>\n <\/p>\n
\n- \n
approximate_size(MB)\u306e60\u306f\u3001\u3053\u3061\u3089\u306e\u30ea\u30fc\u30b8\u30e7\u30f3\u306b\u304a\u3088\u305d60MB\u306e\u30c7\u30fc\u30bf\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u4e8b\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/ul>\n<\/li>\n<\/ul>\n <\/p>\n
approximate_keys\u306e388612\u306f\u3001\u3053\u3061\u3089\u306e\u30ea\u30fc\u30b8\u30e7\u30f3\u306b\u304a\u3088\u305d388612\u500b\u306e\u30ad\u30fc\u5024\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u4e8b\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/ul>\n\u6bcf\u4e2a\u533a\u57df\u90fd\u6709\u4e00\u4e2a\u4e0a\u9650\u5927\u5c0f\uff08\u9ed8\u8ba4\u4e3a96MiB\uff09\uff0c\u5982\u679c\u8d85\u8fc7\u4e0a\u9650\uff0c\u5c06\u88ab\u5206\u4e3a\u4e24\u4e2a\u533a\u57df\u3002
\n\u533a\u57df\u7684\u9ed8\u8ba4\u5197\u4f59\u5ea6\u4e3a3\u3002<\/div>\n\u4ece\u4e0a\u8ff0\u72b6\u6001\u4e0b\u63d2\u5165\u4e86\u6570\u636e\u3002\u6211\u4eec\u5c06\u786e\u8ba4\u6570\u636e\u6dfb\u52a0\u540e\u7684\u533a\u57df\u4fe1\u606f\u3002<\/p>\n
mysql> SHOW TABLE trips REGIONS;\r\n+-----------+----------------+----------------+-----------+-----------------+------------------+------------+---------------+------------+----------------------+------------------+------------------------+------------------+\r\n| REGION_ID | START_KEY | END_KEY | LEADER_ID | LEADER_STORE_ID | PEERS | SCATTERING | WRITTEN_BYTES | READ_BYTES | APPROXIMATE_SIZE(MB) | APPROXIMATE_KEYS | SCHEDULING_CONSTRAINTS | SCHEDULING_STATE |\r\n+-----------+----------------+----------------+-----------+-----------------+------------------+------------+---------------+------------+----------------------+------------------+------------------------+------------------+\r\n| 3005 | t_94_ | t_94_r_182668 | 3007 | 1 | 3006, 3007, 3008 | 0 | 0 | 0 | 28 | 182223 | | |\r\n| 3013 | t_94_r_182668 | t_94_r_842765 | 3015 | 1 | 3014, 3015, 3016 | 0 | 39 | 0 | 41 | 243353 | | |\r\n| 3017 | t_94_r_842765 | t_94_r_1245906 | 3019 | 1 | 3018, 3019, 3020 | 0 | 0 | 0 | 21 | 123626 | | |\r\n| 3009 | t_94_r_1245906 | 78000000 | 3011 | 1 | 3010, 3011, 3012 | 0 | 161824266 | 0 | 21 | 123626 | | |\r\n+-----------+----------------+----------------+-----------+-----------------+------------------+------------+---------------+------------+----------------------+------------------+------------------------+------------------+\r\n4 rows in set (0.01 sec)\r\n<\/code><\/pre>\n\u5728\u6dfb\u52a0\u6570\u636e\u4e4b\u524d\uff0c3009\u533a\u57df\u7ba1\u7406182,668\u81f3595,336\u7684\u8303\u56f4\u3002\u4f46\u662f\uff0c\u5728\u6dfb\u52a0\u6570\u636e\u4e4b\u540e\uff0c\u5212\u5206\u4e863009\u533a\u57df\uff0c\u786e\u8ba4\u65b0\u76843013\u548c3017\u533a\u57df\u73b0\u5728\u7ba1\u7406\u4e0a\u8ff0\u8303\u56f4\u7684\u952e\u3002<\/p>\n
\u5f53TiKV\u53d1\u751f\u5f02\u5e38\u7ec8\u6b62\u65f6\uff0c\u8bf7\u786e\u8ba4\u5176\u64cd\u4f5c\u3002<\/h1>\n
\u6211\u4eec\u5c06\u6269\u5c55\u4e00\u4e2a TiKV \u8282\u70b9\uff0c\u5e76\u5728\u7531 4 \u4e2a TiKV \u8282\u70b9\u7ec4\u6210\u7684\u96c6\u7fa4\u4e2d\uff0c\u6d4b\u8bd5\u5728\u5f3a\u5236\u505c\u6b62\u4e00\u4e2a TiKV \u8282\u70b9\u65f6\u7684\u884c\u4e3a\u3002<\/p>\n
\u53cd\u6b63\u8bfbcmds\u5c31\u597d\u4e86<\/h3>\n
\u6839\u636eTiUP\u7684\u64cd\u4f5c\u6b65\u9aa4\uff0c\u6211\u4eec\u8fdb\u884c\u4e86TiDB\u96c6\u7fa4\u7684\u6269\u5bb9\u3002\u9996\u5148\uff0c\u9700\u8981\u51c6\u5907TiKV\u7684\u914d\u7f6e\u6587\u4ef6\u3002<\/p>\n
[root@tisim ~]# cat scale-out.yml\r\ntikv_servers:\r\n - host: 192.168.3.171\r\n port: 20163\r\n status_port: 20183\r\n config:\r\n server.labels: { host: \"logic-host-4\" }\r\n<\/code><\/pre>\n\u5982\u679c\u50cf\u4f5c\u8005\u7684\u73af\u5883\u4e00\u6837\uff0c\u5728\u4e00\u4e2a\u8282\u70b9\u4e0a\u7ec4\u5efa\u4e00\u4e2a TiKV \u96c6\u7fa4\u65f6\uff0c\u8bf7\u6ce8\u610f\u907f\u514d\u4e0e\u73b0\u6709\u7684 TiKV \u7aef\u53e3\u51b2\u7a81\u3002<\/div>\n\u6211\u4f1a\u5728\u4e8b\u524d\u8fdb\u884c\u68c0\u67e5\u3002<\/p>\n
[root@tisim ~]# tiup cluster check demo-cluster scale-out.yml --cluster --user root -p\r\ntiup is checking updates for component cluster ...\r\nStarting component `cluster`: \/root\/.tiup\/components\/cluster\/v1.12.1\/tiup-cluster check demo-cluster scale-out.yml --cluster --user root -p\r\nInput SSH password:\r\n\r\n+ Detect CPU Arch Name\r\n - Detecting node 192.168.3.171 Arch info ... Done\r\n\r\n+ Detect CPU OS Name\r\n - Detecting node 192.168.3.171 OS info ... Done\r\n+ Download necessary tools\r\n - Downloading check tools for linux\/amd64 ... Done\r\n+ Collect basic system information\r\n+ Collect basic system information\r\n - Getting system info of 192.168.3.171:22 ... Done\r\n+ Check time zone\r\n - Checking node 192.168.3.171 ... Done\r\n\r\n+ Check system requirements\r\n+ Check system requirements\r\n+ Check system requirements\r\n - Checking node 192.168.3.171 ... Done\r\n - Checking node 192.168.3.171 ... Done\r\n+ Cleanup check files\r\n - Cleanup check files on 192.168.3.171:22 ... Done\r\nNode Check Result Message\r\n---- ----- ------ -------\r\n192.168.3.171 thp Pass THP is disabled\r\n192.168.3.171 cpu-cores Pass number of CPU cores \/ threads: 4\r\n192.168.3.171 memory Pass memory size is 0MB\r\n192.168.3.171 network Pass network speed of enp0s3 is 1000MB\r\n192.168.3.171 selinux Pass SELinux is disabled\r\n192.168.3.171 command Pass numactl: policy: default\r\n192.168.3.171 os-version Pass OS is CentOS Linux 7 (Core) 7.9.2009\r\n192.168.3.171 cpu-governor Warn Unable to determine current CPU frequency governor policy\r\n192.168.3.171 disk Warn mount point \/ does not have 'noatime' option set\r\n<\/code><\/pre>\n\u5c3d\u7ba1\u6709\u4e00\u4e2a\u8b66\u544a\uff0c\u4f46\u6211\u5c06\u5ffd\u7565\u5b83\u5e76\u6267\u884c\u6269\u5bb9\u64cd\u4f5c\u3002<\/p>\n
[root@tisim ~]# tiup cluster scale-out demo-cluster scale-out.yml -p\r\ntiup is checking updates for component cluster ...\r\nStarting component `cluster`: \/root\/.tiup\/components\/cluster\/v1.12.1\/tiup-cluster scale-out demo-cluster scale-out.yml -p\r\nInput SSH password:\r\n\r\n+ Detect CPU Arch Name\r\n - Detecting node 192.168.3.171 Arch info ... Done\r\n\r\n+ Detect CPU OS Name\r\n - Detecting node 192.168.3.171 OS info ... Done\r\nPlease confirm your topology:\r\nCluster type: tidb\r\nCluster name: demo-cluster\r\nCluster version: v7.0.0\r\nRole Host Ports OS\/Arch Directories\r\n---- ---- ----- ------- -----------\r\ntikv 192.168.3.171 20163\/20183 linux\/x86_64 \/tidb-deploy\/tikv-20163,\/tidb-data\/tikv-20163\r\nAttention:\r\n 1. If the topology is not what you expected, check your yaml file.\r\n 2. Please confirm there is no port\/directory conflicts in same host.\r\nDo you want to continue? [y\/N]: (default=N)\r\n<\/code><\/pre>\n\u8f93\u5165y\u3002<\/p>\n
Do you want to continue? [y\/N]: (default=N) y\r\n+ [ Serial ] - SSHKeySet: privateKey=\/root\/.tiup\/storage\/cluster\/clusters\/demo-cluster\/ssh\/id_rsa, publicKey=\/root\/.tiup\/storage\/cluster\/clusters\/demo-cluster\/ssh\/id_rsa.pub\r\n+ [Parallel] - UserSSH: user=tidb, host=192.168.3.171\r\n+ [Parallel] - UserSSH: user=tidb, host=192.168.3.171\r\n+ [Parallel] - UserSSH: user=tidb, host=192.168.3.171\r\n+ [Parallel] - UserSSH: user=tidb, host=192.168.3.171\r\n+ [Parallel] - UserSSH: user=tidb, host=192.168.3.171\r\n+ [Parallel] - UserSSH: user=tidb, host=192.168.3.171\r\n+ [Parallel] - UserSSH: user=tidb, host=192.168.3.171\r\n+ [Parallel] - UserSSH: user=tidb, host=192.168.3.171\r\n+ Download TiDB components\r\n - Download tikv:v7.0.0 (linux\/amd64) ... Done\r\n+ Initialize target host environments\r\n+ Deploy TiDB instance\r\n - Deploy instance tikv -> 192.168.3.171:20163 ... Done\r\n+ Copy certificate to remote host\r\n+ Generate scale-out config\r\n - Generate scale-out config tikv -> 192.168.3.171:20163 ... Done\r\n+ Init monitor config\r\nEnabling component tikv\r\n Enabling instance 192.168.3.171:20163\r\n Enable instance 192.168.3.171:20163 success\r\nEnabling component node_exporter\r\n Enabling instance 192.168.3.171\r\n Enable 192.168.3.171 success\r\nEnabling component blackbox_exporter\r\n Enabling instance 192.168.3.171\r\n Enable 192.168.3.171 success\r\n+ [ Serial ] - Save meta\r\n+ [ Serial ] - Start new instances\r\nStarting component tikv\r\n Starting instance 192.168.3.171:20163\r\n Start instance 192.168.3.171:20163 success\r\nStarting component node_exporter\r\n Starting instance 192.168.3.171\r\n Start 192.168.3.171 success\r\nStarting component blackbox_exporter\r\n Starting instance 192.168.3.171\r\n Start 192.168.3.171 success\r\n+ Refresh components conifgs\r\n - Generate config pd -> 192.168.3.171:2379 ... Done\r\n - Generate config tikv -> 192.168.3.171:20160 ... Done\r\n - Generate config tikv -> 192.168.3.171:20161 ... Done\r\n - Generate config tikv -> 192.168.3.171:20162 ... Done\r\n - Generate config tikv -> 192.168.3.171:20163 ... Done\r\n - Generate config tidb -> 192.168.3.171:4000 ... Done\r\n - Generate config tiflash -> 192.168.3.171:9000 ... Done\r\n - Generate config prometheus -> 192.168.3.171:9090 ... Done\r\n - Generate config grafana -> 192.168.3.171:3000 ... Done\r\n+ Reload prometheus and grafana\r\n - Reload prometheus -> 192.168.3.171:9090 ... Done\r\n - Reload grafana -> 192.168.3.171:3000 ... Done\r\n+ [ Serial ] - UpdateTopology: cluster=demo-cluster\r\nScaled cluster `demo-cluster` out successfully\r\n<\/code><\/pre>\n\u786e\u8ba4\u6269\u5c55\u540e\u7684\u62d3\u6251\u7ed3\u6784\u3002\u53ef\u4ee5\u786e\u8ba4tikv-20163\u5982\u9884\u671f\u822c\u5df2\u6dfb\u52a0\u3002<\/p>\n
[root@tisim ~]# tiup cluster display demo-cluster\r\ntiup is checking updates for component cluster ...\r\nStarting component `cluster`: \/root\/.tiup\/components\/cluster\/v1.12.1\/tiup-cluster display demo-cluster\r\nCluster type: tidb\r\nCluster name: demo-cluster\r\nCluster version: v7.0.0\r\nDeploy user: tidb\r\nSSH type: builtin\r\nDashboard URL: http:\/\/192.168.3.171:2379\/dashboard\r\nGrafana URL: http:\/\/192.168.3.171:3000\r\nID Role Host Ports OS\/Arch Status Data Dir Deploy Dir\r\n-- ---- ---- ----- ------- ------ -------- ----------\r\n192.168.3.171:3000 grafana 192.168.3.171 3000 linux\/x86_64 Up - \/tidb-deploy\/grafana-3000\r\n192.168.3.171:2379 pd 192.168.3.171 2379\/2380 linux\/x86_64 Up|L|UI \/tidb-data\/pd-2379 \/tidb-deploy\/pd-2379\r\n192.168.3.171:9090 prometheus 192.168.3.171 9090\/12020 linux\/x86_64 Up \/tidb-data\/prometheus-9090 \/tidb-deploy\/prometheus-9090\r\n192.168.3.171:4000 tidb 192.168.3.171 4000\/10080 linux\/x86_64 Up - \/tidb-deploy\/tidb-4000\r\n192.168.3.171:9000 tiflash 192.168.3.171 9000\/8123\/3930\/20170\/20292\/8234 linux\/x86_64 Up \/tidb-data\/tiflash-9000 \/tidb-deploy\/tiflash-9000\r\n192.168.3.171:20160 tikv 192.168.3.171 20160\/20180 linux\/x86_64 Up \/tidb-data\/tikv-20160 \/tidb-deploy\/tikv-20160\r\n192.168.3.171:20161 tikv 192.168.3.171 20161\/20181 linux\/x86_64 Up \/tidb-data\/tikv-20161 \/tidb-deploy\/tikv-20161\r\n192.168.3.171:20162 tikv 192.168.3.171 20162\/20182 linux\/x86_64 Up \/tidb-data\/tikv-20162 \/tidb-deploy\/tikv-20162\r\n192.168.3.171:20163 tikv 192.168.3.171 20163\/20183 linux\/x86_64 Up \/tidb-data\/tikv-20163 \/tidb-deploy\/tikv-20163\r\nTotal nodes: 9\r\n<\/code><\/pre>\n\u5f3a\u5236\u505c\u6b62 TiKV.<\/h3>\n
\u67e5\u770b\u65c5\u884c\u8868\u7684\u5730\u533a\u4fe1\u606f\u3002<\/p>\n
mysql> SHOW TABLE trips REGIONS;\r\n+-----------+----------------+----------------+-----------+-----------------+------------------+------------+---------------+------------+----------------------+------------------+------------------------+------------------+\r\n| REGION_ID | START_KEY | END_KEY | LEADER_ID | LEADER_STORE_ID | PEERS | SCATTERING | WRITTEN_BYTES | READ_BYTES | APPROXIMATE_SIZE(MB) | APPROXIMATE_KEYS | SCHEDULING_CONSTRAINTS | SCHEDULING_STATE |\r\n+-----------+----------------+----------------+-----------+-----------------+------------------+------------+---------------+------------+----------------------+------------------+------------------------+------------------+\r\n| 3005 | 72000001 | t_94_r_182668 | 3008 | 2 | 3006, 3008, 3029 | 0 | 502 | 108038 | 32 | 252517 | | |\r\n| 3013 | t_94_r_182668 | t_94_r_842765 | 3015 | 1 | 3014, 3015, 3016 | 0 | 0 | 0 | 99 | 641578 | | |\r\n| 3017 | t_94_r_842765 | t_94_r_1245906 | 3019 | 1 | 3018, 3019, 3023 | 0 | 155 | 0 | 65 | 423135 | | |\r\n| 3009 | t_94_r_1245906 | 78000000 | 3011 | 1 | 3011, 3012, 3025 | 0 | 140 | 0 | 108 | 530975 | | |\r\n+-----------+----------------+----------------+-----------+-----------------+------------------+------------+---------------+------------+----------------------+------------------+------------------------+------------------+\r\n4 rows in set (0.01 sec)\r\n<\/code><\/pre>\n\u6211\u60f3\u8981\u5c06 leader_store_id \u4e3a1\u7684 TikV \u8bbe\u5b9a\u4e3a\u5f3a\u5236\u505c\u6b62\u7684\u76ee\u6807\u3002\u4e3a\u4e86\u786e\u5b9a leader_store_id \u4e3a1\u7684 TiKV\uff0c\u6211\u4f1a\u68c0\u67e5 information_schema.tikv_store_status\u3002<\/p>\n
mysql> SELECT store_id, address FROM information_schema.tikv_store_status;\r\n+----------+---------------------+\r\n| store_id | address |\r\n+----------+---------------------+\r\n| 1 | 192.168.3.171:20160 |\r\n| 2 | 192.168.3.171:20162 |\r\n| 3 | 192.168.3.171:20161 |\r\n| 114 | 192.168.3.171:3930 |\r\n| 3021 | 192.168.3.171:20163 |\r\n+----------+---------------------+\r\n5 rows in set (0.00 sec)\r\n<\/code><\/pre>\n\u6839\u636e\u4e0a\u8ff0\u7684\u60c5\u51b5\uff0c\u6211\u4eec\u53d1\u73b0 store_id \u4e3a 1 \u7684 TiKV \u7684\u5730\u5740\u662f 192.168.3.171:20160\uff0c\u56e0\u6b64\u6211\u4eec\u5c06\u505c\u6b62\u8be5\u8fdb\u7a0b\u3002<\/p>\n
[root@tisim ~]# ps -ef |grep tikv-20160|grep -v grep\r\ntidb 1121 1 2 14:44 ? 00:04:06 bin\/tikv-server --addr 0.0.0.0:20160 --advertise-addr 192.168.3.171:20160 --status-addr 0.0.0.0:20180 --advertise-status-addr 192.168.3.171:20180 --pd 192.168.3.171:2379 --data-dir \/tidb-data\/tikv-20160 --config conf\/tikv.toml --log-file \/tidb-deploy\/tikv-20160\/log\/tikv.log\r\n[root@tisim ~]# kill -9 1121\r\n<\/code><\/pre>\n\u6211\u5011\u5c07\u6aa2\u67e5\u72c0\u614b\u3002tikv-20160\u7684\u72c0\u614b\u5df2\u7d93\u8b8a\u70ba\u65b7\u958b\u9023\u63a5\u3002<\/p>\n
[root@tisim ~]# tiup cluster display demo-cluster\r\n(\u7701\u7565)\r\nID Role Host Ports OS\/Arch Status Data Dir Deploy Dir\r\n-- ---- ---- ----- ------- ------ -------- ----------\r\n192.168.3.171:20160 tikv 192.168.3.171 20160\/20180 linux\/x86_64 Disconnected \/tidb-data\/tikv-20160 \/tidb-deploy\/tikv-20160\r\n192.168.3.171:20161 tikv 192.168.3.171 20161\/20181 linux\/x86_64 Up \/tidb-data\/tikv-20161 \/tidb-deploy\/tikv-20161\r\n192.168.3.171:20162 tikv 192.168.3.171 20162\/20182 linux\/x86_64 Up \/tidb-data\/tikv-20162 \/tidb-deploy\/tikv-20162\r\n192.168.3.171:20163 tikv 192.168.3.171 20163\/20183 linux\/x86_64 Up \/tidb-data\/tikv-20163 \/tidb-deploy\/tikv-20163\r\n<\/code><\/pre>\n\u5f53\u91cd\u65b0\u786e\u8ba4\u533a\u57df\u4fe1\u606f\u65f6\uff0c\u53ef\u4ee5\u4eceleader_id\u7684\u503c\u4e2d\u786e\u8ba4leader_store_id\u5df2\u88ab\u66f4\u6539\u4e3a\u975e1\uff0c\u5e76\u4e14\u4e00\u4e2a\u4f5c\u4e3a\u526f\u672c\u7684\u533a\u57df\u5df2\u88ab\u63d0\u5347\u4e3a\u9886\u5bfc\u8005\u3002<\/p>\n
mysql> SHOW TABLE trips REGIONS;\r\n+-----------+----------------+----------------+-----------+-----------------+------------------+------------+---------------+------------+----------------------+------------------+------------------------+------------------+\r\n| REGION_ID | START_KEY | END_KEY | LEADER_ID | LEADER_STORE_ID | PEERS | SCATTERING | WRITTEN_BYTES | READ_BYTES | APPROXIMATE_SIZE(MB) | APPROXIMATE_KEYS | SCHEDULING_CONSTRAINTS | SCHEDULING_STATE |\r\n+-----------+----------------+----------------+-----------+-----------------+------------------+------------+---------------+------------+----------------------+------------------+------------------------+------------------+\r\n| 3005 | 72000001 | t_94_r_182668 | 3008 | 2 | 3006, 3008, 3029 | 0 | 635 | 109725 | 32 | 252517 | | |\r\n| 3013 | t_94_r_182668 | t_94_r_842765 | 3014 | 3 | 3014, 3015, 3016 | 0 | 39 | 0 | 102 | 665224 | | |\r\n| 3017 | t_94_r_842765 | t_94_r_1245906 | 3023 | 3021 | 3018, 3019, 3023 | 0 | 39 | 0 | 62 | 403141 | | |\r\n| 3009 | t_94_r_1245906 | 78000000 | 3012 | 2 | 3011, 3012, 3025 | 0 | 0 | 558135 | 79 | 505124 | | |\r\n+-----------+----------------+----------------+-----------+-----------------+------------------+------------+---------------+------------+----------------------+------------------+------------------------+------------------+\r\n4 rows in set (0.01 sec)\r\n<\/code><\/pre>\n\u987a\u4fbf\u63d0\u4e00\u4e0b\uff0c\u4e4b\u524d\u7ec8\u6b62\u7684tikv-20160\u5df2\u7ecf\u81ea\u52a8\u6062\u590d\u4e86\uff0c\u4ee5\u4e0b\u662f\/var\/log\/messages\u7684\u6458\u5f55\u3002<\/p>\n
May 13 17:58:41 tisim systemd: tikv-20160.service: main process exited, code=killed, status=9\/KILL\r\nMay 13 17:58:41 tisim systemd: Unit tikv-20160.service entered failed state.\r\nMay 13 17:58:41 tisim systemd: tikv-20160.service failed.\r\nMay 13 17:58:56 tisim systemd: tikv-20160.service holdoff time over, scheduling restart.\r\nMay 13 17:58:56 tisim systemd: Stopped tikv service.\r\nMay 13 17:58:56 tisim systemd: Started tikv service.\r\n<\/code><\/pre>\n\u6700\u540e<\/h1>\n
\u5e0c\u671b\u672c\u6587\u7ae0\u80fd\u5e2e\u52a9\u60a8\uff0c\u6211\u4eec\u5728\u672c\u6587\u4e2d\u786e\u8ba4\u4e86\u4ee5\u4e0b\u5185\u5bb9\u3002<\/p>\n
\n- \n
SHOW TABLE REGIONS\u6587\u3092\u4f7f\u7528\u3057\u305f\u30ea\u30fc\u30b8\u30e7\u30f3\u60c5\u5831<\/ul>\n<\/li>\n<\/ul>\n <\/p>\n
\n- \n
tiup\u3092\u4f7f\u7528\u3057\u305fTiKV\u306e\u30b9\u30b1\u30fc\u30eb\u30a2\u30a6\u30c8<\/ul>\n<\/li>\n<\/ul>\n <\/p>\n
TiKV\u7570\u5e38\u7d42\u4e86\u6642\u306e\u30ea\u30fc\u30b8\u30e7\u30f3\u518d\u914d\u7f6e<\/ul>\n","protected":false},"excerpt":{"rendered":"\u9996\u5148 \u6211\u5728\u4ee5\u4e0b\u6bcf\u4e2a\u65f6\u95f4\u70b9\u6267\u884c\u4e86SHOW TABLE REGIONS\u547d\u4ee4\uff0c\u5e76\u786e\u8ba4\u4e86\u533a\u57df\u4fe1\u606f\u3002 \u30c7\u30fc\u30bf\u8ffd\u52a0\u524d &n […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-43705","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n
[TiDB] \u67e5\u770b\u8868\u7684\u5206\u533a\u4fe1\u606f - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/tidb-\u67e5\u770b\u8868\u7684\u5206\u533a\u4fe1\u606f\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[TiDB] \u67e5\u770b\u8868\u7684\u5206\u533a\u4fe1\u606f\" \/>\n<meta property=\"og:description\" content=\"\u9996\u5148 \u6211\u5728\u4ee5\u4e0b\u6bcf\u4e2a\u65f6\u95f4\u70b9\u6267\u884c\u4e86SHOW TABLE REGIONS\u547d\u4ee4\uff0c\u5e76\u786e\u8ba4\u4e86\u533a\u57df\u4fe1\u606f\u3002 \u30c7\u30fc\u30bf\u8ffd\u52a0\u524d &n […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/tidb-\u67e5\u770b\u8868\u7684\u5206\u533a\u4fe1\u606f\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-02T08:00:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-28T18:15:16+00:00\" \/>\n<meta name=\"author\" content=\"\u79d1, \u9896\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u79d1, \u9896\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/tidb-%e6%9f%a5%e7%9c%8b%e8%a1%a8%e7%9a%84%e5%88%86%e5%8c%ba%e4%bf%a1%e6%81%af\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/tidb-%e6%9f%a5%e7%9c%8b%e8%a1%a8%e7%9a%84%e5%88%86%e5%8c%ba%e4%bf%a1%e6%81%af\/\",\"name\":\"[TiDB] \u67e5\u770b\u8868\u7684\u5206\u533a\u4fe1\u606f - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-01-02T08:00:29+00:00\",\"dateModified\":\"2024-04-28T18:15:16+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/tidb-%e6%9f%a5%e7%9c%8b%e8%a1%a8%e7%9a%84%e5%88%86%e5%8c%ba%e4%bf%a1%e6%81%af\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/tidb-%e6%9f%a5%e7%9c%8b%e8%a1%a8%e7%9a%84%e5%88%86%e5%8c%ba%e4%bf%a1%e6%81%af\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/tidb-%e6%9f%a5%e7%9c%8b%e8%a1%a8%e7%9a%84%e5%88%86%e5%8c%ba%e4%bf%a1%e6%81%af\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[TiDB] \u67e5\u770b\u8868\u7684\u5206\u533a\u4fe1\u606f\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e\",\"name\":\"\u79d1, \u9896\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g\",\"caption\":\"\u79d1, \u9896\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/keying\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/tidb-%e6%9f%a5%e7%9c%8b%e8%a1%a8%e7%9a%84%e5%88%86%e5%8c%ba%e4%bf%a1%e6%81%af\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"[TiDB] \u67e5\u770b\u8868\u7684\u5206\u533a\u4fe1\u606f - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/tidb-\u67e5\u770b\u8868\u7684\u5206\u533a\u4fe1\u606f\/","og_locale":"zh_CN","og_type":"article","og_title":"[TiDB] \u67e5\u770b\u8868\u7684\u5206\u533a\u4fe1\u606f","og_description":"\u9996\u5148 \u6211\u5728\u4ee5\u4e0b\u6bcf\u4e2a\u65f6\u95f4\u70b9\u6267\u884c\u4e86SHOW TABLE REGIONS\u547d\u4ee4\uff0c\u5e76\u786e\u8ba4\u4e86\u533a\u57df\u4fe1\u606f\u3002 \u30c7\u30fc\u30bf\u8ffd\u52a0\u524d &n […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/tidb-\u67e5\u770b\u8868\u7684\u5206\u533a\u4fe1\u606f\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-01-02T08:00:29+00:00","article_modified_time":"2024-04-28T18:15:16+00:00","author":"\u79d1, \u9896","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u79d1, \u9896","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"8 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/tidb-%e6%9f%a5%e7%9c%8b%e8%a1%a8%e7%9a%84%e5%88%86%e5%8c%ba%e4%bf%a1%e6%81%af\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/tidb-%e6%9f%a5%e7%9c%8b%e8%a1%a8%e7%9a%84%e5%88%86%e5%8c%ba%e4%bf%a1%e6%81%af\/","name":"[TiDB] \u67e5\u770b\u8868\u7684\u5206\u533a\u4fe1\u606f - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-01-02T08:00:29+00:00","dateModified":"2024-04-28T18:15:16+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/tidb-%e6%9f%a5%e7%9c%8b%e8%a1%a8%e7%9a%84%e5%88%86%e5%8c%ba%e4%bf%a1%e6%81%af\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/tidb-%e6%9f%a5%e7%9c%8b%e8%a1%a8%e7%9a%84%e5%88%86%e5%8c%ba%e4%bf%a1%e6%81%af\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/tidb-%e6%9f%a5%e7%9c%8b%e8%a1%a8%e7%9a%84%e5%88%86%e5%8c%ba%e4%bf%a1%e6%81%af\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"[TiDB] \u67e5\u770b\u8868\u7684\u5206\u533a\u4fe1\u606f"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e","name":"\u79d1, \u9896","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g","caption":"\u79d1, \u9896"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/keying\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/tidb-%e6%9f%a5%e7%9c%8b%e8%a1%a8%e7%9a%84%e5%88%86%e5%8c%ba%e4%bf%a1%e6%81%af\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/43705","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=43705"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/43705\/revisions"}],"predecessor-version":[{"id":74304,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/43705\/revisions\/74304"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=43705"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=43705"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=43705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}