手动安装TiDB集群之PD,KV,SERVER节点部署

peer-urls = "http://192.168.1.11:5201"
data-dir = "/data/tidb_5101"
name = "192.168.1.11:5101"
client-urls = "http://192.168.1.11:5101"
initial-cluster = "192.168.1.11:5101=http://192.168.1.11:5201,192.168.1.12:5101=http://192.168.1.12:5201,192.168.1.13:5101=http://192.168.1.13:5201"
[log]
level = "info"
format = "text"
[log.file]
max-backups = 7
filename = "/data/tidblog_5101/run.log"
log-rotate = true
[metric]
interval = "15s"
[schedule]
max-merge-region-size = 20
max-merge-region-keys = 200000
split-merge-interval = "1h"
max-snapshot-count = 3
max-pending-peer-count = 16
max-store-down-time = "30m"
leader-schedule-limit = 4
region-schedule-limit = 64
replica-schedule-limit = 64
merge-schedule-limit = 8
hot-region-schedule-limit = 4
[replication]
max-replicas = 3

log-level = "warning"
log-file = "/data/tidblog_5301/run.log"
log-rotation-timespan = "24h"
[server]
addr = "192.168.1.11:5301"
status-addr = "192.168.1.11:5401"
grpc-concurrency = 6
[readpool.storage]
normal-concurrency = 10
[storage]
data-dir = "/data/tidb_5301"
scheduler-concurrency = 1024000
scheduler-worker-pool-size = 4
[pd]
endpoints = ["192.168.1.11:5101", "192.168.1.12:5101", "192.168.1.13:5101"]
[metric]
interval = "5s"
[raftstore]
sync-log = false
store-pool-size = 3
apply-pool-size = 3
[rocksdb]
max-background-jobs = 2
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 = 5
max-bytes-for-level-base = "512MB"
target-file-size-base = "8MB"
[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 = "8MB"
[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"
[rocksdb.lockcf]
[storage.block-cache]
capacity = "4GB"
[security]
[import]
import-dir = "/data/tidb_5301/import"
num-threads = 2
stream-channel-window = 128

compatible-kill-query = false
lower-case-table-names = 2
enable-streaming = false
oom-action = "log"
token-limit = 1000
split-table = true
lease = "45s"
run-ddl = true
path = "192.168.1.11:5101,192.168.1.12:5101,192.168.1.13:5101"
store = "tikv"
port = 5501
host = "0.0.0.0"
[log]
level = "warn"
format = "text"
disable-timestamp = false
slow-query-file = "/data/tidblog_5501/slow.log"
slow-threshold = 300
expensive-threshold = 10000
query-log-max-len = 2048
[log.file]
filename = "/data/tidblog_5501/run.log"
max-size = 300
max-days = 0
max-backups = 0
log-rotate = true
[security]
[status]
report-status = true
status-port = 5601
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 = 0
pseudo-estimate-ratio = 0.8
force-priority = "NO_PRIORITY"
[proxy-protocol]
header-timeout = 5
[opentracing]
enable = false
rpc-metrics = false
[opentracing.reporter]
queue-size = 0
buffer-flush-interval = 0
log-spans = false
[opentracing.sampler]
type = "const"
param = 1.0
max-operations = 0
sampling-refresh-interval = 0
[tikv-client]
grpc-connection-count = 16
commit-timeout = "41s"
grpc-keepalive-time = 10
grpc-keepalive-timeout = 3
max-batch-wait-time = 2000000
[txn-local-latches]
enabled = false
capacity = 1024000
[binlog]
enable=false
ignore-error = false
write-timeout = "15s"