spring init -d=web,data-jpa,mysql,actuator backup-service

[/span>dependency
    [/span>groupIdorg.zeroturnaroundgroupId
    [/span>artifactIdzt-execartifactId
    [/span>version1.12version
dependency

[/span>dependency
    [/span>groupIdcom.aliyun.ossgroupId
    [/span>artifactIdaliyun-sdk-ossartifactId
    [/span>version3.16.1version
dependency

spring:
  datasource:
    online:
      jdbc-url: jdbc:mysql://db-online:3306/app?useSSL=false
      username: app
      password: ***
    backup:
      jdbc-url: jdbc:mysql://db-backup:3306/app?useSSL=false
      username: backup
      password: ***

@Component
@RequiredArgsConstructor
public class FullBackupTask implements CommandLineRunner {
    private final MeterRegistry registry;
    private final OssClient ossClient;

    @Override
    public void run(String... args) throws Exception {
        String fileName = "backup_full_" + LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyyMMddHHmmss")) + ".sql";
        long start = System.currentTimeMillis();
        new ProcessExecutor()
            .command("mysqldump", "-h", "db-backup", "-u", "backup", "-p***", "app")
            .redirectOutput(new File("/tmp/" + fileName))
            .execute();
        ossClient.upload(fileName, new File("/tmp/" + fileName));
        registry.timer("backup.full").record(System.currentTimeMillis() - start, TimeUnit.MILLISECONDS);
    }
}

@Configuration
@EnableScheduling
public class ScheduleConfig {
    @Scheduled(cron = "0 0 2 * * ?")
    public void fullBackup() {
        SpringApplication.run(FullBackupTask.class, "--spring.profiles.active=backup");
    }
}

@RestController
@RequiredArgsConstructor
public class RollbackController {
    private final RollbackService rollbackService;

    @PostMapping("/rollback")
    public String rollback(@RequestParam String date, @RequestParam String db) {
        return rollbackService.rollback(date, db);
    }
}

# 启动备份服务
./mvnw spring-boot:run -Dspring-boot.run.profiles=backup
# 模拟回滚
curl -X POST http://localhost:8080/rollback?date=20250831&db=trade