1.首先準(zhǔn)備服務(wù)器環(huán)境，使用Ubuntu 16.0.4

==將tidb-v3.0.7.tar.gz拷貝到所有機(jī)器中==

ansible方式下載：

git clone https://github.com/pingcap/tidb-ansible.git
cd tidb-ansible
ansible-playbook local_prepare.yml
cd downloads  （可以看到下載的tidb安裝包，包括工具等。）

或者

http://download.pingcap.org/tidb-latest-linux-amd64-unportable.tar.gz

再或者從云盤上獲?。ù嗽票P存儲(chǔ)的內(nèi)容，就是使用ansible-playbook local_prepare.yml下載的所有內(nèi)容）
https://pan.baidu.com/s/1ReejN9fvffvOwOR7OikYqg
link

2.TiPD 安裝

1.安裝軟件

1.解壓tar

tar -xzvf tidb-v3.0.7.tar.gz

2.移動(dòng)到/user/local目錄下

sudo mv tidb-v3.0.7-linux-amd64 /usr/local/

3.安裝tidib

sudo ln -s /usr/local/tidb-v3.0.7-linux-amd64 /usr/local/tidb

2. 準(zhǔn)備數(shù)據(jù)目錄

sudo mkdir -p /usr/local/tidb/conf/
sudo mkdir -p /data/1/tidb/pd/4205
sudo mkdir -p /data/log1/tidb/pd

3. 準(zhǔn)備配置文件

vi /usr/local/tidb/conf/tipd_4205.conf

client-urls="http://192.168.3.78:4205"
name="pd3"
data-dir="/data/1/tidb/pd/4205/"
peer-urls="http://192.168.3.78:4206"
initial-cluster="pd1=http://192.168.3.76:4206,pd2=http://192.168.3.77:4206,pd3=http://192.168.3.78:4206"
log-file="/data/log1/tidb/pd/4205_run.log"

注意：==name== 指定的名稱必須和初始化集群名稱的“==pd3==”（initial-cluster） 相同；

4. 啟動(dòng)TiPD

nohup /usr/local/tidb/bin/pd-server --config=/usr/local/tidb/conf/tipd_4205.conf  > /dev/null 2>&1 &

3.TiKV安裝

1.安裝軟件

1.解壓tar

tar -xvf tidb-v3.0.7.tar.gz

2.移動(dòng)到/user/local目錄下

sudo mv tidb-v3.0.7-linux-amd64 /usr/local/

3.安裝tidib

sudo ln -s /usr/local/tidb-v3.0.7-linux-amd64 /usr/local/tidb

2. 準(zhǔn)備數(shù)據(jù)目錄

sudo mkdir -p /usr/local/tidb/conf/
sudo mkdir -p /data/1/tidb/kv/4402/import

3. 準(zhǔn)備配置文件

vi /usr/local/tidb/conf/tikv_4402.conf

client-urls="http://192.168.3.78:4205"
name="pd3"
data-dir="/data/1/tidb/pd/4205/"
peer-urls="http://192.168.3.78:4206"
initial-cluster="pd1=http://192.168.3.76:4206,pd2=http://192.168.3.77:4206,pd3=http://192.168.3.78:4206"
log-file="/data/log1/tidb/pd/4205_run.log"

注意：==name== 指定的名稱必須和初始化集群名稱的“==pd3==”（initial-cluster） 相同；其他2臺(tái)機(jī)器也是注意此處。

4. 啟動(dòng)TiPD

nohup /usr/local/tidb/bin/pd-server --config=/usr/local/tidb/conf/tipd_4205.conf  > /dev/null 2>&1 &

log-level = "info"
log-file = "/data/1/tidb/kv/4402/run.log"
[server]
addr = "192.168.3.78:4402"
[storage]
data-dir = "/data/1/tidb/kv/4402"
scheduler-concurrency = 1024000
scheduler-worker-pool-size = 100
#labels = {zone = "ZONE3", host = "10074"}
[pd]
#指定tipd節(jié)點(diǎn) 這里指定的都是tipd的client-urls
endpoints = ["192.168.3.76:4205","192.168.3.77:4205","192.168.3.78:4205"]  
[metric]
interval = "15s"
address = ""
job = "tikv"
[raftstore]
sync-log = false
region-max-size = "384MB"
region-split-size = "256MB"
[rocksdb]
max-background-jobs = 28
max-open-files = 409600
max-manifest-file-size = "20MB"
compaction-readahead-size = "20MB"
[rocksdb.defaultcf]
block-size = "64KB"
compression-per-level = ["no", "no", "lz4", "lz4", "lz4", "zstd", "zstd"]
write-buffer-size = "128MB"
max-write-buffer-number = 10
level0-slowdown-writes-trigger = 20
level0-stop-writes-trigger = 36
max-bytes-for-level-base = "512MB"
target-file-size-base = "32MB"
[rocksdb.writecf]
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 = "32MB"
[raftdb]
max-open-files = 409600
compaction-readahead-size = "20MB"
[raftdb.defaultcf]
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 = "32MB"
block-cache-size = "10G"
[import]
import-dir = "/data/1/tidb/kv/4402/import"
num-threads = 8
stream-channel-window = 128

==只需注意： [server] > addr 和 [pd] > endpoints ；其他2臺(tái)機(jī)器也是注意此處。==

4. 啟動(dòng)TiKV

nohup /usr/local/tidb/bin/tikv-server --config=/usr/local/tidb/conf/tikv_4402.conf  > /dev/null 2>&1 &

4.TiDB 安裝

1.安裝軟件

跟前面TiPD一樣。

2. 準(zhǔn)備配置文件

vi /usr/local/tidb/conf/tidb_4001.conf

host = "0.0.0.0"
port = 4001
#存儲(chǔ)類型指定為tikv。
store = "tikv"
#指定tipd節(jié)點(diǎn)。這里指定的都是tipd的client-urls
path = "192.168.3.76:4205,192.168.3.77:4205,192.168.3.78:4205"  
socket = ""
run-ddl = true
lease = "45s"
split-table = true
token-limit = 1000
oom-action = "log"
enable-streaming = false
lower-case-table-names = 2
[log]
level = "info"
format = "text"
disable-timestamp = false
slow-query-file = ""
slow-threshold = 300
expensive-threshold = 10000
query-log-max-len = 2048
[log.file]
filename = "/data/1/tidb/db/4001/tidb.log"
max-size = 300
max-days = 0
max-backups = 0
log-rotate = true
[security]
ssl-ca = ""
ssl-cert = ""
ssl-key = ""
cluster-ssl-ca = ""
cluster-ssl-cert = ""
cluster-ssl-key = ""
[status]
report-status = true
status-port = 10080  #±¨??db??μ?¨???úmetrics-addr = ""
metrics-interval = 15
[performance]
max-procs = 0
stmt-count-limit = 5000
tcp-keep-alive = true
cross-join = true
stats-lease = "3s"
run-auto-analyze = true
feedback-probability = 0.05
query-feedback-limit = 1024
pseudo-estimate-ratio = 0.8
[proxy-protocol]
networks = ""
header-timeout = 5
[plan-cache]
enabled = false
capacity = 2560
shards = 256
[prepared-plan-cache]
enabled = false
capacity = 100
[opentracing]
enable = false
rpc-metrics = false
[opentracing.sampler]
type = "const"
param = 1.0
sampling-server-url = ""
max-operations = 0
sampling-refresh-interval = 0
[opentracing.reporter]
queue-size = 0
buffer-flush-interval = 0
log-spans = false
local-agent-host-port = ""
[tikv-client]
grpc-connection-count = 16
commit-timeout = "41s"
[txn-local-latches]
enabled = false
capacity = 1024000
[binlog]
binlog-socket = ""

注意：==path== 這里指定的都是tipd的client-urls；

4. 啟動(dòng)TiBD

nohup /usr/local/tidb/bin/tidb-server --config=/usr/local/tidb/conf/tidb_4001.conf > /dev/null 2>&1 &

5.測試連接

mysql -h 192.168.3.70 -uroot -P 4001

made in andy

2019-12-19