网站建设过程和准备阶段郑州市建设工程造价信息网

都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: 22deploy_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: 9100blackbox_exporter_port: 9115server_configs:tidb:instance.tidb_slow_log_threshold: 300tikv:readpool.storage.use-unified-pool: falsereadpool.coprocessor.use-unified-pool: truepd:replication.enable-placement-rules: truereplication.location-labels: ["host"]tiflash:logger.level: "info"pd_servers:- host: 193.0.18.174client_port: 23326deploy_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.144client_port: 23326deploy_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.145client_port: 23326deploy_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.174port: 4000status_port: 10080deploy_dir: "/data/tidb-deploy/tidb-4000"log_dir: "/data/tidb-deploy/tidb-4000/log"- host: 193.0.18.144port: 4000status_port: 10080deploy_dir: "/data/tidb-deploy/tidb-4000"log_dir: "/data/tidb-deploy/tidb-4000/log"- host: 193.0.18.145port: 4000status_port: 10080deploy_dir: "/data/tidb-deploy/tidb-4000"log_dir: "/data/tidb-deploy/tidb-4000/log"tikv_servers:- host: 193.0.18.174port: 20160status_port: 20180deploy_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.144port: 20161status_port: 20181deploy_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.145port: 20162status_port: 20182deploy_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.174port: 8300deploy_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.144port: 8301deploy_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.145port: 8302deploy_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.174data_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.174port: 13306monitoring_servers:- host: 193.0.18.174ng_port: 12020grafana_servers:- host: 193.0.18.174