# 1. 网络准备
– 配置跨数据中心专线
– 测试网络带宽和延迟
– 配置网络安全规则

# 2. 环境准备
– 准备服务器资源
– 安装操作系统
– 配置系统参数
– 安装TiUP

# 3. 规划拓扑
– 数据中心A：3TiDB + 5TiKV + 3PD
– 数据中心B：3TiDB + 5TiKV + 3PD
– 数据副本：3副本，分布在两个数据中心

# 1. 部署数据中心A集群
$ tiup cluster deploy fgedu-tidb-dc1 v7.1.0 ./dc1-topology.yaml –user root -p
$ tiup cluster start fgedu-tidb-dc1

# 2. 部署数据中心B集群
$ tiup cluster deploy fgedu-tidb-dc2 v7.1.0 ./dc2-topology.yaml –user root -p
$ tiup cluster start fgedu-tidb-dc2

# 3. 配置TiCDC双向同步
# 数据中心A到数据中心B
$ tiup cdc cli changefeed create –pd=http://dc1-pd:2379 –sink-uri=”mysql://root:password@dc2-tidb:4000/” –changefeed-id=”dc1-to-dc2″

# 数据中心B到数据中心A
$ tiup cdc cli changefeed create –pd=http://dc2-pd:2379 –sink-uri=”mysql://root:password@dc1-tidb:4000/” –changefeed-id=”dc2-to-dc1″

# 4. 配置负载均衡
# 使用全局负载均衡器，根据地理位置分发请求

学习交流加群风哥QQ113257174
# TiCDC配置文件示例
$ cat cdc.toml
[cdc]
addr = “0.0.0.0:8300”

[cdc.sink]
type = “mysql”
uri = “mysql://root:password@tidb:4000/”

[cdc.changefeed]
id = “dc1-to-dc2”
enable-old-value = true

[cdc.mounter]
enable = true

[cdc.sync]
ignore-txn-start-ts = 415515964564480

# Nginx负载均衡配置
$ cat /etc/nginx/conf.d/tidb-dual-active.conf
upstream tidb_dc1 {
server 192.168.1.100:4000;
server 192.168.1.101:4000;
server 192.168.1.102:4000;
}

upstream tidb_dc2 {
server 192.168.2.100:4000;
server 192.168.2.101:4000;
server 192.168.2.102:4000;
}

upstream tidb_global {
server 192.168.1.100:4000 weight=5;
server 192.168.1.101:4000 weight=5;
server 192.168.1.102:4000 weight=5;
server 192.168.2.100:4000 weight=5;
server 192.168.2.101:4000 weight=5;
server 192.168.2.102:4000 weight=5;
}

server {
listen 4000;
server_name tidb.fgedu.net.cn;

location / {
proxy_pass http://tidb_global;
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
}
}

# 1. 功能测试
# 验证双向数据同步
$ mysql -h dc1-tidb -P 4000 -u fgedu -p -e “create database if not exists fgedudb; use fgedudb; create table if not exists fgedu_test(id int primary key, name varchar(20)); insert into fgedu_test values(1, ‘test from dc1’);”
$ mysql -h dc2-tidb -P 4000 -u fgedu -p -e “select * from fgedudb.fgedu_test;”

$ mysql -h dc2-tidb -P 4000 -u fgedu -p -e “insert into fgedudb.fgedu_test values(2, ‘test from dc2’);”
$ mysql -h dc1-tidb -P 4000 -u fgedu -p -e “select * from fgedudb.fgedu_test;”

# 2. 性能测试
# 测试跨数据中心延迟
$ ping -c 10 dc2-tidb

# 测试数据同步延迟
$ mysql -h dc1-tidb -P 4000 -u fgedu -p -e “insert into fgedudb.fgedu_test values(3, now());”
$ sleep 1
$ mysql -h dc2-tidb -P 4000 -u fgedu -p -e “select * from fgedudb.fgedu_test where id=3;”

# 3. 故障测试
# 模拟数据中心A故障
$ ssh root@dc1-tidb “systemctl stop tidb”

# 验证数据中心B服务
$ mysql -h dc2-tidb -P 4000 -u fgedu -p -e “select version();”

# 验证负载均衡切换
$ mysql -h tidb.fgedu.net.cn -P 4000 -u fgedu -p -e “select version();”

# 恢复数据中心A
$ ssh root@dc1-tidb “systemctl start tidb”

# 验证数据同步恢复
$ mysql -h dc1-tidb -P 4000 -u fgedu -p -e “select * from fgedudb.fgedu_test;”