当前位置: 首页 > news >正文

TiDB 简单集群部署拓扑文件

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: 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
http://www.lryc.cn/news/445174.html

相关文章:

  • 十三 系统架构设计(考点篇)
  • Java-数据结构-二叉树-习题(三)  ̄へ ̄
  • SpringBoot+Aop+注解方式 实现多数据源动态切换
  • 企业如何高效应对多类型知识产权事务的复杂挑战?
  • openeuler22.03 LTS 源码编译安装nginx1.22.1
  • 图片压缩工具免费怎么找?归纳了这几个压缩工具
  • 【Kubernetes知识点】解读HPA的 thrashing(抖动)问题
  • Unity 设计模式 之 结构型模式 -【装饰者模式】【外观模式】【享元模式】【代理模式】
  • Linux上Qt安装相关的内容及在QtCreator使用QChart模块需要的配置
  • lettuce引起的Redis command timeout异常
  • 【Hadoop】一、Hadoop入门:基础配置、集群配置、常用脚本
  • Ollama:本地运行大模型【含UI界面】
  • 【论文阅读】Grounding Language with Visual Affordances over Unstructured Data
  • 目标检测:滑块验证
  • Unreal Engine 5 C++: 编辑器工具编写入门01(中文解释)
  • 力扣上刷题之C语言实现-Day2
  • Visual Studio 2022 - QT 环境中文字符乱码问题
  • 获得ASPICE认证需要满足哪些条件?
  • 鸿蒙_异步详解
  • linux日志查询搜索view
  • 性能测试工具——JMeter
  • 1.《DevOps》系列K8S部署CICD流水线之部署K8S集群~version1.28.2
  • c/c++八股文
  • Docker配置代理解决pull超时问题
  • ECharts的特点
  • JVM OutOfMemoryError 与 StackOverflowError 异常
  • linux防火墙学习
  • Java面试篇基础部分- Java中的阻塞队列
  • Go语言并发编程之Channels详解
  • 【Java集合】LinkedList