单机-DolphinScheduler部署-PSQL (二）

#config.env.sh

DATABASE_TYPE=mysqlDATABASE_DRIVER=com.mysql.jdbc.DriverDATABASE_HOST=dolphinscheduler-mysqlDATABASE_PORT=3306DATABASE_USERNAME=rootDATABASE_PASSWORD=rootDATABASE_DATABASE=dolphinschedulerDATABASE_PARAMS=useUnicode=true&characterEncoding=UTF-8

#数据库初始化，参考 https://github.com/apache/dolphinscheduler/blob/3.1.3-release/docs/docs/zh/guide/howto/datasource-setting.md

mysql -uroot -pMFf80FDMp -h192.168.10.14

CREATE DATABASE dolphinscheduler DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

CREATE USER 'dolphinscheduler'@'%' IDENTIFIED BY 'dolphinscheduler';

CREATE USER 'dolphinscheduler'@'localhost' IDENTIFIED BY 'dolphinscheduler';

GRANT ALL PRIVILEGES ON dolphinscheduler.* TO 'dolphinscheduler'@'%';

GRANT ALL PRIVILEGES ON dolphinscheduler.* TO 'dolphinscheduler'@'localhost';

flush privileges;

#初始化数据库

docker run -d --name dolphinscheduler-tools

-e DATABASE="postgresql"

-e SPRING_DATASOURCE_URL="jdbc:postgresql://node1:5432/dolphinscheduler"

-e SPRING_DATASOURCE_USERNAME="user01"

-e SPRING_DATASOURCE_PASSWORD="user2023"

--net host

apache/dolphinscheduler-tools:3.1.4 tools/bin/upgrade-schema.sh

#docker-compose.yaml

version: "3.8"services: dolphinscheduler-master: image: apache/dolphinscheduler-master:3.1.4 environment: - "DATABASE=postgresql" - "SPRING_DATASOURCE_URL=jdbc:postgresql://postgresql:5432/dolphinscheduler" - "SPRING_DATASOURCE_USERNAME=user01" - "SPRING_DATASOURCE_PASSWORD=user2023" - "REGISTRY_ZOOKEEPER_CONNECT_STRING=zk01:2181"# env_file: .env# healthcheck:# test: [ "CMD", "curl", "http://localhost:50053/actuator/health" ]# interval: 30s# timeout: 5s# retries: 3 volumes: - /data/dolphinscheduler/dolphin-worker-data:/tmp/dolphinscheduler - /data/dolphinscheduler/logs:/opt/dolphinscheduler/logs - /data/dolphinscheduler/soft:/opt/soft - /data/dolphinscheduler/resource:/dolphinscheduler networks: - meta deploy: mode: replicated replicas: 1 placement: constraints: [node.labels.dolphin-node == dolphin01]# resources:# limits:# cpus: '0.1'# memory: 786M# reservations:# cpus: '0.1'# memory: 786M dolphinscheduler-api: image: apache/dolphinscheduler-api:3.1.4 ports: - 12345:12345 - 25333:25333 environment: - "DATABASE=postgresql" - "SPRING_DATASOURCE_URL=jdbc:postgresql://postgresql:5432/dolphinscheduler" - "SPRING_DATASOURCE_USERNAME=user01" - "SPRING_DATASOURCE_PASSWORD=user2023" - "REGISTRY_ZOOKEEPER_CONNECT_STRING=zk01:2181" volumes: - /data/dolphinscheduler/dolphin-worker-data:/tmp/dolphinscheduler - /data/dolphinscheduler/logs:/opt/dolphinscheduler/logs - /data/dolphinscheduler/soft:/opt/soft - /data/dolphinscheduler/resource:/dolphinscheduler networks: - meta deploy: mode: replicated replicas: 1 placement: constraints: [node.labels.dolphin-node == dolphin01] dolphinscheduler-alert: image: apache/dolphinscheduler-alert-server:3.1.4 environment: - "DATABASE=postgresql" - "SPRING_DATASOURCE_URL=jdbc:postgresql://postgresql:5432/dolphinscheduler" - "SPRING_DATASOURCE_USERNAME=user01" - "SPRING_DATASOURCE_PASSWORD=user2023" - "REGISTRY_ZOOKEEPER_CONNECT_STRING=zk01:2181" volumes: - /data/dolphinscheduler/dolphin-worker-data:/tmp/dolphinscheduler - /data/dolphinscheduler/logs:/opt/dolphinscheduler/logs - /data/dolphinscheduler/soft:/opt/soft - /data/dolphinscheduler/resource:/dolphinscheduler networks: - meta deploy: mode: replicated replicas: 1 placement: constraints: [node.labels.dolphin-node == dolphin02] dolphinscheduler-worker: image: apache/dolphinscheduler-worker:3.1.4 environment: - "DATABASE=postgresql" - "SPRING_DATASOURCE_URL=jdbc:postgresql://postgresql:5432/dolphinscheduler" - "SPRING_DATASOURCE_USERNAME=user01" - "SPRING_DATASOURCE_PASSWORD=user2023" - "REGISTRY_ZOOKEEPER_CONNECT_STRING=zk01:2181" volumes: - /data/dolphinscheduler/dolphin-worker-data:/tmp/dolphinscheduler - /data/dolphinscheduler/logs:/opt/dolphinscheduler/logs - /data/dolphinscheduler/soft:/opt/soft - /data/dolphinscheduler/resource:/dolphinscheduler networks: - meta deploy: mode: replicated replicas: 1 placement: constraints: [node.labels.dolphin-node == dolphin03]networks: meta: external: true

#启动服务

docker stack deploy -c docker-compose.yaml dolphin

#停止并删除服务

docker stack rm dolphin

#部署好API server后访问

http://192.168.10.13:12345/dolphinscheduler

初始用户的用户名为：admin，密码为 dolphinscheduler123