单机-DolphinScheduler部署-mysql （二）

#创建目录

mkdir -p /data/dolphinscheduler/{dolphin-worker-data,logs,soft,resource,libs}

#挂载程序目录 /home/dev

mkdir -p /home/dev

chmod 777 /home/dev*

volumes: - /data/dolphinscheduler/dolphin-worker-data:/tmp/dolphinscheduler - /data/dolphinscheduler/logs:/opt/dolphinscheduler/logs - /data/dolphinscheduler/soft:/opt/soft - /data/dolphinscheduler/resource:/dolphinscheduler - /data/dolphinscheduler/libs/mysql-connector-java-8.0.29.jar:/opt/dolphinscheduler/libs/mysql-connector-java-8.0.29.jar - /home/dev:/home/dev

#复制Mysql驱动到libs目录

libs/mysql-connector-java-8.0.29.jar

#环境变量

- "DATABASE=mysql" - "SPRING_PROFILES_ACTIVE=${DATABASE}" - "SPRING_DATASOURCE_URL=jdbc:mysql://192.168.10.14:3306/dolphinscheduler" - "SPRING_DATASOURCE_USERNAME=root" - "SPRING_DATASOURCE_PASSWORD=MFf80FDMp" - "REGISTRY_ZOOKEEPER_CONNECT_STRING=zk01:2181"

#数据库初始化，参考 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="mysql"

-e SPRING_DATASOURCE_URL="jdbc:mysql://node1:3306/dolphinscheduler"

-e SPRING_DATASOURCE_USERNAME="root"

-e SPRING_DATASOURCE_PASSWORD="MFf80FDMp"

--net host

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