如何在Spring Boot中配置多个JDBC集群化Quartz调度器？

可以在application.yaml中配置多个Quartz调度器的基础属性，但Spring Boot并未提供多调度器的自动配置支持，需要结合自定义配置类来实例化每个独立的调度器。

1. YAML配置示例 #

给每个调度器的属性添加独立前缀（比如quartz-first、quartz-second），区分不同调度器的配置：

spring:
  application.name: myApp

# 第一个集群化Quartz调度器
quartz-first:
  properties:
    org:
      quartz:
        scheduler:
          instanceName: FirstClusterScheduler
          instanceId: AUTO
        threadPool:
          threadCount: 5
        plugin:
          shutdownhook:
            class: org.quartz.plugins.management.ShutdownHookPlugin
            cleanShutdown: TRUE
        jobStore:
          class: org.quartz.impl.jdbcjobstore.JobStoreTX
          driverDelegateClass: org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
          tablePrefix: my_schema_first.
          isClustered: true
          dataSource: firstDataSource
        dataSource:
          firstDataSource:
            driver: org.postgresql.Driver
            URL: jdbc:postgresql://localhost/first_quartz_db
            user: removed
            password: removed

# 第二个集群化Quartz调度器
quartz-second:
  properties:
    org:
      quartz:
        scheduler:
          instanceName: SecondClusterScheduler
          instanceId: AUTO
        threadPool:
          threadCount: 3
        plugin:
          shutdownhook:
            class: org.quartz.plugins.management.ShutdownHookPlugin
            cleanShutdown: TRUE
        jobStore:
          class: org.quartz.impl.jdbcjobstore.JobStoreTX
          driverDelegateClass: org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
          tablePrefix: my_schema_second.
          isClustered: true
          dataSource: secondDataSource
        dataSource:
          secondDataSource:
            driver: org.postgresql.Driver
            URL: jdbc:postgresql://localhost/second_quartz_db
            user: removed
            password: removed

2. 自定义配置类实例化调度器 #

通过@ConfigurationProperties读取YAML中的对应属性，创建独立的Scheduler实例：

import org.quartz.Scheduler;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.scheduling.quartz.SchedulerFactoryBean;

import java.util.Properties;

@Configuration
public class MultipleQuartzConfig {

    // 读取第一个调度器的配置属性
    @Bean
    @ConfigurationProperties(prefix = "quartz-first.properties")
    public Properties firstQuartzProps() {
        return new Properties();
    }

    @Bean(name = "firstClusterScheduler")
    public Scheduler firstScheduler() throws Exception {
        SchedulerFactoryBean factoryBean = new SchedulerFactoryBean();
        factoryBean.setQuartzProperties(firstQuartzProps());
        factoryBean.afterPropertiesSet();
        return factoryBean.getScheduler();
    }

    // 读取第二个调度器的配置属性
    @Bean
    @ConfigurationProperties(prefix = "quartz-second.properties")
    public Properties secondQuartzProps() {
        return new Properties();
    }

    @Bean(name = "secondClusterScheduler")
    public Scheduler secondScheduler() throws Exception {
        SchedulerFactoryBean factoryBean = new SchedulerFactoryBean();
        factoryBean.setQuartzProperties(secondQuartzProps());
        factoryBean.afterPropertiesSet();
        return factoryBean.getScheduler();
    }
}

3. 关键注意事项 #

• 每个调度器必须配置唯一的instanceName，避免集群内实例识别冲突
• JDBC存储场景下，建议使用独立的表前缀（tablePrefix）或单独的数据库/schema，防止不同调度器的任务、触发器数据互相干扰
• 集群模式下instanceId设为AUTO即可，Quartz会自动生成唯一实例ID
• 使用调度器时，通过@Qualifier指定具体实例，比如：

  @Autowired
  @Qualifier("firstClusterScheduler")
  private Scheduler firstScheduler;
  

内容的提问来源于stack exchange，提问作者nk_melb