企业如何做好网站运营,成都高新区国土规划建设局网站,网站备案注销 万网,iis建设个人网站TiDB集群部署 服务器环境部署拓扑 都2024了还在为分库分表烦恼吗#x1f618;#xff0c;用分布式数据库TiDB、OceanBase、华为 GaussDB#xff0c;你就使劲往里存数据。 早下班、少脱发、脱单#xff01; #x1f64f;#x1f3fb;#x1f64f;#x1f3fb;#x1f6… 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: rootssh_port: 22deploy_dir: /data/tidb-deploydata_dir: /data/tidb-datalog_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: infopd_servers:- host: 193.0.18.174client_port: 23326deploy_dir: /data/tidb-deploy/pd-23326data_dir: /data/tidb-data/pd-23326log_dir: /data/tidb-deploy/pd-23326/log- host: 193.0.18.144client_port: 23326deploy_dir: /data/tidb-deploy/pd-23326data_dir: /data/tidb-data/pd-23326log_dir: /data/tidb-deploy/pd-23326/log- host: 193.0.18.145client_port: 23326deploy_dir: /data/tidb-deploy/pd-23326data_dir: /data/tidb-data/pd-23326log_dir: /data/tidb-deploy/pd-23326/log tidb_servers:- host: 193.0.18.174port: 4000status_port: 10080deploy_dir: /data/tidb-deploy/tidb-4000log_dir: /data/tidb-deploy/tidb-4000/log- host: 193.0.18.144port: 4000status_port: 10080deploy_dir: /data/tidb-deploy/tidb-4000log_dir: /data/tidb-deploy/tidb-4000/log- host: 193.0.18.145port: 4000status_port: 10080deploy_dir: /data/tidb-deploy/tidb-4000log_dir: /data/tidb-deploy/tidb-4000/logtikv_servers:- host: 193.0.18.174port: 20160status_port: 20180deploy_dir: /data/tidb-20160-deploy/tikv-20160data_dir: /data/tidb-20160-data/tikv-20160log_dir: /data/tidb-20160-deploy/tikv-20160/logconfig:server.labels: { host: logic-host-1 }- host: 193.0.18.144port: 20161status_port: 20181deploy_dir: /data/tidb-20161-deploy/tikv-20161data_dir: /data/tidb-20161-data/tikv-20161log_dir: /data/tidb-20161-deploy/tikv-20161/logconfig:server.labels: { host: logic-host-2 }- host: 193.0.18.145port: 20162status_port: 20182deploy_dir: /data/tidb-20162-deploy/tikv-20162data_dir: /data/tidb-20162-data/tikv-20162log_dir: /data/tidb-20162-deploy/tikv-20162/logconfig:server.labels: { host: logic-host-3 }cdc_servers:- host: 193.0.18.174port: 8300deploy_dir: /data/tidb-deploy/cdc-8300data_dir: /data/tidb-data/cdc-8300log_dir: /data/tidb-deploy/cdc-8300/log- host: 193.0.18.144port: 8301deploy_dir: /data/tidb-deploy/cdc-8301data_dir: /data/tidb-data/cdc-8301log_dir: /data/tidb-deploy/cdc-8301/log- host: 193.0.18.145port: 8302deploy_dir: /data/tidb-deploy/cdc-8302data_dir: /data/tidb-data/cdc-8302log_dir: /data/tidb-deploy/cdc-8302/logtiflash_servers:- host: 193.0.18.174data_dir: /data/tidb-9000-data/tiflash-9000log_dir: /data/tidb-9000-deploy/tiflash-9000/logdeploy_dir: /data/tidb-9000-deploy/tiflash-9000tiproxy_servers:- host: 193.0.18.174port: 13306monitoring_servers:- host: 193.0.18.174ng_port: 12020grafana_servers:- host: 193.0.18.174
