# # Global variables are applied to all deployments and used as the default value of # # the deployments if a specific deployment value is missing. global: user: "tidb" ssh_port: 22 deploy_dir: "/tidb-deploy" data_dir: "/tidb-data" # # Resource Control is used to limit the resource of an instance. # # See: https://www.freedesktop.org/software/systemd/man/systemd.resource-control.html # # Supports using instance-level `resource_control` to override global `resource_control`. # resource_control: # # See: https://www.freedesktop.org/software/systemd/man/systemd.resource-control.html#IOReadBandwidthMax=device%20bytes # memory_limit: "2G" # # See: https://www.freedesktop.org/software/systemd/man/systemd.resource-control.html#IOReadBandwidthMax=device%20bytes # cpu_quota: "20%" # # See: https://www.freedesktop.org/software/systemd/man/systemd.resource-control.html#IOReadBandwidthMax=device%20bytes # io_read_bandwidth_max: "/dev/disk/by-path/pci-0000:00:1f.2-scsi-0:0:0:0 100M" # io_write_bandwidth_max: "/dev/disk/by-path/pci-0000:00:1f.2-scsi-0:0:0:0 100M" # # Monitored variables are applied to all the machines. monitored: node_exporter_port: 9100 blackbox_exporter_port: 9115 # deploy_dir: "/tidb-deploy/monitored-9100" # data_dir: "/tidb-data/monitored-9100" # log_dir: "/tidb-deploy/monitored-9100/log" # # Server configs are used to specify the runtime configuration of TiDB components. # # All configuration items can be found in TiDB docs: # # # # - TiDB: https://pingcap.com/docs/stable/reference/configuration/tidb-server/configuration-file/ # # - TiKV: https://pingcap.com/docs/stable/reference/configuration/tikv-server/configuration-file/ # # - PD: https://pingcap.com/docs/stable/reference/configuration/pd-server/configuration-file/ # # # # All configuration items use points to represent the hierarchy, e.g: # # readpool.storage.use-unified-pool # # ^ ^ # # You can overwrite this configuration via the instance-level `config` field. server_configs: tidb: log.slow-threshold: 300 binlog.enable: false binlog.ignore-error: false tikv: # server.grpc-concurrency: 4 # raftstore.apply-pool-size: 2 # raftstore.store-pool-size: 2 # rocksdb.max-sub-compactions: 1 # storage.block-cache.capacity: "16GB" # readpool.unified.max-thread-count: 12 readpool.storage.use-unified-pool: false readpool.coprocessor.use-unified-pool: true pd: schedule.leader-schedule-limit: 4 schedule.region-schedule-limit: 2048 schedule.replica-schedule-limit: 64 tiflash: # path_realtime_mode: false logger.level: "info" tiflash-learner: log-level: "info" # raftstore.apply-pool-size: 4 # raftstore.store-pool-size: 4 pump: gc: 7 pd_servers: - host: 10.0.1.11 # ssh_port: 22 # name: "pd-1" # client_port: 2379 # peer_port: 2380 # deploy_dir: "/tidb-deploy/pd-2379" # data_dir: "/tidb-data/pd-2379" # log_dir: "/tidb-deploy/pd-2379/log" # numa_node: "0,1" # # The following configs are used to overwrite the `server_configs.pd` values. # config: # schedule.max-merge-region-size: 20 # schedule.max-merge-region-keys: 200000 - host: 10.0.1.12 - host: 10.0.1.13 tidb_servers: - host: 10.0.1.11 # ssh_port: 22 # port: 4000 # status_port: 10080 # deploy_dir: "/tidb-deploy/tidb-4000" # log_dir: "/tidb-deploy/tidb-4000/log" # numa_node: "0,1" # # The following configs are used to overwrite the `server_configs.tidb` values. # config: # log.level: warn # log.slow-query-file: tidb-slow-overwrited.log - host: 10.0.1.12 tikv_servers: - host: 10.0.1.14 # ssh_port: 22 # port: 20160 # status_port: 20180 # deploy_dir: "/tidb-deploy/tikv-20160" # data_dir: "/tidb-data/tikv-20160" # log_dir: "/tidb-deploy/tikv-20160/log" # numa_node: "0,1" # # The following configs are used to overwrite the `server_configs.tikv` values. # config: # server.grpc-concurrency: 4 # server.labels: { zone: "zone1", dc: "dc1", host: "host1" } - host: 10.0.1.15 - host: 10.0.1.16 tiflash_servers: - host: 10.0.1.14 # ssh_port: 22 # tcp_port: 9000 # http_port: 8123 # flash_service_port: 3930 # flash_proxy_port: 20170 # flash_proxy_status_port: 20292 # metrics_port: 8234 # deploy_dir: /tidb-deploy/tiflash-9000 # data_dir: /tidb-data/tiflash-9000 # log_dir: /tidb-deploy/tiflash-9000/log # numa_node: "0,1" # # # # `path_realtime_mode` only works if `data_dir` is specified with multiple paths. # # # # path_realtime_mode: # # "true" means only other paths instead of first path can be used to store older data. # # "false" means all paths can be used to store older data. # # # # TiFlash only uses the first path to store the latest data (i.e. "delta"). And others for the older data (i.e. "stable". which is the majority of data), # # # # E.g, if you intend to use an fast and smaller NVMe SSD (256GB) to speed up data ingestion speed in TiFlash, # # and 4 extra normal SSDs (512GB each) for main storage. Then your configurations should be look like: # # # # data_dir: /nvme_ssd_256/data,/ssd1_512/data,/ssd2_512/data,/ssd3_512/data,/ssd4_512/data # # config: # # path_realtime_mode: true # # # # # # And if your first disk is big enough, to fully use the capacity of it, use configurations look like: # # # # data_dir: /nvme_ssd_512/data,/ssd1_512/data,/ssd2_512/data,/ssd3_512/data,/ssd4_512/data # # config: # # path_realtime_mode: false # # # # # # The following configs are used to overwrite the `server_configs.tiflash` values. # config: # path_realtime_mode: false # logger.level: "info" # # The following configs are used to overwrite the `server_configs.tiflash-learner` values. # learner_config: # log-level: "info" # raftstore.apply-pool-size: 4 # raftstore.store-pool-size: 4 - host: 10.0.1.15 - host: 10.0.1.16 # pump_servers: # - host: 10.0.1.17 # ssh_port: 22 # port: 8250 # deploy_dir: "/tidb-deploy/pump-8249" # data_dir: "/tidb-data/pump-8249" # log_dir: "/tidb-deploy/pump-8249/log" # numa_node: "0,1" # # The following configs are used to overwrite the `server_configs.drainer` values. # config: # gc: 7 # - host: 10.0.1.18 # - host: 10.0.1.19 # drainer_servers: # - host: 10.0.1.17 # port: 8249 # data_dir: "/tidb-data/drainer-8249" # # If drainer doesn't have a checkpoint, use initial commitTS as the initial checkpoint. # # Will get a latest timestamp from pd if commit_ts is set to -1 (the default value). # commit_ts: -1 # deploy_dir: "/tidb-deploy/drainer-8249" # log_dir: "/tidb-deploy/drainer-8249/log" # numa_node: "0,1" # # The following configs are used to overwrite the `server_configs.drainer` values. # config: # syncer.db-type: "mysql" # syncer.to.host: "127.0.0.1" # syncer.to.user: "root" # syncer.to.password: "" # syncer.to.port: 3306 # - host: 10.0.1.19 # cdc_servers: # - host: 10.0.1.20 # ssh_port: 22 # port: 8300 # deploy_dir: "/tidb-deploy/cdc-8300" # log_dir: "/tidb-deploy/cdc-8300/log" # numa_node: "0,1" # - host: 10.0.1.21 # - host: 10.0.1.22 monitoring_servers: - host: 10.0.1.11 # ssh_port: 22 # port: 9090 # deploy_dir: "/tidb-deploy/prometheus-8249" # data_dir: "/tidb-data/prometheus-8249" # log_dir: "/tidb-deploy/prometheus-8249/log" grafana_servers: - host: 10.0.1.11 # port: 3000 # deploy_dir: /tidb-deploy/grafana-3000 alertmanager_servers: - host: 10.0.1.11 # ssh_port: 22 # web_port: 9093 # cluster_port: 9094 # deploy_dir: "/tidb-deploy/alertmanager-9093" # data_dir: "/tidb-data/alertmanager-9093" # log_dir: "/tidb-deploy/alertmanager-9093/log"