# 创建实例参数配置
– 地域：华东1（杭州）
– 可用区：可用区A+B+C（多可用区部署）
– 数据库版本：v7.5.0
– 系列：高可用版
– 节点规格：
– TiDB：2核8GB × 2节点
– TiKV：8核32GB + 500GB ESSD × 3节点
– PD：2核4GB × 3节点

# 3. 配置网络
– VPC：vpc-fgedudb
– 交换机：vsw-fgedudb-a, vsw-fgedudb-b, vsw-fgedudb-c
– 安全组：sg-fgedudb

# 4. 配置账号
– 管理员账号：root
– 密码：Fgedu@2024!

# 5. 确认订单并创建
# 创建完成后获取连接地址学习交流加群风哥QQ113257174
内网地址：fgedudb.tidb.rds.aliyuncs.com
端口：4000

Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12345
Server version: 5.7.25-TiDB-v7.5.0 TiDB Server (Apache License 2.0) Community Edition, MySQL 5.7 compatible

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> select tidb_version();
+————————————————————————————————————————————————————————————————————————————————————————————+
| tidb_version() |
+————————————————————————————————————————————————————————————————————————————————————————————+
| Release Version: v7.5.0
Edition: Community
Git Commit Hash: 01fe22c99c0c6f7c1f2c3d4e5f6a7b8c9d0e1f2a
Git Branch: heads/refs/tags/v7.5.0
UTC Build Time: 2024-01-15 10:00:00
GoVersion: go1.21.5
Race Enabled: false
Check Table Before Drop: false
Store: tikv |
+————————————————————————————————————————————————————————————————————————————————————————————+
1 row in set (0.01 sec)

# 创建测试数据库
mysql> create database fgedudb01;
Query OK, 0 rows affected (0.12 sec)

mysql> use fgedudb01;
Database changed

mysql> create table fgedu_orders (
-> order_id bigint primary key auto_increment,
-> user_id bigint not null,
-> amount decimal(10,2) not null,
-> status varchar(20) default ‘pending’,
-> created_at timestamp default current_timestamp
-> );
Query OK, 0 rows affected (0.15 sec)

mysql> insert into fgedu_orders (user_id, amount, status) values
-> (10001, 199.99, ‘completed’),
-> (10002, 299.50, ‘completed’),
-> (10003, 99.00, ‘pending’),
-> (10004, 599.00, ‘completed’);
Query OK, 4 rows affected (0.02 sec)
Records: 4 Duplicates: 0 Warnings: 0

mysql> select * from fgedu_orders;
+———-+———+——–+———–+———————+
| order_id | user_id | amount | status | created_at |
+———-+———+——–+———–+———————+
| 1 | 10001 | 199.99 | completed | 2024-04-09 10:30:00 |
| 2 | 10002 | 299.50 | completed | 2024-04-09 10:30:00 |
| 3 | 10003 | 99.00 | pending | 2024-04-09 10:30:00 |
| 4 | 10004 | 599.00 | completed | 2024-04-09 10:30:00 |
+———-+———+——–+———–+———————+
4 rows in set (0.01 sec)

# 集群配置
– 云服务商：Amazon Web Services
– 区域：US West (Oregon)
– 节点配置：
– TiDB：2 vCPU, 8GB RAM × 2
– TiKV：8 vCPU, 32GB RAM, 500GB Storage × 3
– 版本：v7.5.0

# 4. 配置IP访问列表
– 添加应用服务器公网IP
– 添加运维人员公网IP

# 5. 创建集群
# 等待约10-15分钟，集群创建完成

# 获取连接信息
Host: gateway01.us-west-2.prod.aws.tidbcloud.com
Port: 4000
User: 3x7xxxxx.root
Password: xxxxxxxx

# 使用MySQL客户端连接
# mysql –connect-timeout 15 -u ‘3x7xxxxx.root’ -h gateway01.us-west-2.prod.aws.tidbcloud.com -P 4000 -D test –ssl-mode=VERIFY_IDENTITY –ssl-ca=/path/to/ca.pem -p

Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1234567
Server version: 5.7.25-TiDB-v7.5.0 TiDB Server (Apache License 2.0) Community Edition, MySQL 5.7 compatible

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> show databases;
+——————–+
| Database |
+——————–+
| INFORMATION_SCHEMA |
| fgedudb01 |
| fgedudb02 |
| mysql |
| performance_schema |
| test |
+——————–+
6 rows in set (0.02 sec)

# 创建业务数据库
mysql> create database fgedu_ecommerce;
Query OK, 0 rows affected (0.11 sec)

mysql> use fgedu_ecommerce;
Database changed

mysql> create table fgedu_products (
-> product_id bigint primary key auto_increment,
-> product_name varchar(200) not null,
-> price decimal(10,2) not null,
-> stock int default 0,
-> category varchar(50),
-> created_at timestamp default current_timestamp
-> );
Query OK, 0 rows affected (0.14 sec)

mysql> insert into fgedu_products (product_name, price, stock, category) values
-> (‘TiDB企业版授权’, 50000.00, 100, ‘软件’),
-> (‘TiDB培训课程’, 2999.00, 500, ‘服务’),
-> (‘数据库运维服务’, 15000.00, 50, ‘服务’);
Query OK, 3 rows affected (0.03 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> select * from fgedu_products;
+————+——————+———-+——-+———-+———————+
| product_id | product_name | price | stock | category | created_at |
+————+——————+———-+——-+———-+———————+
| 1 | TiDB企业版授权 | 50000.00 | 100 | 软件 | 2024-04-09 10:35:00 |
| 2 | TiDB培训课程 | 2999.00 | 500 | 服务 | 2024-04-09 10:35:00 |
| 3 | 数据库运维服务 | 15000.00 | 50 | 服务 | 2024-04-09 10:35:00 |
+————+——————+———-+——-+———-+———————+
3 rows in set (0.01 sec)

# GCP集群配置
– 区域：us-west1 (Oregon)
– 节点配置：
– TiDB：n2-standard-4 (4 vCPU, 16GB) × 2
– TiKV：n2-highmem-8 (8 vCPU, 64GB) × 3
– 存储：500GB PD-SSD per TiKV

# 4. 配置VPC Peering（可选）
# 用于与现有GCP VPC网络互通

# 5. 创建集群并等待完成

# 连接信息
Host: gateway01.us-west1.gcp.tidbcloud.com
Port: 4000