🏗️ 基础设施架构手册

# /etc/mha/app1.cnf — MHA 应用配置
[server default]
manager_workdir=/var/log/mha/app1
manager_log=/var/log/mha/app1/manager.log
user=mha_monitor
password=mha_pass
repl_user=repl
repl_password=repl_pass
ssh_user=root

[server1]
hostname=10.0.0.1
port=3306
candidate_master=1   # 可提升为主库

[server2]
hostname=10.0.0.2
port=3306
candidate_master=1

[server3]
hostname=10.0.0.3
port=3306
no_master=1          # 永远不提升为主库（纯从库）

# 启动 MHA Manager
# masterha_manager --conf=/etc/mha/app1.cnf &
# 检查状态
# masterha_check_status --conf=/etc/mha/app1.cnf

# application.yml — ShardingSphere-JDBC 分片配置
spring:
  shardingsphere:
    datasource:
      names: ds0,ds1           # 两个数据源
      ds0:
        type: com.zaxxer.hikari.HikariDataSource
        jdbc-url: jdbc:mysql://10.0.0.1:3306/order_db_0
        username: root
        password: root
      ds1:
        type: com.zaxxer.hikari.HikariDataSource
        jdbc-url: jdbc:mysql://10.0.0.2:3306/order_db_1
        username: root
        password: root
    rules:
      sharding:
        tables:
          order_info:                          # 分片表
            actual-data-nodes: ds0.order_info_$->{0..4},ds1.order_info_$->{5..9}  # 10张表
            table-strategy:
              standard:
                sharding-column: id            # 按id分片
                sharding-algorithm-name: order-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake    # 雪花算法生成ID
        sharding-algorithms:
          order-inline:
            type: INLINE
            props:
              algorithm-expression: order_info_$->{id % 10}  # 取模分片

<!-- pom.xml -->
<dependency>
    <groupId>com.alibaba.cloud</groupId>
    <artifactId>spring-cloud-starter-alibaba-nacos-config</artifactId>
</dependency>

# bootstrap.yml
spring:
  application:
    name: order-service
  cloud:
    nacos:
      config:
        server-addr: 10.0.0.100:8848
        namespace: dev
        group: DEFAULT_GROUP
        file-extension: yaml
        shared-configs:        # 共享配置（多个服务公用）
          - data-id: common-db.yaml
            group: DEFAULT_GROUP
            refresh: true

// 动态刷新示例：配置变更时自动生效，无需重启
@RestController
@RefreshScope              // Nacos配置变更时自动刷新
public class ConfigController {

    @Value("${order.max-retry:3}")
    private int maxRetry;

    @Value("${order.timeout-seconds:30}")
    private int timeoutSeconds;

    @GetMapping("/config/info")
    public Map<String, Object> getConfig() {
        return Map.of(
            "maxRetry", maxRetry,
            "timeoutSeconds", timeoutSeconds
        );
    }
}