桌面管理系统大规模部署优化策略

-- 终端日志表按月分表
CREATE TABLE client_log_202401 LIKE client_log_template;
CREATE TABLE client_log_202402 LIKE client_log_template;
CREATE TABLE client_log_202403 LIKE client_log_template;

-- 使用分区表（MySQL 5.7+）
CREATE TABLE client_logs (
    id BIGINT AUTO_INCREMENT,
    client_id VARCHAR(50),
    event_type VARCHAR(50),
    event_data JSON,
    created_at TIMESTAMP,
    PRIMARY KEY (id, created_at)
) PARTITION BY RANGE (UNIX_TIMESTAMP(created_at)) (
    PARTITION p202401 VALUES LESS THAN (UNIX_TIMESTAMP('2026-02-01')),
    PARTITION p202402 VALUES LESS THAN (UNIX_TIMESTAMP('2026-03-01')),
    PARTITION p202403 VALUES LESS THAN (UNIX_TIMESTAMP('2026-04-01')),
    PARTITION pmax VALUES LESS THAN MAXVALUE
);

-- 终端在线状态表
CREATE TABLE client_status (
    client_id VARCHAR(50) PRIMARY KEY,
    online_status TINYINT,
    last_seen TIMESTAMP,
    ip_address VARCHAR(50),
    version VARCHAR(20),
    INDEX idx_status_time (online_status, last_seen),
    INDEX idx_version (version)
) ENGINE=InnoDB;

-- 软件分发任务表
CREATE TABLE software_task (
    task_id BIGINT AUTO_INCREMENT PRIMARY KEY,
    task_name VARCHAR(200),
    target_group VARCHAR(100),
    status TINYINT,
    created_at TIMESTAMP,
    INDEX idx_status_created (status, created_at),
    INDEX idx_target (target_group),
    FULLTEXT INDEX idx_name (task_name)
) ENGINE=InnoDB;

# 应用程序数据源配置
spring.datasource.master.url=jdbc:mysql://192.168.1.10:3306/jw_desktop
spring.datasource.master.username=jw_write
spring.datasource.master.password=******

spring.datasource.slave.url=jdbc:mysql://192.168.1.11:3306/jw_desktop
spring.datasource.slave.username=jw_read
spring.datasource.slave.password=******

# 路由策略
# 写操作：INSERT/UPDATE/DELETE -> Master
# 读操作：SELECT -> Slave（报表查询）或 Master（实时数据）

{
    "distribution": {
        "mode": "hybrid",
        "server_seed_ratio": 0.1,
        "p2p_enabled": true,
        "max_peers": 50,
        "upload_limit": "2MB/s",
        "download_limit": "5MB/s",
        "lan_priority": true,
        "subnet_mask": "255.255.255.0"
    },
    "scheduling": {
        "allowed_hours": "20:00-08:00",
        "bandwidth_reserve": "30%",
        "concurrent_limit": 100
    }
}

<ClientConfig>
    <!-- CPU限制：扫描任务不超过30% -->
    <CpuLimit>
        <MaxPercent>30</MaxPercent>
        <BusinessHours>20</BusinessHours>
    </CpuLimit>
    
    <!-- 内存限制：最大占用512MB -->
    <MemoryLimit>
        <MaxMB>512</MaxMB>
        <AutoCleanup>true</AutoCleanup>
    </MemoryLimit>
    
    <!-- 网络限速：上传下载各2MB/s -->
    <BandwidthLimit>
        <UploadMax>2MB</UploadMax>
        <DownloadMax>2MB</DownloadMax>
        <Priority>Background</Priority>
    </BandwidthLimit>
    
    <!-- 磁盘IO限制 -->
    <DiskIOLimit>
        <MaxIOPS>100</MaxIOPS>
        <IdleScanOnly>true</IdleScanOnly>
    </DiskIOLimit>
</ClientConfig>

groups:
- name: jw_desktop_alerts
  rules:
  # 服务器高负载告警
  - alert: ServerHighLoad
    expr: 100 - (avg by(instance) (irate(node_cpu_seconds_total{mode="idle"}[5m])) * 100) > 80
    for: 5m
    labels:
      severity: warning
    annotations:
      summary: "服务器负载过高"
      description: "{{ $labels.instance }} CPU使用率超过80%"

  # 数据库慢查询告警
  - alert: MySQLSlowQueries
    expr: rate(mysql_global_status_slow_queries[5m]) > 10
    for: 5m
    labels:
      severity: warning
    annotations:
      summary: "MySQL慢查询增多"
      description: "每秒慢查询超过10条"

  # 终端掉线告警
  - alert: ClientOfflineRate
    expr: (jw_desktop_clients_offline / jw_desktop_clients_total) > 0.1
    for: 10m
    labels:
      severity: critical
    annotations:
      summary: "大量终端掉线"
      description: "离线终端比例超过10%"