# 1. 部署主机房TiDB集群
$ tiup cluster deploy fgedu-tidb-primary v7.1.0 ./primary-topology.yaml –user root -p
$ tiup cluster start fgedu-tidb-primary

# 2. 部署备机房TiDB集群
$ tiup cluster deploy fgedu-tidb-secondary v7.1.0 ./secondary-topology.yaml –user root -p
$ tiup cluster start fgedu-tidb-secondary

# 3. 配置TiCDC进行数据同步
$ tiup cdc cli changefeed create –pd=http://primary-pd:2379 –sink-uri=”mysql://root:password@secondary-tidb:4000/fgedudb” –changefeed-id=”primary-to-secondary”

# 4. 验证数据同步
$ mysql -h primary-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’);”
$ mysql -h secondary-tidb -P 4000 -u fgedu -p -e “select * from fgedudb.fgedu_test;”

# 5. 配置故障切换
# 手动切换：在主机房故障时，修改应用连接指向备机房
# 自动切换：使用VIP或负载均衡器实现自动切换

# 1. 部署机房A TiDB集群
$ tiup cluster deploy fgedu-tidb-a v7.1.0 ./topology-a.yaml –user root -p
$ tiup cluster start fgedu-tidb-a

# 2. 部署机房B TiDB集群
$ tiup cluster deploy fgedu-tidb-b v7.1.0 ./topology-b.yaml –user root -p
$ tiup cluster start fgedu-tidb-b

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

# 机房B到机房A
$ tiup cdc cli changefeed create –pd=http://b-pd:2379 –sink-uri=”mysql://root:password@a-tidb:4000/” –changefeed-id=”b-to-a”

# 4. 配置负载均衡
# 使用全局负载均衡器，根据地理位置将请求分发到最近的机房

# 5. 验证双向数据同步
$ mysql -h a-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 A’);”
$ mysql -h b-tidb -P 4000 -u fgedu -p -e “select * from fgedudb.fgedu_test;”学习交流加群风哥QQ113257174

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

# TiCDC配置文件示例
$ cat cdc.toml
[cdc]
addr = “0.0.0.0:8300”

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

[cdc.changefeed]
id = “primary-to-secondary”
enable-old-value = true

[cdc.mounter]
enable = true

# Nginx全局负载均衡配置
$ cat /etc/nginx/conf.d/global-loadbalancer.conf
upstream tidb_servers {
server 192.168.1.100:4000 weight=5; # 机房A
server 192.168.2.100:4000 weight=5; # 机房B
}

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

location / {
proxy_pass http://tidb_servers;
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 primary-tidb -P 4000 -u fgedu -p -e “insert into fgedudb.fgedu_test values(3, ‘test’);”
$ mysql -h secondary-tidb -P 4000 -u fgedu -p -e “select * from fgedudb.fgedu_test;”

# 2. 性能测试
# 测试跨机房延迟
$ ping -c 10 secondary-tidb

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

# 3. 故障测试
# 模拟主机房故障
$ ssh root@primary-tidb “systemctl stop tidb”

# 验证备机房服务
$ mysql -h secondary-tidb -P 4000 -u fgedu -p -e “select version();”

# 模拟网络故障
$ iptables -A INPUT -s secondary-tidb -j DROP
$ iptables -A OUTPUT -d secondary-tidb -j DROP

# 验证系统恢复能力
$ iptables -D INPUT -s secondary-tidb -j DROP
$ iptables -D OUTPUT -d secondary-tidb -j DROP
$ mysql -h primary-tidb -P 4000 -u fgedu -p -e “select version();”