Configuring Quartz scheduler with Galera Cluster database.
How is Quartz scheduler configured in an apache tomcat groovy file to connect to a 3-node Galera Cluster database?
The configuration below is currently been used but Quartz is displaying error messages; Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is not clustered.
Groovy file config;
quartz{ jdbcStore = true autoStartup = false
props { waitForJobsToCompleteOnShutdown = true jobStore.class = 'org.quartz.impl.jdbcjobstore.JobStoreTX' threadPool.threadCount = 5
scheduler.instanceId=AUTO
jobStore.isClustered = true jobStore.clusterCheckinInterval = 20000
} }
Answer Answered by Dermot Brereton in this comment.
This issue has now been resolved. It was related to the presence of MyISAM tables in the Galera Cluster database not been synched.
The MyISAM tables were replaced with InnoDB tables.
