{"id":2983,"date":"2026-06-18T08:41:49","date_gmt":"2026-06-18T08:41:49","guid":{"rendered":"https:\/\/tucumandevelopers.com\/index.php\/2026\/06\/18\/deploying-apache-dolphinscheduler-3-1-9-cluster-with-mysql-instead-of-postgresql-a-practical-docker-compose-guide\/"},"modified":"2026-06-18T08:41:49","modified_gmt":"2026-06-18T08:41:49","slug":"deploying-apache-dolphinscheduler-3-1-9-cluster-with-mysql-instead-of-postgresql-a-practical-docker-compose-guide","status":"publish","type":"post","link":"https:\/\/tucumandevelopers.com\/index.php\/2026\/06\/18\/deploying-apache-dolphinscheduler-3-1-9-cluster-with-mysql-instead-of-postgresql-a-practical-docker-compose-guide\/","title":{"rendered":"Deploying Apache DolphinScheduler 3.1.9 Cluster with MySQL Instead of PostgreSQL? A Practical Docker Compose Guide"},"content":{"rendered":"
\n
<\/div>\n

<\/a> Download the MySQL JDBC Driver <\/h2>\n
\n
wget https:\/\/downloads.mysql.com\/archives\/get\/p\/3\/file\/mysql-connector-j-8.0.33.zip unzip -q<\/span> mysql-connector-j-8.0.33.zip cp <\/span>mysql-connector-j-8.0.33\/mysql-connector-j-8.0.33.jar .<\/span> <\/code><\/pre>\n
\n<\/p><\/div>\n<\/p><\/div>\n
  <\/a> Prepare Custom Images <\/h2>\n
  <\/a> Dockerfile for Master, Worker, API, and Alert Server <\/h3>\n
\n
# Based on the official DolphinScheduler image<\/span> ARG<\/span> SERVICE=api<\/span> FROM<\/span> apache\/dolphinscheduler-${SERVICE}:3.1.9<\/span> # Copy the MySQL JDBC driver into the DolphinScheduler library directory<\/span> # DolphinScheduler loads JDBC drivers from the lib directory<\/span> COPY<\/span> mysql-connector-j-8.0.33.jar \/opt\/dolphinscheduler\/libs\/<\/span> <\/code><\/pre>\n
\n<\/p><\/div>\n<\/p><\/div>\n
  <\/a> Dockerfile for Tools <\/h3>\n
\n
# Based on the official DolphinScheduler image<\/span> ARG<\/span> SERVICE=tools<\/span> FROM<\/span> apache\/dolphinscheduler-${SERVICE}:3.1.9<\/span> # Copy the MySQL JDBC driver into the DolphinScheduler tools library directory<\/span> # DolphinScheduler loads JDBC drivers from the lib directory<\/span> COPY<\/span> mysql-connector-j-8.0.33.jar \/opt\/dolphinscheduler\/tools\/libs\/<\/span> <\/code><\/pre>\n
\n<\/p><\/div>\n<\/p><\/div>\n
  <\/a> Build Custom Images <\/h2>\n
\n
docker build --build-arg<\/span> SERVICE<\/span>=<\/span>master -t<\/span> apache\/dolphinscheduler-master:3.1.9-mysql .<\/span> docker build --build-arg<\/span> SERVICE<\/span>=<\/span>worker -t<\/span> apache\/dolphinscheduler-worker:3.1.9-mysql .<\/span> docker build --build-arg<\/span> SERVICE<\/span>=<\/span>tools -t<\/span> apache\/dolphinscheduler-tools:3.1.9-mysql .<\/span> docker build --build-arg<\/span> SERVICE<\/span>=<\/span>api -t<\/span> apache\/dolphinscheduler-api:3.1.9-mysql .<\/span> docker build --build-arg<\/span> SERVICE<\/span>=<\/span>alert-server -t<\/span> apache\/dolphinscheduler-alert-server:3.1.9-mysql .<\/span> <\/code><\/pre>\n
\n<\/p><\/div>\n<\/p><\/div>\n
  <\/a> Update docker-compose.yaml <\/h2>\n
Disable the PostgreSQL service and add a MySQL service as the metadata database. <\/p>\n
\n
# Comment out the PostgreSQL service<\/span> # dolphinscheduler-postgresql:<\/span> # image: bitnami\/postgresql:15.2.0<\/span> # ...<\/span> # MySQL Metadata Database Service<\/span> dolphinscheduler-mysql<\/span>:<\/span> image<\/span>:<\/span> mysql:8.0<\/span> container_name<\/span>:<\/span> dolphinscheduler-mysql<\/span> profiles<\/span>:<\/span> -<\/span> all<\/span> -<\/span> schema<\/span> environment<\/span>:<\/span> MYSQL_ROOT_PASSWORD<\/span>:<\/span> ${MYSQL_ROOT_PASSWORD:-root}<\/span> MYSQL_DATABASE<\/span>:<\/span> ${MYSQL_DATABASE:-dolphinscheduler}<\/span> volumes<\/span>:<\/span> -<\/span> dolphinscheduler-mysql:\/var\/lib\/mysql<\/span> ports<\/span>:<\/span> -<\/span> \"<\/span>3306:3306\"<\/span> # Expose MySQL to allow workers on other servers to connect<\/span> healthcheck<\/span>:<\/span> test<\/span>:<\/span> [<\/span> \"<\/span>CMD\"<\/span>,<\/span> \"<\/span>mysqladmin\"<\/span>,<\/span> \"<\/span>ping\"<\/span>,<\/span> \"<\/span>-h\"<\/span>,<\/span> \"<\/span>localhost\"<\/span>,<\/span> \"<\/span>-u\"<\/span>,<\/span> \"<\/span>${MYSQL_USERNAME:-root}\"<\/span>,<\/span> \"<\/span>-p${MYSQL_PASSWORD:-root}\"<\/span> ]<\/span> interval<\/span>:<\/span> 5s<\/span> timeout<\/span>:<\/span> 60s<\/span> retries<\/span>:<\/span> 120<\/span> networks<\/span>:<\/span> -<\/span> dolphinscheduler<\/span> <\/code><\/pre>\n
\n<\/p><\/div>\n<\/p><\/div>\n
The remaining services (ZooKeeper, Schema Initializer, API, Alert Server, Master, Worker, Network, and Volume configurations) remain the same as the official Docker Compose deployment, with the following key modifications:<\/p>\n
  <\/a> Schema Initializer Dependency <\/h3>\n
\n
depends_on<\/span>:<\/span> dolphinscheduler-mysql<\/span>:<\/span> condition<\/span>:<\/span> service_healthy<\/span> <\/code><\/pre>\n
\n<\/p><\/div>\n<\/p><\/div>\n
  <\/a> Master JVM Configuration <\/h3>\n
\n
environment<\/span>:<\/span> JAVA_OPTS<\/span>:<\/span> ><\/span> -server<\/span> -Duser.timezone=${SPRING_JACKSON_TIME_ZONE}<\/span> -Xms8g<\/span> -Xmx8g<\/span> -Xmn4g<\/span> -XX:+PrintGCDetails<\/span> -Xloggc:gc.log<\/span> -XX:+HeapDumpOnOutOfMemoryError<\/span> -XX:HeapDumpPath=dump.hprof<\/span> <\/code><\/pre>\n
\n<\/p><\/div>\n<\/p><\/div>\n
  <\/a> Worker JVM Configuration <\/h3>\n
\n
environment<\/span>:<\/span> JAVA_OPTS<\/span>:<\/span> ><\/span> -server<\/span> -Duser.timezone=${SPRING_JACKSON_TIME_ZONE}<\/span> -Xms8g<\/span> -Xmx8g<\/span> -Xmn4g<\/span> -XX:+PrintGCDetails<\/span> -Xloggc:gc.log<\/span> -XX:+HeapDumpOnOutOfMemoryError<\/span> -XX:HeapDumpPath=dump.hprof<\/span> <\/code><\/pre>\n
\n<\/p><\/div>\n<\/p><\/div>\n
  <\/a> Volume Configuration <\/h3>\n
\n
volumes<\/span>:<\/span> # Comment out PostgreSQL volume<\/span> # dolphinscheduler-postgresql:<\/span> dolphinscheduler-mysql<\/span>:<\/span> dolphinscheduler-zookeeper<\/span>:<\/span> dolphinscheduler-worker-data<\/span>:<\/span> dolphinscheduler-logs<\/span>:<\/span> dolphinscheduler-shared-local<\/span>:<\/span> <\/code><\/pre>\n
\n<\/p><\/div>\n<\/p><\/div>\n
  <\/a> Update the .env File <\/h2>\n
\n
# Docker Hub Repository and Image Tag <\/span> HUB<\/span>=<\/span>apache<\/span> TAG<\/span>=<\/span>3.1.9<\/span> # MySQL Configuration <\/span> MYSQL_ROOT_PASSWORD<\/span>=<\/span>root<\/span> MYSQL_DATABASE<\/span>=<\/span>dolphinscheduler<\/span> MYSQL_USERNAME<\/span>=<\/span>root<\/span> MYSQL_PASSWORD<\/span>=<\/span>root<\/span> # DolphinScheduler Database Configuration <\/span> TZ<\/span>=<\/span>Asia\/Shanghai<\/span> # Use MySQL as the metadata database <\/span> DATABASE<\/span>=<\/span>mysql<\/span> SPRING_JACKSON_TIME_ZONE<\/span>=<\/span>GMT+8<\/span> SPRING_DATASOURCE_URL<\/span>=<\/span>jdbc:mysql:\/\/dolphinscheduler-mysql:3306\/${MYSQL_DATABASE}?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia\/Shanghai&allowPublicKeyRetrieval=true<\/span> SPRING_DATASOURCE_USERNAME<\/span>=<\/span>${MYSQL_USERNAME}<\/span> SPRING_DATASOURCE_PASSWORD<\/span>=<\/span>${MYSQL_PASSWORD}<\/span> REGISTRY_ZOOKEEPER_CONNECT_STRING<\/span>=<\/span>dolphinscheduler-zookeeper:2181<\/span> MASTER_FETCH_COMMAND_NUM<\/span>=<\/span>10<\/span> <\/code><\/pre>\n
\n<\/p><\/div>\n<\/p><\/div>\n
  <\/a> Initialize the Database <\/h2>\n
\n
docker compose --profile<\/span> schema up -d<\/span> <\/code><\/pre>\n
\n<\/p><\/div>\n<\/p><\/div>\n
  <\/a> Start the Entire Cluster <\/h2>\n
\n
docker compose --profile<\/span> all up -d<\/span> <\/code><\/pre>\n
\n<\/p><\/div>\n<\/p><\/div>\n
  <\/a> Start the Worker Service <\/h2>\n
\n
docker compose up -d<\/span> dolphinscheduler-worker <\/code><\/pre>\n
\n<\/p><\/div>\n<\/p><\/div>\n
  <\/a> Start the Master Service <\/h2>\n
\n
docker compose up -d<\/span> dolphinscheduler-master <\/code><\/pre>\n
\n<\/p><\/div>\n<\/p><\/div>\n
  <\/a> Start the Alert Service <\/h2>\n
\n
docker compose up -d<\/span> dolphinscheduler-alert <\/code><\/pre>\n
\n<\/p><\/div>\n<\/p><\/div>\n
  <\/a> Start the API Service <\/h2>\n
\n
docker compose up -d<\/span> dolphinscheduler-api <\/code><\/pre>\n
\n<\/p><\/div>\n<\/p><\/div>\n
  <\/a> Restart All Services <\/h2>\n
\n
docker compose --profile<\/span> all restart <\/code><\/pre>\n
\n<\/p><\/div>\n<\/p><\/div>\n
  <\/a> Conclusion <\/h2>\n
Although Apache DolphinScheduler officially ships with a PostgreSQL-based Docker Compose deployment, many enterprises continue to standardize on MySQL for operational consistency and ecosystem compatibility.<\/p>\n
By adding the MySQL JDBC driver, rebuilding the DolphinScheduler images, and adjusting the Docker Compose and environment configurations, you can quickly deploy a fully functional Apache DolphinScheduler 3.1.9 cluster powered by MySQL metadata storage.<\/p>\n
This approach enables teams already invested in the MySQL ecosystem to integrate DolphinScheduler into their infrastructure with minimal friction while preserving the benefits of containerized deployment and cluster-based scheduling.<\/p>\n
If your organization relies on MySQL as a strategic database platform, this solution provides a practical and production-friendly path to running Apache DolphinScheduler at scale.<\/p>\n<\/p><\/div>\n<\/div>\n<\/div>\n<\/div>\n
Fuente: Art\u00edculo original<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Download the MySQL JDBC Driver wget https:\/\/downloads.mysql.com\/archives\/get\/p\/3\/file\/mysql-connector-j-8.0.33.zip unzip -q mysql-connector-j-8.0.33.zip cp mysql-connector-j-8.0.33\/mysql-connector-j-8.0.33.jar . Prepare Custom Images Dockerfile for Master, Worker, API, and Alert Server # Based on the official DolphinScheduler image ARG SERVICE=api FROM apache\/dolphinscheduler-${SERVICE}:3.1.9 # Copy the MySQL JDBC driver into the DolphinScheduler library directory # DolphinScheduler loads JDBC drivers from the lib directory […]<\/p>\n","protected":false},"author":1,"featured_media":2982,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[41],"tags":[],"class_list":["post-2983","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-devto"],"jetpack_publicize_connections":[],"_links":{"self":[{"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/posts\/2983","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/comments?post=2983"}],"version-history":[{"count":0,"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/posts\/2983\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/media\/2982"}],"wp:attachment":[{"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/media?parent=2983"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/categories?post=2983"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/tags?post=2983"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}