业务范围涵盖涵半投资银行直接投资.证券.保险.基金、飞机租 赁.资产管理,金融科技等多个领域,为全球客户提供全面的金融服务。 业务挑战 中国银行在生产实践中采用中 Zabbix 运维监控方案, 作为开源云原生方案, Zabbix 一直使用 MySQL 作为 后端存储, 在面对更大规模监控需求的时候, 单机 MySQL 数据库面临性能和容量瓶颈, 无法支持几T量级 的数据, 使得监控对象的数量和数据存储时间不能莱得。 TiDB 是兼容 MySQL 协议的分布式数据库, 在易用性与平滑升级方面比其他监控后台数据库方案更有优 势,中国银行决定采用 TiDB 痊换 Zabbix 后端的 MySQL,构建新一代运维监控平台。 Tizabbix 解决方案 在不改动 Zabbix 源码的情况下,采用 TiDB 普换 MYSQL, 实现监控数据的采集,存储和查询, 把监控对象的 自动注册改为使用 API 延迟注册, 解决事务冲突的问题TiDB 解决事务冲突的问题TiDB 支持表分区, 通过 Drop Partition 来解决历史 数据的删除问题。 TiZabbix 方案的架构设计简洁,采用 Agent 主动模式有效减少 zabbix Server 的压力, 在大规模数据量场 景下, 通过灵活使用API来规避一些 Web 操作的失效问题。目前, Tizabbix 方案在中国银行各类场景中监 控对象的数量超过 10000+, 数据量达到 18T

外⽹代理服务访问监控组件，配置外⽹代理时需注意不要开放不必要的端⼝，避免⽹络安全事故。 代理节点 代理节点 TiDB服务集群提供两个Proxy节点，⽤以代理Dashboard/Grafana/Prometheus服务 您可以通过‘详情’⻚中的节点列表中选择‘PROXY’查询到当前节点代理地址 配置访问代理 配置访问代理 Dashboard/监控访问 分布式NewSQL数据库 TiDB Copyright /etc/nginx/nginx.conf 在 http 中添加下⾯配置： # prometheus proxy upstream prometheus_server { server 10.9.163.206:9090; # 使⽤详情中PROXY prometheus 地址 server 10.9.174.142:9090; # 使⽤详情中PROXY prometheus 地址 } server { listen 9090; 9090; # 端⼝⾃定，注意防⽕墙开放端⼝ location / { proxy_pass http://prometheus_server/; } } # grafana proxy Dashboard/监控访问 分布式NewSQL数据库 TiDB Copyright © 2012-2021 UCloud 优刻得 44/120 upstream grafana_server { server 10.9

tidb_enable_tso_follower_proxy �→ Newly added Determines whether to enable or disable the TSO Follower Proxy feature. The default value is OFF, which means the TSO Follower Proxy feature is disabled. At timestamp processing flow and reduces the timestamp processing load of PD by enabling PD Follower Proxy and modifying the batch waiting time required when the PD client requests TSO in batches. This helps disabling PD Follower Proxy through the system variable tidb_enable_tso_follower_proxy. Suppose that the TSO requests load of PD is too high. In this case, enabling PD follower proxy can batch forward the

ser- vice port TiFlash20170 the Ti- Flash Proxy ser- vice port 119 Component Default Port Description TiFlash20292 the port for Prometheus to pull Ti- Flash Proxy met- rics TiFlash 8234 the port for Prometheus often has things to do with the use of a proxy. You can add pressure on single TiDB server, sum each result up and compare the summed result with the result with proxy. Take HAproxy as an example. The parameter versions of HAproxy also support nbthread and cpu-map. All of these can mitigate the negative impact of proxy use on performance. 186 4.6.1.3.2 Under high concurrency, why is the CPU utilization rate of TiKV

documentation. 40 2.2.1.4 Availability • Support the proxy component TiProxy (experimental) #413 @djshow832 @xhebox TiProxy is the official proxy component of TiDB, located between the client and TiDB now includes tiproxy �→ -{version}-linux-{arch}.tar.gz, which is the installation package for the proxy com- ponent TiProxy. 2.2.4 Deprecated features • Support for the TLSv1.0 and TLSv1.1 protocols is e- cu- tion Frame- work (DXF) tasks Y Y N N N N N N N N N PD Fol- lower Proxy (con- trolled by tidb_enable_tso_follower_proxy �→ ) Y Y Y Y Y Y Y N N N N Active PD Fol- lower (con- trolled by pd_ena

without worrying about incorrectly terminating other queries or sessions by mistake when there is a proxy between the client and TiDB. Currently, TiDB does not support using Ctrl+C to terminate queries or it.), Spring auto- matically wraps all objects with the @Transactional annotation in a proxy and uses this proxy for object invocation processing. You can simply assume that when the agent calls a function clean up connections after a specific idle period (determined by the proxy’s idle configuration). In addition to monitoring the proxy’s idle configuration, connection pools also need to maintain or probe

ser- vice port TiFlash20170 the Ti- Flash Proxy ser- vice port 95 Component Default Port Description TiFlash20292 the port for Prometheus to pull Ti- Flash Proxy met- rics TiFlash 8234 the port for Prometheus often has things to do with the use of a proxy. You can add pressure on single TiDB server, sum each result up and compare the summed result with the result with proxy. Take HAproxy as an example. The parameter versions of HAproxy also support nbthread and cpu-map. All of these can mitigate the negative impact of proxy use on performance. 154 4.6.1.3.2 Under high concurrency, why is the CPU utilization rate of TiKV

Frame- work (DXF) tasks Y Y Y Y N N N N N N N PD Fol- lower Proxy (con- trolled by tidb �→ _ �→ enable �→ _ �→ tso �→ _ �→ follower �→ _ �→ proxy �→ ) Y Y Y Y Y Y Y Y Y Y N N 106 Management, ob- serv- clean up connections after a specific idle period (determined by the proxy’s idle configuration). In addition to monitoring the proxy’s idle configuration, connection pools also need to maintain or probe that this connection was idle for a long time and then closed by the proxy. The usual solution is to increase the value of the proxy’s idle configuration and allow the connection pool to: • Check whether

Frame- work (DXF) tasks Y Y Y Y N N N N N N N PD Fol- lower Proxy (con- trolled by tidb �→ _ �→ enable �→ _ �→ tso �→ _ �→ follower �→ _ �→ proxy �→ ) Y Y Y Y Y Y Y Y Y Y N N 101 Management, ob- serv- clean up connections after a specific idle period (determined by the proxy’s idle configuration). In addition to monitoring the proxy’s idle configuration, connection pools also need to maintain or probe that this connection was idle for a long time and then closed by the proxy. The usual solution is to increase the value of the proxy’s idle configuration and allow the connection pool to: • Check whether

3 8.2 8.1 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 PD Fol- lower Proxy (con- trolled by tidb �→ _ �→ enable �→ _ �→ tso �→ _ �→ follower �→ _ �→ proxy �→ ) Y Y Y Y Y Y Y Y Y N N Active PD Fol- lower (con- trolled clean up connections after a specific idle period (determined by the proxy’s idle configuration). In addition to monitoring the proxy’s idle configuration, connection pools also need to maintain or probe that this connection was idle for a long time and then closed by the proxy. The usual solution is to increase the value of the proxy’s idle configuration and allow the connection pool to: • Check whether