TiDB 简单集群部署拓扑文件

都2024了还在为分库分表烦恼吗😘，用分布式数据库TiDB、OceanBase、华为 GaussDB，你就使劲往里存数据。
早下班、少脱发、脱单！ 🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻

服务器环境

以下配置单表2亿数据无压力，集群节点越多性能越强
部署目标集群结构：

TiDB 3个节点
TiKV 3个节点
PD 3个节点
CDC 3个节点
TiFlash 1个节点
TiProxy 1个节点

• 服务器-1 （193.0.18.174）
  CPU核心：24 核
  内存：128 GB
  磁盘：1 TB
  系统：openEuler 22.03 LTS
• 服务器-2 （193.0.18.144）
  CPU核心：16 核
  内存：32 GB
  磁盘：1 TB
  系统：openEuler 22.03 LTS
• 服务器-3 （193.0.18.144）
  CPU核心：16 核
  内存：32 GB
  磁盘：1 TB
  系统：openEuler 22.03 LTS

部署拓扑

# # 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: "root"
 ssh_port: 22
 deploy_dir: "/data/tidb-deploy"
 data_dir: "/data/tidb-data"
 log_dir: "/data/tidb-log"

# # Monitored variables are applied to all the machines.
monitored:
 node_exporter_port: 9100
 blackbox_exporter_port: 9115

server_configs:
 tidb:
   instance.tidb_slow_log_threshold: 300
 tikv:
   readpool.storage.use-unified-pool: false
   readpool.coprocessor.use-unified-pool: true
 pd:
   replication.enable-placement-rules: true
   replication.location-labels: ["host"]
 tiflash:
   logger.level: "info"

pd_servers:
 - host: 193.0.18.174
   client_port: 23326
   deploy_dir: "/data/tidb-deploy/pd-23326"
   data_dir: "/data/tidb-data/pd-23326"
   log_dir: "/data/tidb-deploy/pd-23326/log"
 - host: 193.0.18.144
   client_port: 23326
   deploy_dir: "/data/tidb-deploy/pd-23326"
   data_dir: "/data/tidb-data/pd-23326"
   log_dir: "/data/tidb-deploy/pd-23326/log"
 - host: 193.0.18.145
   client_port: 23326
   deploy_dir: "/data/tidb-deploy/pd-23326"
   data_dir: "/data/tidb-data/pd-23326"
   log_dir: "/data/tidb-deploy/pd-23326/log"      

tidb_servers:
 - host: 193.0.18.174
   port: 4000
   status_port: 10080
   deploy_dir: "/data/tidb-deploy/tidb-4000"
   log_dir: "/data/tidb-deploy/tidb-4000/log"

 - host: 193.0.18.144
   port: 4000
   status_port: 10080
   deploy_dir: "/data/tidb-deploy/tidb-4000"
   log_dir: "/data/tidb-deploy/tidb-4000/log"

 - host: 193.0.18.145
   port: 4000
   status_port: 10080
   deploy_dir: "/data/tidb-deploy/tidb-4000"
   log_dir: "/data/tidb-deploy/tidb-4000/log"

tikv_servers:
 - host: 193.0.18.174
   port: 20160
   status_port: 20180
   deploy_dir: "/data/tidb-20160-deploy/tikv-20160"
   data_dir: "/data/tidb-20160-data/tikv-20160"
   log_dir: "/data/tidb-20160-deploy/tikv-20160/log"
   config:
     server.labels: { host: "logic-host-1" }

 - host: 193.0.18.144
   port: 20161
   status_port: 20181
   deploy_dir: "/data/tidb-20161-deploy/tikv-20161"
   data_dir: "/data/tidb-20161-data/tikv-20161"
   log_dir: "/data/tidb-20161-deploy/tikv-20161/log"
   config:
     server.labels: { host: "logic-host-2" }

 - host: 193.0.18.145
   port: 20162
   status_port: 20182
   deploy_dir: "/data/tidb-20162-deploy/tikv-20162"
   data_dir: "/data/tidb-20162-data/tikv-20162"
   log_dir: "/data/tidb-20162-deploy/tikv-20162/log"
   config:
     server.labels: { host: "logic-host-3" }

cdc_servers:
  - host: 193.0.18.174
    port: 8300
    deploy_dir: "/data/tidb-deploy/cdc-8300"
    data_dir: "/data/tidb-data/cdc-8300"
    log_dir: "/data/tidb-deploy/cdc-8300/log"

  - host: 193.0.18.144
    port: 8301
    deploy_dir: "/data/tidb-deploy/cdc-8301"
    data_dir: "/data/tidb-data/cdc-8301"
    log_dir: "/data/tidb-deploy/cdc-8301/log"

  - host: 193.0.18.145
    port: 8302
    deploy_dir: "/data/tidb-deploy/cdc-8302"
    data_dir: "/data/tidb-data/cdc-8302"
    log_dir: "/data/tidb-deploy/cdc-8302/log"

tiflash_servers:
 - host: 193.0.18.174
   data_dir: "/data/tidb-9000-data/tiflash-9000"
   log_dir: "/data/tidb-9000-deploy/tiflash-9000/log"
   deploy_dir: "/data/tidb-9000-deploy/tiflash-9000"

tiproxy_servers:
 - host: 193.0.18.174
   port: 13306

monitoring_servers:
 - host: 193.0.18.174
   ng_port: 12020

grafana_servers:
 - host: 193.0.18.174

原文地址：https://blog.csdn.net/weixin_42703501/article/details/142482811

免责声明：本站文章内容转载自网络资源，如本站内容侵犯了原著者的合法权益，可联系本站删除。更多内容请关注自学内容网（zxcms.com）！