TiDB仮想マシンのスタンドアロン導入
39348 ワード
、 。
:vmware workstations + CentOS 7.5
1. : 170M
#wget http://download.pingcap.org/tidb-latest-linux-amd64.tar.gz
# mv /usr/local/tidb-latest-linux-amd64/ /usr/local/tidb
2. :
#mkdir -p /data/tidb/{pddata,tikvdata}
3. PD:
# /usr/local/tidb/pd-server --data-dir=/data/tidb/pddata/ &
[1] 4486
[root@node1 tidb]# 2018/09/05 02:50:16.549 util.go:56: [info] Welcome to Placement Driver (PD).
2018/09/05 02:50:16.549 util.go:57: [info] Release Version: v2.1.0-rc.1-14-g0d99adc
2018/09/05 02:50:16.549 util.go:58: [info] Git Commit Hash: 0d99adce94dd87fa3ab162830dd379fe167ec71a
2018/09/05 02:50:16.549 util.go:59: [info] Git Branch: master
2018/09/05 02:50:16.549 util.go:60: [info] UTC Build Time: 2018-09-05 09:00:03
2018/09/05 02:50:16.549 metricutil.go:79: [info] disable Prometheus push client
2018/09/05 02:50:16.549 server.go:103: [info] PD config - {
"client-urls": "http://127.0.0.1:2379",
"peer-urls": "http://127.0.0.1:2380",
"advertise-client-urls": "http://127.0.0.1:2379",
"advertise-peer-urls": "http://127.0.0.1:2380",
"name": "pd",
"data-dir": "/data/tidb/pddata/",
"initial-cluster": "pd=http://127.0.0.1:2380",
"initial-cluster-state": "new",
"join": "",
"lease": 3,
"log": {
"level": "",
"format": "text",
"disable-timestamp": false,
"file": {
"filename": "",
"log-rotate": true,
"max-size": 0,
"max-days": 0,
"max-backups": 0
}
},
"log-file": "",
"log-level": "",
"tso-save-interval": "3s",
"metric": {
"job": "pd",
"address": "",
"interval": "0s"
},
"schedule": {
"max-snapshot-count": 3,
"max-pending-peer-count": 16,
"max-merge-region-size": 20,
"max-merge-region-keys": 200000,
"split-merge-interval": "1h0m0s",
"patrol-region-interval": "100ms",
"max-store-down-time": "30m0s",
"leader-schedule-limit": 4,
"region-schedule-limit": 4,
"replica-schedule-limit": 8,
"merge-schedule-limit": 8,
"tolerant-size-ratio": 5,
"low-space-ratio": 0.8,
"high-space-ratio": 0.6,
"disable-raft-learner": "false",
"disable-remove-down-replica": "false",
"disable-replace-offline-replica": "false",
"disable-make-up-replica": "false",
"disable-remove-extra-replica": "false",
"disable-location-replacement": "false",
"disable-namespace-relocation": "false",
"schedulers-v2": [
{
"type": "balance-region",
"args": null,
"disable": false
},
{
"type": "balance-leader",
"args": null,
"disable": false
},
{
"type": "hot-region",
"args": null,
"disable": false
},
{
"type": "label",
"args": null,
"disable": false
}
]
},
"replication": {
"max-replicas": 3,
"location-labels": ""
},
"namespace": {},
"cluster-version": "0.0.0",
"quota-backend-bytes": "0 B",
"auto-compaction-mode": "periodic",
"auto-compaction-retention-v2": "1h",
"TickInterval": "500ms",
"ElectionInterval": "3s",
"PreVote": true,
"security": {
"cacert-path": "",
"cert-path": "",
"key-path": ""
},
"label-property": null,
"WarningMsgs": null,
"namespace-classifier": "table"
}
2018/09/05 02:50:16.550 server.go:135: [info] start embed etcd
2018/09/05 02:50:16.550 log.go:86: [info] embed: [pprof is enabled under /debug/pprof]
2018/09/05 02:50:16.551 systime_mon.go:24: [info] start system time monitor
2018/09/05 02:50:16.570 log.go:86: [info] etcdserver: [name = pd]
2018/09/05 02:50:16.570 log.go:86: [info] etcdserver: [data dir = /data/tidb/pddata/]
2018/09/05 02:50:16.570 log.go:86: [info] etcdserver: [member dir = /data/tidb/pddata/member]
2018/09/05 02:50:16.570 log.go:86: [info] etcdserver: [heartbeat = 500ms]
2018/09/05 02:50:16.570 log.go:86: [info] etcdserver: [election = 3000ms]
2018/09/05 02:50:16.570 log.go:86: [info] etcdserver: [snapshot count = 100000]
2018/09/05 02:50:16.570 log.go:86: [info] etcdserver: [advertise client URLs = http://127.0.0.1:2379]
2018/09/05 02:50:16.570 log.go:86: [info] etcdserver: [initial advertise peer URLs = http://127.0.0.1:2380]
2018/09/05 02:50:16.570 log.go:86: [info] etcdserver: [initial cluster = pd=http://127.0.0.1:2380]
2018/09/05 02:50:16.575 log.go:86: [info] etcdserver: [starting member b71f75320dc06a6c in cluster 1c45a069f3a1d796]
{"level":"info","ts":1536087016.5758674,"caller":"raft/raft.go:656","msg":"b71f75320dc06a6c became follower at term 0"}
{"level":"info","ts":1536087016.5759113,"caller":"raft/raft.go:364","msg":"newRaft b71f75320dc06a6c [peers: [], term: 0, commit: 0, applied: 0, lastindex: 0, lastterm: 0]"}
{"level":"info","ts":1536087016.57592,"caller":"raft/raft.go:656","msg":"b71f75320dc06a6c became follower at term 1"}
2018/09/05 02:50:16.592 log.go:82: [warning] auth: [simple token is not cryptographically signed]
2018/09/05 02:50:16.594 log.go:86: [info] embed: [b71f75320dc06a6c starting with cors ["*"]]
2018/09/05 02:50:16.594 log.go:86: [info] embed: [b71f75320dc06a6c starting with host whitelist ["*"]]
2018/09/05 02:50:16.594 log.go:86: [info] etcdserver: [starting server... [version: 3.3.0+git, cluster version: to_be_decided]]
2018/09/05 02:50:16.595 log.go:86: [info] etcdserver: [b71f75320dc06a6c as single-node; fast-forwarding 5 ticks (election ticks 6)]
2018/09/05 02:50:16.595 log.go:86: [info] etcdserver/membership: [added member b71f75320dc06a6c [http://127.0.0.1:2380] to cluster 1c45a069f3a1d796]
2018/09/05 02:50:16.596 log.go:86: [info] embed: [listening for peers on 127.0.0.1:2380]
{"level":"info","ts":1536087017.0773394,"caller":"raft/raft.go:857","msg":"b71f75320dc06a6c is starting a new election at term 1"}
{"level":"info","ts":1536087017.0773728,"caller":"raft/raft.go:684","msg":"b71f75320dc06a6c became pre-candidate at term 1"}
{"level":"info","ts":1536087017.0773876,"caller":"raft/raft.go:755","msg":"b71f75320dc06a6c received MsgPreVoteResp from b71f75320dc06a6c at term 1"}
{"level":"info","ts":1536087017.0773978,"caller":"raft/raft.go:669","msg":"b71f75320dc06a6c became candidate at term 2"}
{"level":"info","ts":1536087017.0774035,"caller":"raft/raft.go:755","msg":"b71f75320dc06a6c received MsgVoteResp from b71f75320dc06a6c at term 2"}
{"level":"info","ts":1536087017.0774126,"caller":"raft/raft.go:712","msg":"b71f75320dc06a6c became leader at term 2"}
{"level":"info","ts":1536087017.07742,"caller":"raft/node.go:306","msg":"raft.node: b71f75320dc06a6c elected leader b71f75320dc06a6c at term 2"}
2018/09/05 02:50:17.077 log.go:86: [info] etcdserver: [published {Name:pd ClientURLs:[http://127.0.0.1:2379]} to cluster 1c45a069f3a1d796]
2018/09/05 02:50:17.077 log.go:86: [info] embed: [ready to serve client requests]
2018/09/05 02:50:17.077 log.go:86: [info] etcdserver: [setting up the initial cluster version to 3.3]
2018/09/05 02:50:17.077 log.go:84: [info] embed: [serving insecure client requests on 127.0.0.1:2379, this is strongly discouraged!]
2018/09/05 02:50:17.077 log.go:84: [info] etcdserver/membership: [set the initial cluster version to 3.3]
2018/09/05 02:50:17.078 server.go:162: [info] create etcd v3 client with endpoints [http://127.0.0.1:2379]
2018/09/05 02:50:17.078 log.go:86: [info] etcdserver/api: [enabled capabilities for version 3.3]
2018/09/05 02:50:17.080 server.go:201: [info] init cluster id 6597443502776081340
2018/09/05 02:50:17.080 namespace_classifier.go:438: [info] load 0 namespacesInfo cost 176.109µs
2018/09/05 02:50:17.082 tso.go:104: [info] sync and save timestamp: last 0001-01-01 00:00:00 +0000 UTC save 2018-09-05 02:50:20.082110968 +0800 CST m=+3.558018392 next 2018-09-05 02:50:17.082110968 +0800 CST m=+0.558018392
2018/09/05 02:50:17.082 leader.go:263: [info] cluster version is 0.0.0
2018/09/05 02:50:17.082 leader.go:264: [info] PD cluster leader pd is ready to serve
4. tikv:
# /usr/local/tidb/tikv-server --pd="127.0.0.1:2379" --store=/data/tidb/tikvdata/ &
[2] 4532
[root@node1 tidb]# 2018/09/05 02:52:56.885 INFO mod.rs:26: Welcome to TiKV.
Release Version: 2.1.0-rc.1
Git Commit Hash: 355b8fcbfc8a89f426445ab94defd6053c5685de
Git Commit Branch: master
UTC Build Time: 2018-09-05 07:32:14
Rust Version: rustc 1.29.0-nightly (4f3c7a472 2018-07-17)
2018/09/05 02:52:56.899 INFO config.rs:142: no advertise-addr is specified, fall back to addr.
2018/09/05 02:52:56.900 INFO tikv-server.rs:392: using config: {
"log-level": "info",
"log-file": "",
"log-rotation-timespan": "24h",
"readpool": {
"storage": {
"high-concurrency": 4,
"normal-concurrency": 4,
"low-concurrency": 4,
"max-tasks-per-worker-high": 2000,
"max-tasks-per-worker-normal": 2000,
"max-tasks-per-worker-low": 2000,
"stack-size": "10MB"
},
"coprocessor": {
"high-concurrency": 8,
"normal-concurrency": 8,
"low-concurrency": 8,
"max-tasks-per-worker-high": 2000,
"max-tasks-per-worker-normal": 2000,
"max-tasks-per-worker-low": 2000,
"stack-size": "10MB"
}
},
"server": {
"addr": "127.0.0.1:20160",
"advertise-addr": "127.0.0.1:20160",
"grpc-compression-type": "none",
"grpc-concurrency": 4,
"grpc-concurrent-stream": 1024,
"grpc-raft-conn-num": 10,
"grpc-stream-initial-window-size": "2MB",
"grpc-keepalive-time": "10s",
"grpc-keepalive-timeout": "3s",
"concurrent-send-snap-limit": 32,
"concurrent-recv-snap-limit": 32,
"end-point-recursion-limit": 1000,
"end-point-stream-channel-size": 8,
"end-point-batch-row-limit": 64,
"end-point-stream-batch-row-limit": 128,
"end-point-request-max-handle-duration": "1m",
"snap-max-write-bytes-per-sec": "100MB",
"snap-max-total-size": "0KB",
"labels": {}
},
"storage": {
"data-dir": "/data/tidb/tikvdata",
"gc-ratio-threshold": 1.1,
"max-key-size": 4096,
"scheduler-notify-capacity": 10240,
"scheduler-concurrency": 2048000,
"scheduler-worker-pool-size": 4,
"scheduler-pending-write-threshold": "100MB"
},
"pd": {
"endpoints": [
"127.0.0.1:2379"
]
},
"metric": {
"interval": "15s",
"address": "",
"job": "tikv"
},
"raftstore": {
"sync-log": true,
"prevote": true,
"raftdb-path": "/data/tidb/tikvdata/raft",
"capacity": "0KB",
"raft-base-tick-interval": "1s",
"raft-heartbeat-ticks": 2,
"raft-election-timeout-ticks": 10,
"raft-min-election-timeout-ticks": 10,
"raft-max-election-timeout-ticks": 20,
"raft-max-size-per-msg": "1MB",
"raft-max-inflight-msgs": 256,
"raft-entry-max-size": "8MB",
"raft-log-gc-tick-interval": "10s",
"raft-log-gc-threshold": 50,
"raft-log-gc-count-limit": 73728,
"raft-log-gc-size-limit": "72MB",
"split-region-check-tick-interval": "10s",
"region-split-check-diff": "6MB",
"region-compact-check-interval": "5m",
"clean-stale-peer-delay": "11m",
"region-compact-check-step": 100,
"region-compact-min-tombstones": 10000,
"region-compact-tombstones-percent": 30,
"pd-heartbeat-tick-interval": "1m",
"pd-store-heartbeat-tick-interval": "10s",
"snap-mgr-gc-tick-interval": "1m",
"snap-gc-timeout": "4h",
"lock-cf-compact-interval": "10m",
"lock-cf-compact-bytes-threshold": "256MB",
"notify-capacity": 40960,
"messages-per-tick": 4096,
"max-peer-down-duration": "5m",
"max-leader-missing-duration": "2h",
"abnormal-leader-missing-duration": "10m",
"peer-stale-state-check-interval": "5m",
"leader-transfer-max-log-lag": 10,
"snap-apply-batch-size": "10MB",
"consistency-check-interval": "0s",
"report-region-flow-interval": "1m",
"raft-store-max-leader-lease": "9s",
"right-derive-when-split": true,
"allow-remove-leader": false,
"merge-max-log-gap": 10,
"merge-check-tick-interval": "10s",
"use-delete-range": false,
"cleanup-import-sst-interval": "10m",
"local-read-batch-size": 1024
},
"coprocessor": {
"split-region-on-table": true,
"batch-split-limit": 10,
"region-max-size": "144MB",
"region-split-size": "96MB",
"region-max-keys": 1440000,
"region-split-keys": 960000
},
"rocksdb": {
"wal-recovery-mode": 2,
"wal-dir": "",
"wal-ttl-seconds": 0,
"wal-size-limit": "0KB",
"max-total-wal-size": "4GB",
"max-background-jobs": 6,
"max-manifest-file-size": "20MB",
"create-if-missing": true,
"max-open-files": 40960,
"enable-statistics": true,
"stats-dump-period": "10m",
"compaction-readahead-size": "0KB",
"info-log-max-size": "1GB",
"info-log-roll-time": "0s",
"info-log-keep-log-file-num": 10,
"info-log-dir": "",
"rate-bytes-per-sec": "0KB",
"bytes-per-sync": "1MB",
"wal-bytes-per-sync": "512KB",
"max-sub-compactions": 1,
"writable-file-max-buffer-size": "1MB",
"use-direct-io-for-flush-and-compaction": false,
"enable-pipelined-write": true,
"defaultcf": {
"block-size": "64KB",
"block-cache-size": "747MB",
"disable-block-cache": false,
"cache-index-and-filter-blocks": true,
"pin-l0-filter-and-index-blocks": true,
"use-bloom-filter": true,
"whole-key-filtering": true,
"bloom-filter-bits-per-key": 10,
"block-based-bloom-filter": false,
"read-amp-bytes-per-bit": 0,
"compression-per-level": [
"no",
"no",
"lz4",
"lz4",
"lz4",
"zstd",
"zstd"
],
"write-buffer-size": "128MB",
"max-write-buffer-number": 5,
"min-write-buffer-number-to-merge": 1,
"max-bytes-for-level-base": "512MB",
"target-file-size-base": "8MB",
"level0-file-num-compaction-trigger": 4,
"level0-slowdown-writes-trigger": 20,
"level0-stop-writes-trigger": 36,
"max-compaction-bytes": "2GB",
"compaction-pri": 3,
"dynamic-level-bytes": true,
"num-levels": 7,
"max-bytes-for-level-multiplier": 10,
"compaction-style": 0,
"disable-auto-compactions": false,
"soft-pending-compaction-bytes-limit": "64GB",
"hard-pending-compaction-bytes-limit": "256GB"
},
"writecf": {
"block-size": "64KB",
"block-cache-size": "448MB",
"disable-block-cache": false,
"cache-index-and-filter-blocks": true,
"pin-l0-filter-and-index-blocks": true,
"use-bloom-filter": true,
"whole-key-filtering": false,
"bloom-filter-bits-per-key": 10,
"block-based-bloom-filter": false,
"read-amp-bytes-per-bit": 0,
"compression-per-level": [
"no",
"no",
"lz4",
"lz4",
"lz4",
"zstd",
"zstd"
],
"write-buffer-size": "128MB",
"max-write-buffer-number": 5,
"min-write-buffer-number-to-merge": 1,
"max-bytes-for-level-base": "512MB",
"target-file-size-base": "8MB",
"level0-file-num-compaction-trigger": 4,
"level0-slowdown-writes-trigger": 20,
"level0-stop-writes-trigger": 36,
"max-compaction-bytes": "2GB",
"compaction-pri": 3,
"dynamic-level-bytes": true,
"num-levels": 7,
"max-bytes-for-level-multiplier": 10,
"compaction-style": 0,
"disable-auto-compactions": false,
"soft-pending-compaction-bytes-limit": "64GB",
"hard-pending-compaction-bytes-limit": "256GB"
},
"lockcf": {
"block-size": "16KB",
"block-cache-size": "256MB",
"disable-block-cache": false,
"cache-index-and-filter-blocks": true,
"pin-l0-filter-and-index-blocks": true,
"use-bloom-filter": true,
"whole-key-filtering": true,
"bloom-filter-bits-per-key": 10,
"block-based-bloom-filter": false,
"read-amp-bytes-per-bit": 0,
"compression-per-level": [
"no",
"no",
"no",
"no",
"no",
"no",
"no"
],
"write-buffer-size": "128MB",
"max-write-buffer-number": 5,
"min-write-buffer-number-to-merge": 1,
"max-bytes-for-level-base": "128MB",
"target-file-size-base": "8MB",
"level0-file-num-compaction-trigger": 1,
"level0-slowdown-writes-trigger": 20,
"level0-stop-writes-trigger": 36,
"max-compaction-bytes": "2GB",
"compaction-pri": 0,
"dynamic-level-bytes": true,
"num-levels": 7,
"max-bytes-for-level-multiplier": 10,
"compaction-style": 0,
"disable-auto-compactions": false,
"soft-pending-compaction-bytes-limit": "64GB",
"hard-pending-compaction-bytes-limit": "256GB"
},
"raftcf": {
"block-size": "16KB",
"block-cache-size": "128MB",
"disable-block-cache": false,
"cache-index-and-filter-blocks": true,
"pin-l0-filter-and-index-blocks": true,
"use-bloom-filter": true,
"whole-key-filtering": true,
"bloom-filter-bits-per-key": 10,
"block-based-bloom-filter": false,
"read-amp-bytes-per-bit": 0,
"compression-per-level": [
"no",
"no",
"no",
"no",
"no",
"no",
"no"
],
"write-buffer-size": "128MB",
"max-write-buffer-number": 5,
"min-write-buffer-number-to-merge": 1,
"max-bytes-for-level-base": "128MB",
"target-file-size-base": "8MB",
"level0-file-num-compaction-trigger": 1,
"level0-slowdown-writes-trigger": 20,
"level0-stop-writes-trigger": 36,
"max-compaction-bytes": "2GB",
"compaction-pri": 0,
"dynamic-level-bytes": true,
"num-levels": 7,
"max-bytes-for-level-multiplier": 10,
"compaction-style": 0,
"disable-auto-compactions": false,
"soft-pending-compaction-bytes-limit": "64GB",
"hard-pending-compaction-bytes-limit": "256GB"
}
},
"raftdb": {
"wal-recovery-mode": 2,
"wal-dir": "",
"wal-ttl-seconds": 0,
"wal-size-limit": "0KB",
"max-total-wal-size": "4GB",
"max-manifest-file-size": "20MB",
"create-if-missing": true,
"max-open-files": 40960,
"enable-statistics": true,
"stats-dump-period": "10m",
"compaction-readahead-size": "0KB",
"info-log-max-size": "1GB",
"info-log-roll-time": "0s",
"info-log-keep-log-file-num": 10,
"info-log-dir": "",
"max-sub-compactions": 1,
"writable-file-max-buffer-size": "1MB",
"use-direct-io-for-flush-and-compaction": false,
"enable-pipelined-write": true,
"allow-concurrent-memtable-write": false,
"bytes-per-sync": "1MB",
"wal-bytes-per-sync": "512KB",
"defaultcf": {
"block-size": "64KB",
"block-cache-size": "256MB",
"disable-block-cache": false,
"cache-index-and-filter-blocks": true,
"pin-l0-filter-and-index-blocks": true,
"use-bloom-filter": false,
"whole-key-filtering": true,
"bloom-filter-bits-per-key": 10,
"block-based-bloom-filter": false,
"read-amp-bytes-per-bit": 0,
"compression-per-level": [
"no",
"no",
"lz4",
"lz4",
"lz4",
"zstd",
"zstd"
],
"write-buffer-size": "128MB",
"max-write-buffer-number": 5,
"min-write-buffer-number-to-merge": 1,
"max-bytes-for-level-base": "512MB",
"target-file-size-base": "8MB",
"level0-file-num-compaction-trigger": 4,
"level0-slowdown-writes-trigger": 20,
"level0-stop-writes-trigger": 36,
"max-compaction-bytes": "2GB",
"compaction-pri": 0,
"dynamic-level-bytes": true,
"num-levels": 7,
"max-bytes-for-level-multiplier": 10,
"compaction-style": 0,
"disable-auto-compactions": false,
"soft-pending-compaction-bytes-limit": "64GB",
"hard-pending-compaction-bytes-limit": "256GB"
}
},
"security": {
"ca-path": "",
"cert-path": "",
"key-path": ""
},
"import": {
"import-dir": "/tmp/tikv/import",
"num-threads": 8,
"num-import-jobs": 8,
"num-import-sst-jobs": 2,
"max-prepare-duration": "5m",
"region-split-size": "96MB",
"stream-channel-window": 128,
"max-open-engines": 8
}
}
2018/09/05 02:52:56.900 WARN tikv-server.rs:87: Limit("kernel parameters net.core.somaxconn got 128, expect 32768")
2018/09/05 02:52:56.900 WARN tikv-server.rs:87: Limit("kernel parameters net.ipv4.tcp_syncookies got 1, expect 0")
2018/09/05 02:52:56.900 WARN tikv-server.rs:87: Limit("kernel parameters vm.swappiness got 30, expect 0")
2018/09/05 02:52:56.900 INFO config.rs:824: data_path: "/data/tidb/tikvdata", mount fs info: FsInfo { tp: "xfs", opts: "rw,relatime,attr2,inode64,noquota", mnt_dir: "/data", fsname: "/dev/mapper/centos-data" }
2018/09/05 02:52:56.900 WARN config.rs:827: "/data/tidb/tikvdata" not on SSD device
2018/09/05 02:52:56.900 INFO config.rs:824: data_path: "/data/tidb/tikvdata/raft", mount fs info: FsInfo { tp: "xfs", opts: "rw,relatime,attr2,inode64,noquota", mnt_dir: "/data", fsname: "/dev/mapper/centos-data" }
2018/09/05 02:52:56.900 WARN config.rs:827: "/data/tidb/tikvdata/raft" not on SSD device
2018/09/05 02:52:56.900 WARN setup.rs:166: environment variable `TZ` is missing, using `/etc/localtime`
2018/09/05 02:52:56.900 INFO util.rs:406: connecting to PD endpoint: "127.0.0.1:2379"
2018/09/05 02:52:57.009 INFO util.rs:406: connecting to PD endpoint: "http://127.0.0.1:2379"
2018/09/05 02:52:57.009 INFO util.rs:406: connecting to PD endpoint: "http://127.0.0.1:2379"
2018/09/05 02:52:57.011 INFO util.rs:465: connected to PD leader "http://127.0.0.1:2379"
2018/09/05 02:52:57.011 INFO util.rs:394: All PD endpoints are consistent: ["127.0.0.1:2379"]
2018/09/05 02:52:57.092 INFO tikv-server.rs:415: connect to PD cluster 6597443502776081340
2018/09/05 02:52:57.731 INFO mod.rs:341: starting working thread: addr-resolver
2018/09/05 02:52:59.729 INFO mod.rs:421: storage RaftKv started.
2018/09/05 02:52:59.968 INFO server.rs:98: listening on 127.0.0.1:20160
2018/09/05 02:52:59.969 id.go:90: [info] idAllocator allocates a new id: 1000
2018/09/05 02:52:59.969 INFO node.rs:229: alloc store id 1
2018/09/05 02:52:59.971 INFO node.rs:242: alloc first region id 2 for cluster 6597443502776081340, store 1
2018/09/05 02:52:59.971 INFO node.rs:247: alloc first peer id 3 for first region 2
2018/09/05 02:52:59.974 server.go:333: [info] try to bootstrap raft cluster 6597443502776081340 with header:<6597443502776081340> store:<1 address:="" version:=""> region:<2 region_epoch:="" version:1=""> peers:<3 store_id:1=""> >
2018/09/05 02:52:59.975 server.go:390: [info] bootstrap cluster 6597443502776081340 ok
2018/09/05 02:52:59.975 cluster_info.go:72: [info] load 1 stores cost 329.537µs
2018/09/05 02:52:59.975 cluster_info.go:78: [info] load 1 regions cost 115.76µs
2018/09/05 02:52:59.975 namespace_classifier.go:438: [info] load 0 namespacesInfo cost 114.338µs
2018/09/05 02:52:59.976 coordinator.go:208: [info] coordinator: Start collect cluster information
2018/09/05 02:52:59.977 INFO node.rs:300: bootstrap cluster 6597443502776081340 ok
2018/09/05 02:52:59.979 grpc_service.go:210: [info] put store ok - id:1 address:"127.0.0.1:20160" version:"2.1.0-rc.1"
2018/09/05 02:52:59.980 cluster_info.go:107: [info] cluster version changed from 0.0.0 to 2.1.0-rc.1
2018/09/05 02:52:59.981 INFO node.rs:338: start raft store 1 thread
2018/09/05 02:52:59.981 INFO peer.rs:298: [region 2] create peer with id 3
2018/09/05 02:52:59.981 INFO :833: [region 2] 3 became follower at term 5
2018/09/05 02:52:59.981 INFO :433: [region 2] 3 newRaft [peers: [3], term: 5, commit: 5, applied: 5, last_index: 5, last_term: 5]
2018/09/05 02:52:59.981 INFO :1120: [region 2] 3 is starting a new election at term 5
2018/09/05 02:52:59.981 INFO :865: [region 2] 3 became pre-candidate at term 5
2018/09/05 02:52:59.981 INFO :950: [region 2] 3 received MsgRequestPreVoteResponse from 3 at term 5
2018/09/05 02:52:59.982 INFO :848: [region 2] 3 became candidate at term 6
2018/09/05 02:52:59.982 INFO :950: [region 2] 3 received MsgRequestVoteResponse from 3 at term 6
2018/09/05 02:52:59.982 INFO :891: [region 2] 3 became leader at term 6
2018/09/05 02:52:59.982 INFO store.rs:283: [store 1] starts with 1 regions, including 0 tombstones, 0 applying regions and 0 merging regions, takes 256.27µs
2018/09/05 02:52:59.982 INFO store.rs:338: [store 1] cleans up 2 ranges garbage data, takes 2.959µs
2018/09/05 02:52:59.982 INFO mod.rs:341: starting working thread: split-check
2018/09/05 02:52:59.982 INFO mod.rs:341: starting working thread: snapshot-worker
2018/09/05 02:52:59.982 INFO mod.rs:341: starting working thread: raft-gc-worker
2018/09/05 02:52:59.982 INFO mod.rs:341: starting working thread: compact-worker
2018/09/05 02:52:59.982 INFO future.rs:142: starting working thread: pd-worker
2018/09/05 02:52:59.982 INFO mod.rs:341: starting working thread: consistency-check
2018/09/05 02:52:59.982 INFO mod.rs:341: starting working thread: cleanup-sst
2018/09/05 02:52:59.982 INFO mod.rs:341: starting working thread: apply-worker
2018/09/05 02:52:59.982 INFO mod.rs:341: starting working thread: local-reader
2018/09/05 02:52:59.982 INFO tikv-server.rs:225: start storage
2018/09/05 02:53:00.696 INFO mod.rs:341: starting working thread: storage-scheduler
2018/09/05 02:53:00.696 INFO mod.rs:341: starting working thread: gc-worker
2018/09/05 02:53:00.696 INFO mod.rs:341: starting working thread: end-point-worker
2018/09/05 02:53:00.696 INFO mod.rs:341: starting working thread: snap-handler
2018/09/05 02:53:00.777 INFO server.rs:170: TiKV is ready to serve
2018/09/05 02:53:02.331 INFO util.rs:84: heartbeat receiver is refreshed.
2018/09/05 02:53:02.331 INFO client.rs:306: heartbeat sender is refreshed.
2018/09/05 02:53:02.331 ERRO client.rs:325: failed to send heartbeat: Grpc(RpcFinished(Some(RpcStatus { status: Ok, details: None })))
2018/09/05 02:53:02.331 ERRO util.rs:297: request failed: Grpc(RpcFinished(Some(RpcStatus { status: Ok, details: None }))), retry
2018/09/05 02:53:02.332 ERRO util.rs:297: request failed: Other(SendError("...")), retry
2018/09/05 02:53:02.332 ERRO util.rs:297: request failed: Other(SendError("...")), retry
2018/09/05 02:53:02.332 WARN util.rs:243: updating PD client, block the tokio core
2018/09/05 02:53:02.332 INFO util.rs:406: connecting to PD endpoint: "http://127.0.0.1:2379"
2018/09/05 02:53:02.334 INFO util.rs:406: connecting to PD endpoint: "http://127.0.0.1:2379"
2018/09/05 02:53:02.337 INFO util.rs:465: connected to PD leader "http://127.0.0.1:2379"
2018/09/05 02:53:02.337 WARN util.rs:186: heartbeat sender and receiver are stale, refreshing..
2018/09/05 02:53:02.337 WARN util.rs:205: updating PD client done, spent 5.512839ms
2018/09/05 02:53:02.337 INFO client.rs:306: heartbeat sender is refreshed.
2018/09/05 02:53:02.338 INFO util.rs:84: heartbeat receiver is refreshed.
2018/09/05 02:53:02.976 coordinator.go:211: [info] coordinator: Cluster information is prepared
2018/09/05 02:53:02.976 coordinator.go:221: [info] coordinator: Run scheduler
2018/09/05 02:53:02.976 coordinator.go:236: [info] create scheduler balance-region-scheduler
2018/09/05 02:53:02.976 coordinator.go:236: [info] create scheduler balance-leader-scheduler
2018/09/05 02:53:02.976 coordinator.go:236: [info] create scheduler balance-hot-region-scheduler
2018/09/05 02:53:02.976 coordinator.go:236: [info] create scheduler label-scheduler
2018/09/05 02:53:02.977 coordinator.go:121: [info] coordinator: start patrol regions
5. tidb:
#usr/local/tidb/tikv-server --store=tikv --path="127.0.0.1:2379"
2018/09/05 02:55:50.231 INFO apply.rs:2171: [region 30] 31 register to apply delegates at term 6
2018/09/05 02:55:50.268 manager.go:240: [warning] [ddl] /tidb/ddl/fg/owner ownerManager 183e4581-c9b1-4aac-8a17-460689e8cdb0 isn't the owner
2018/09/05 02:55:50.268 delete_range.go:104: [info] [ddl] closing delRange session pool
2018/09/05 02:55:50.268 ddl_worker.go:112: [info] [ddl-worker 1, tp general] close DDL worker
2018/09/05 02:55:50.268 delete_range.go:104: [info] [ddl] closing delRange session pool
2018/09/05 02:55:50.268 ddl_worker.go:112: [info] [ddl-worker 2, tp add index] close DDL worker
2018/09/05 02:55:50.268 ddl.go:398: [info] [ddl] closing DDL:183e4581-c9b1-4aac-8a17-460689e8cdb0 takes time 968.756µs
2018/09/05 02:55:50.268 ddl.go:351: [info] [ddl] stop DDL:183e4581-c9b1-4aac-8a17-460689e8cdb0
2018/09/05 02:55:50.269 manager.go:251: [info] [ddl] /tidb/ddl/fg/owner ownerManager 183e4581-c9b1-4aac-8a17-460689e8cdb0 break campaign loop, revoke err
2018/09/05 02:55:50.269 domain.go:413: [info] [domain] close
2018/09/05 02:55:50.269 tidb.go:63: [info] store tikv-6597443502776081340 new domain, ddl lease 45s, stats lease 3000000000
2018/09/05 02:55:50.270 ddl.go:358: [info] [ddl] start DDL:db53a9fb-60af-4525-b338-ee4b31e274a1, run worker true
2018/09/05 02:55:50.270 ddl_worker.go:83: [info] [ddl] start delRangeManager OK, with emulator: false
2018/09/05 02:55:50.270 ddl_worker.go:83: [info] [ddl] start delRangeManager OK, with emulator: false
2018/09/05 02:55:50.270 ddl_worker.go:118: [info] [ddl-worker 4, tp add index] start DDL worker
2018/09/05 02:55:50.270 ddl_worker.go:118: [info] [ddl-worker 3, tp general] start DDL worker
2018/09/05 02:55:50.272 manager.go:275: [info] [ddl] /tidb/ddl/fg/owner ownerManager db53a9fb-60af-4525-b338-ee4b31e274a1, owner is db53a9fb-60af-4525-b338-ee4b31e274a1
2018/09/05 02:55:50.283 domain.go:119: [info] [ddl] full load InfoSchema from version 0 to 15, in 7.30164ms
2018/09/05 02:55:50.283 domain.go:316: [info] [ddl] full load and reset schema validator.
2018/09/05 02:55:50.733 gc_worker.go:131: [info] [gc worker] 59697c376680001 start.
2018/09/05 02:55:50.735 manager.go:275: [info] [stats] /tidb/stats/owner ownerManager db53a9fb-60af-4525-b338-ee4b31e274a1, owner is db53a9fb-60af-4525-b338-ee4b31e274a1
2018/09/05 02:55:50.765 gc_worker.go:235: [info] [gc worker] leaderTick on 59697c376680001: another gc job has just finished. skipped.
2018/09/05 02:55:50.766 server.go:194: [warning] Secure connection is NOT ENABLED
2018/09/05 02:55:50.766 server.go:161: [info] Server is running MySQL Protocol at [0.0.0.0:4000]
2018/09/05 02:55:50.766 http_status.go:86: [info] Listening on :10080 for status and metrics report.
2018/09/05 02:55:51.231 domain.go:669: [info] [stats] init stats info takes 499.075327ms
2018/09/05 02:55:51.832 INFO apply.rs:904: [region 4] 5 execute admin command cmd_type: CompactLog compact_log {compact_index: 117 compact_term: 6} at [term: 6, index: 119]
6. :
# mysql -h 127.0.0.1 -P 4000 -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.7.10-TiDB-v2.1.0-rc.1-59-g6e3bbe8 MySQL Community Server (Apache License 2.0)
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| INFORMATION_SCHEMA |
| PERFORMANCE_SCHEMA |
| mysql |
| test |
+--------------------+
4 rows in set (0.001 sec)
MySQL [(none)]> create database wuhan;
Query OK, 0 rows affected (0.074 sec)
MySQL [(none)]>
7. :
MySQL [(none)]> select version();
+-------------------------------------+
| version() |
+-------------------------------------+
| 5.7.10-TiDB-v2.1.0-rc.1-59-g6e3bbe8 |
+-------------------------------------+
1 row in set (0.001 sec)
MySQL [(none)]> select tidb_version()\G
*************************** 1. row ***************************
tidb_version(): Release Version: v2.1.0-rc.1-59-g6e3bbe8
Git Commit Hash: 6e3bbe8e35aaebfcef9628efc8486435c984f534
Git Branch: master
UTC Build Time: 2018-09-05 04:51:18
GoVersion: go version go1.11 linux/amd64
Race Enabled: false
TiKV Min Version: 2.1.0-alpha.1-ff3dd160846b7d1aed9079c389fc188f7f5ea13e
Check Table Before Drop: false
1 row in set (0.000 sec)
:
# netstat -nultp | grep -E 'pd|tikv|tidb'
tcp 0 0 127.0.0.1:2379 0.0.0.0:* LISTEN 4486/pd-server
tcp 0 0 127.0.0.1:2380 0.0.0.0:* LISTEN 4486/pd-server
tcp6 0 0 :::10080 :::* LISTEN 4680/tidb-server
tcp6 0 0 :::4000 :::* LISTEN 4680/tidb-server
tcp6 0 0 127.0.0.1:20160 :::* LISTEN 4532/tikv-server
tcp6 0 0 :::80 :::* LISTEN 856/httpd
tcp6 0 0 :::443 :::* LISTEN 856/httpd
# ps -ef | grep -E 'pd-server|tikv-server|tidb-server'
root 4486 4163 1 02:50 pts/0 00:00:44 /usr/local/tidb/pd-server --data-dir=/data/tidb/pddata/
root 4532 4163 0 02:52 pts/0 00:00:12 /usr/local/tidb/tikv-server --pd=127.0.0.1:2379 --store=/data/tidb/tikvdata/
root 4680 4163 0 02:55 pts/0 00:00:13 /usr/local/tidb/tidb-server --store=tikv --path=127.0.0.1:2379
kill :
kill -9 `ps -ef | grep -E 'pd-server|tikv-server|tidb-server'|grep -v grep | awk '{print $2}'`
: tidb , , :
#mkdir -p /data/tidb/{pddata,tikvdata}
#pd-server --data-dir=/data/tidb/pddata/ &
#tikv-server --pd="127.0.0.1:2379" --store=/data/tidb/tikvdata/ &
#tidb-server --store=tikv --path="127.0.0.1:2379" &
#mysql -h 127.0.0.1 -P 4000 -u root