devbox
菜鸟追梦旅行
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

apache-dolphinscheduler-3.2.0 单机启动及改为mysql存储_dolphinscheduler 数据库迁移到 mysql

作者：菜鸟追梦旅行 | 2024-03-06 02:13:51

赞

踩

dolphinscheduler 数据库迁移到 mysql

一、apache-dolphinscheduler介绍

Apache DolphinScheduler 是一个分布式的开源调度系统，它提供了一种可视化、可扩展、高可用的任务调度和数据处理方案。

二、apache-dolphinscheduler配置

2.1、下载apache-dolphinscheduler

https://dolphinscheduler.apache.org/en-us/download/3.2.0

apache-dolphinscheduler-3.2.0

2.2、H2配置文件

  1. spring:
  2.   jackson:
  3.     time-zone: UTC
  4.     date-format: "yyyy-MM-dd HH:mm:ss"
  5.   banner:
  6.     charset: UTF-8
  7.   cache:
  8.     # default enable cache, you can disable by `type: none`
  9.     type: none
  10.     cache-names:
  11.       - tenant
  12.       - user
  13.       - processDefinition
  14.       - processTaskRelation
  15.       - taskDefinition
  16.     caffeine:
  17.       spec: maximumSize=100,expireAfterWrite=300s,recordStats
  18.   sql:
  19.     init:
  20.       schema-locations: classpath:sql/dolphinscheduler_h2.sql
  21.   datasource:
  22.     driver-class-name: org.h2.Driver
  23.     url: jdbc:h2:mem:dolphinscheduler;MODE=MySQL;DB_CLOSE_DELAY=-1;DATABASE_TO_LOWER=true
  24.     username: sa
  25.     password: ""
  26.  
  27.  
  28.   quartz:
  29.     job-store-type: jdbc
  30.     jdbc:
  31.       initialize-schema: never
  32.     properties:
  33.       org.quartz.threadPool.threadPriority: 5
  34.       org.quartz.jobStore.isClustered: true
  35.       org.quartz.jobStore.class: org.springframework.scheduling.quartz.LocalDataSourceJobStore
  36.       org.quartz.scheduler.instanceId: AUTO
  37.       org.quartz.jobStore.tablePrefix: QRTZ_
  38.       org.quartz.jobStore.acquireTriggersWithinLock: true
  39.       org.quartz.scheduler.instanceName: DolphinScheduler
  40.       org.quartz.threadPool.class: org.quartz.simpl.SimpleThreadPool
  41.       org.quartz.jobStore.useProperties: false
  42.       org.quartz.threadPool.makeThreadsDaemons: true
  43.       org.quartz.threadPool.threadCount: 25
  44.       org.quartz.jobStore.misfireThreshold: 60000
  45.       org.quartz.scheduler.makeSchedulerThreadDaemon: true
  46.       org.quartz.jobStore.driverDelegateClass: org.quartz.impl.jdbcjobstore.StdJDBCDelegate
  47.       org.quartz.jobStore.clusterCheckinInterval: 5000
  48.       org.quartz.scheduler.batchTriggerAcquisitionMaxCount: 1
  49.   servlet:
  50.     multipart:
  51.       max-file-size: 1024MB
  52.       max-request-size: 1024MB
  53.   messages:
  54.     basename: i18n/messages
  55.   jpa:
  56.     hibernate:
  57.       ddl-auto: none
  58.   mvc:
  59.     pathmatch:
  60.       matching-strategy: ANT_PATH_MATCHER
  61.  
  62. registry:
  63.   type: zookeeper
  64.   zookeeper:
  65.     namespace: dolphinscheduler
  66.     connect-string: localhost:2181
  67.     retry-policy:
  68.       base-sleep-time: 60ms
  69.       max-sleep: 300ms
  70.       max-retries: 5
  71.     session-timeout: 30s
  72.     connection-timeout: 9s
  73.     block-until-connected: 600ms
  74.     digest: ~
  75.  
  76. security:
  77.   authentication:
  78.     # Authentication types (supported types: PASSWORD,LDAP,CASDOOR_SSO)
  79.     type: PASSWORD
  80.     # IF you set type `LDAP`, below config will be effective
  81.     ldap:
  82.       # ldap server config
  83.       urls: ldap://ldap.forumsys.com:389/
  84.       base-dn: dc=example,dc=com
  85.       username: cn=read-only-admin,dc=example,dc=com
  86.       password: password
  87.       user:
  88.         # admin userId when you use LDAP login
  89.         admin: read-only-admin
  90.         identity-attribute: uid
  91.         email-attribute: mail
  92.         # action when ldap user is not exist (supported types: CREATE,DENY)
  93.         not-exist-action: CREATE
  94.       ssl:
  95.         enable: false
  96.         # jks file absolute path && password
  97.         trust-store: "/ldapkeystore.jks"
  98.         trust-store-password: ""
  99.     casdoor:
  100.       user:
  101.         admin: admin
  102.     oauth2:
  103.       enable: false
  104.       provider:
  105.         github:
  106.           authorizationUri: "https://github.com/login/oauth/authorize"
  107.           redirectUri: "http://localhost:12345/dolphinscheduler/redirect/login/oauth2"
  108.           clientId: ""
  109.           clientSecret: ""
  110.           tokenUri: "https://github.com/login/oauth/access_token"
  111.           userInfoUri: "https://api.github.com/user"
  112.           callbackUrl: "http://localhost:5173/login"
  113.           iconUri: ""
  114.           provider: github
  115.         gitee:
  116.           authorizationUri: "https://gitee.com/oauth/authorize"
  117.           redirectUri: "http://127.0.0.1:12345/dolphinscheduler/redirect/login/oauth2"
  118.           clientId: ""
  119.           clientSecret: ""
  120.           tokenUri: "https://gitee.com/oauth/token?grant_type=authorization_code"
  121.           userInfoUri: "https://gitee.com/api/v5/user"
  122.           callbackUrl: "http://127.0.0.1:5173/login"
  123.           iconUri: ""
  124.           provider: gitee
  125.  
  126. casdoor:
  127.   # Your Casdoor server url
  128.   endpoint: http://localhost:8000
  129.   client-id: ""
  130.   client-secret: ""
  131.   # The certificate may be multi-line, you can use `|-` for ease
  132.   certificate: ""
  133.   # Your organization name added in Casdoor
  134.   organization-name: built-in
  135.   # Your application name added in Casdoor
  136.   application-name: dolphinscheduler
  137.   # Doplhinscheduler login url
  138.   redirect-url: http://localhost:5173/login
  139.  
  140.  
  141.  
  142. master:
  143.   listen-port: 5678
  144.   # master fetch command num
  145.   fetch-command-num: 10
  146.   # master prepare execute thread number to limit handle commands in parallel
  147.   pre-exec-threads: 10
  148.   # master execute thread number to limit process instances in parallel
  149.   exec-threads: 10
  150.   # master dispatch task number per batch
  151.   dispatch-task-number: 3
  152.   # master host selector to select a suitable worker, default value: LowerWeight. Optional values include random, round_robin, lower_weight
  153.   host-selector: lower_weight
  154.   # master heartbeat interval
  155.   heartbeat-interval: 10s
  156.   # master commit task retry times
  157.   task-commit-retry-times: 5
  158.   # master commit task interval
  159.   task-commit-interval: 1s
  160.   state-wheel-interval: 5s
  161.   # master max cpuload avg percentage, only higher than the system cpu load average, master server can schedule. default value 1: will use 100% cpu
  162.   max-cpu-load-avg: 1
  163.   # master reserved memory, only lower than system available memory, master server can schedule. default value 0.1, only the available memory is higher than 10%, master server can schedule.
  164.   reserved-memory: 0.1
  165.   # failover interval
  166.   failover-interval: 10m
  167.   # kill yarn/k8s application when failover taskInstance, default true
  168.   kill-application-when-task-failover: true
  169.   worker-group-refresh-interval: 10s
  170.  
  171. worker:
  172.   # worker listener port
  173.   listen-port: 1234
  174.   # worker execute thread number to limit task instances in parallel
  175.   exec-threads: 10
  176.   # worker heartbeat interval
  177.   heartbeat-interval: 10s
  178.   # worker host weight to dispatch tasks, default value 100
  179.   host-weight: 100
  180.   # tenant corresponds to the user of the system, which is used by the worker to submit the job. If system does not have this user, it will be automatically created after the parameter worker.tenant.auto.create is true.
  181.   tenant-auto-create: true
  182.   #Scenes to be used for distributed users.For example,users created by FreeIpa are stored in LDAP.This parameter only applies to Linux, When this parameter is true, worker.tenant.auto.create has no effect and will not automatically create tenants.
  183.   tenant-distributed-user: false
  184.   # worker max cpuload avg, only higher than the system cpu load average, worker server can be dispatched tasks. default value 1: will use 100% cpu.
  185.   max-cpu-load-avg: 1
  186.   # worker reserved memory, only lower than system available memory, worker server can be dispatched tasks. default value 0.1, only the available memory is higher than 10%, worker server can receive task.
  187.   reserved-memory: 0.1
  188.   task-execute-threads-full-policy: REJECT
  189.  
  190. alert:
  191.   port: 50052
  192.   # Mark each alert of alert server if late after x milliseconds as failed.
  193.   # Define value is (0 = infinite), and alert server would be waiting alert result.
  194.   wait-timeout: 0
  195.   heartbeat-interval: 60s
  196.  
  197. api:
  198.   audit-enable: false
  199.   # Traffic control, if you turn on this config, the maximum number of request/s will be limited.
  200.   # global max request number per second
  201.   # default tenant-level max request number
  202.   traffic-control:
  203.     global-switch: false
  204.     max-global-qps-rate: 300
  205.     tenant-switch: false
  206.     default-tenant-qps-rate: 10
  207.       #customize-tenant-qps-rate:
  208.     # eg.
  209.     #tenant1: 11
  210.     #tenant2: 20
  211.   python-gateway:
  212.     # Weather enable python gateway server or not. The default value is true.
  213.     enabled: true
  214.     # Authentication token for connection from python api to python gateway server. Should be changed the default value
  215.     # when you deploy in public network.
  216.     auth-token: jwUDzpLsNKEFER4*a8gruBH_GsAurNxU7A@Xc
  217.     # The address of Python gateway server start. Set its value to `0.0.0.0` if your Python API run in different
  218.     # between Python gateway server. It could be be specific to other address like `127.0.0.1` or `localhost`
  219.     gateway-server-address: 0.0.0.0
  220.     # The port of Python gateway server start. Define which port you could connect to Python gateway server from
  221.     # Python API side.
  222.     gateway-server-port: 25333
  223.     # The address of Python callback client.
  224.     python-address: 127.0.0.1
  225.     # The port of Python callback client.
  226.     python-port: 25334
  227.     # Close connection of socket server if no other request accept after x milliseconds. Define value is (0 = infinite),
  228.     # and socket server would never close even though no requests accept
  229.     connect-timeout: 0
  230.     # Close each active connection of socket server if python program not active after x milliseconds. Define value is
  231.     # (0 = infinite), and socket server would never close even though no requests accept
  232.     read-timeout: 0
  233.  
  234. server:
  235.   port: 12345
  236.   servlet:
  237.     session:
  238.       timeout: 120m
  239.     context-path: /dolphinscheduler/
  240.   compression:
  241.     enabled: true
  242.     mime-types: text/html,text/xml,text/plain,text/css,text/javascript,application/javascript,application/json,application/xml
  243.   jetty:
  244.     max-http-form-post-size: 5000000
  245.  
  246. management:
  247.   endpoints:
  248.     web:
  249.       exposure:
  250.         include: health,metrics,prometheus
  251.   endpoint:
  252.     health:
  253.       enabled: true
  254.       show-details: always
  255.   health:
  256.     db:
  257.       enabled: true
  258.     defaults:
  259.       enabled: false
  260.   metrics:
  261.     tags:
  262.       application: ${spring.application.name}
  263.  
  264. metrics:
  265.   enabled: true
  266.  
  267. # Override by profile
  268. ---
  269. spring:
  270.   config:
  271.     activate:
  272.       on-profile: postgresql
  273.   quartz:
  274.     properties:
  275.       org.quartz.jobStore.driverDelegateClass: org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
  276.   datasource:
  277.     driver-class-name: org.postgresql.Driver
  278.     url: jdbc:postgresql://127.0.0.1:5432/dolphinscheduler
  279.     username: root
  280.     password: root
  281.  
  282. ---
  283. spring:
  284.   config:
  285.     activate:
  286.       on-profile: mysql
  287.   sql:
  288.      init:
  289.        schema-locations: classpath:sql/dolphinscheduler_mysql.sql
  290.   datasource:
  291.     driver-class-name: com.mysql.cj.jdbc.Driver
  292.     url: jdbc:mysql://127.0.0.1:3306/dolphinscheduler?useUnicode=true&characterEncoding=UTF-8
  293.     username: root
  294.     password: root

2.2、mysql的配置

  1. spring:
  2.   jackson:
  3.     time-zone: UTC
  4.     date-format: "yyyy-MM-dd HH:mm:ss"
  5.   banner:
  6.     charset: UTF-8
  7.   cache:
  8.     # default enable cache, you can disable by `type: none`
  9.     type: none
  10.     cache-names:
  11.       - tenant
  12.       - user
  13.       - processDefinition
  14.       - processTaskRelation
  15.       - taskDefinition
  16.     caffeine:
  17.       spec: maximumSize=100,expireAfterWrite=300s,recordStats
  18.   sql:
  19.     init:
  20.       schema-locations: classpath:sql/dolphinscheduler_h2.sql
  21.   datasource:
  22.     #driver-class-name: org.h2.Driver
  23.     #url: jdbc:h2:mem:dolphinscheduler;MODE=MySQL;DB_CLOSE_DELAY=-1;DATABASE_TO_LOWER=true
  24.     #username: sa
  25.     #password: ""
  26.     driver-class-name: com.mysql.cj.jdbc.Driver
  27.     url: jdbc:h2:mem:dolphinscheduler;MODE=MySQL;DB_CLOSE_DELAY=-1;DATABASE_TO_LOWER=true
  28.     username: root
  29.     password: 123456
  30.  
  31.  
  32.   quartz:
  33.     job-store-type: jdbc
  34.     jdbc:
  35.       initialize-schema: never
  36.     properties:
  37.       org.quartz.threadPool.threadPriority: 5
  38.       org.quartz.jobStore.isClustered: true
  39.       org.quartz.jobStore.class: org.springframework.scheduling.quartz.LocalDataSourceJobStore
  40.       org.quartz.scheduler.instanceId: AUTO
  41.       org.quartz.jobStore.tablePrefix: QRTZ_
  42.       org.quartz.jobStore.acquireTriggersWithinLock: true
  43.       org.quartz.scheduler.instanceName: DolphinScheduler
  44.       org.quartz.threadPool.class: org.quartz.simpl.SimpleThreadPool
  45.       org.quartz.jobStore.useProperties: false
  46.       org.quartz.threadPool.makeThreadsDaemons: true
  47.       org.quartz.threadPool.threadCount: 25
  48.       org.quartz.jobStore.misfireThreshold: 60000
  49.       org.quartz.scheduler.makeSchedulerThreadDaemon: true
  50.       org.quartz.jobStore.driverDelegateClass: org.quartz.impl.jdbcjobstore.StdJDBCDelegate
  51.       org.quartz.jobStore.clusterCheckinInterval: 5000
  52.       org.quartz.scheduler.batchTriggerAcquisitionMaxCount: 1
  53.   servlet:
  54.     multipart:
  55.       max-file-size: 1024MB
  56.       max-request-size: 1024MB
  57.   messages:
  58.     basename: i18n/messages
  59.   jpa:
  60.     hibernate:
  61.       ddl-auto: none
  62.   mvc:
  63.     pathmatch:
  64.       matching-strategy: ANT_PATH_MATCHER
  65.  
  66. registry:
  67.   type: zookeeper
  68.   zookeeper:
  69.     namespace: dolphinscheduler
  70.     connect-string: localhost:2181
  71.     retry-policy:
  72.       base-sleep-time: 60ms
  73.       max-sleep: 300ms
  74.       max-retries: 5
  75.     session-timeout: 30s
  76.     connection-timeout: 9s
  77.     block-until-connected: 600ms
  78.     digest: ~
  79.  
  80. security:
  81.   authentication:
  82.     # Authentication types (supported types: PASSWORD,LDAP,CASDOOR_SSO)
  83.     type: PASSWORD
  84.     # IF you set type `LDAP`, below config will be effective
  85.     ldap:
  86.       # ldap server config
  87.       urls: ldap://ldap.forumsys.com:389/
  88.       base-dn: dc=example,dc=com
  89.       username: cn=read-only-admin,dc=example,dc=com
  90.       password: password
  91.       user:
  92.         # admin userId when you use LDAP login
  93.         admin: read-only-admin
  94.         identity-attribute: uid
  95.         email-attribute: mail
  96.         # action when ldap user is not exist (supported types: CREATE,DENY)
  97.         not-exist-action: CREATE
  98.       ssl:
  99.         enable: false
  100.         # jks file absolute path && password
  101.         trust-store: "/ldapkeystore.jks"
  102.         trust-store-password: ""
  103.     casdoor:
  104.       user:
  105.         admin: admin
  106.     oauth2:
  107.       enable: false
  108.       provider:
  109.         github:
  110.           authorizationUri: "https://github.com/login/oauth/authorize"
  111.           redirectUri: "http://localhost:12345/dolphinscheduler/redirect/login/oauth2"
  112.           clientId: ""
  113.           clientSecret: ""
  114.           tokenUri: "https://github.com/login/oauth/access_token"
  115.           userInfoUri: "https://api.github.com/user"
  116.           callbackUrl: "http://localhost:5173/login"
  117.           iconUri: ""
  118.           provider: github
  119.         gitee:
  120.           authorizationUri: "https://gitee.com/oauth/authorize"
  121.           redirectUri: "http://127.0.0.1:12345/dolphinscheduler/redirect/login/oauth2"
  122.           clientId: ""
  123.           clientSecret: ""
  124.           tokenUri: "https://gitee.com/oauth/token?grant_type=authorization_code"
  125.           userInfoUri: "https://gitee.com/api/v5/user"
  126.           callbackUrl: "http://127.0.0.1:5173/login"
  127.           iconUri: ""
  128.           provider: gitee
  129.  
  130. casdoor:
  131.   # Your Casdoor server url
  132.   endpoint: http://localhost:8000
  133.   client-id: ""
  134.   client-secret: ""
  135.   # The certificate may be multi-line, you can use `|-` for ease
  136.   certificate: ""
  137.   # Your organization name added in Casdoor
  138.   organization-name: built-in
  139.   # Your application name added in Casdoor
  140.   application-name: dolphinscheduler
  141.   # Doplhinscheduler login url
  142.   redirect-url: http://localhost:5173/login
  143.  
  144.  
  145.  
  146. master:
  147.   listen-port: 5678
  148.   # master fetch command num
  149.   fetch-command-num: 10
  150.   # master prepare execute thread number to limit handle commands in parallel
  151.   pre-exec-threads: 10
  152.   # master execute thread number to limit process instances in parallel
  153.   exec-threads: 10
  154.   # master dispatch task number per batch
  155.   dispatch-task-number: 3
  156.   # master host selector to select a suitable worker, default value: LowerWeight. Optional values include random, round_robin, lower_weight
  157.   host-selector: lower_weight
  158.   # master heartbeat interval
  159.   heartbeat-interval: 10s
  160.   # master commit task retry times
  161.   task-commit-retry-times: 5
  162.   # master commit task interval
  163.   task-commit-interval: 1s
  164.   state-wheel-interval: 5s
  165.   # master max cpuload avg percentage, only higher than the system cpu load average, master server can schedule. default value 1: will use 100% cpu
  166.   max-cpu-load-avg: 1
  167.   # master reserved memory, only lower than system available memory, master server can schedule. default value 0.1, only the available memory is higher than 10%, master server can schedule.
  168.   reserved-memory: 0.1
  169.   # failover interval
  170.   failover-interval: 10m
  171.   # kill yarn/k8s application when failover taskInstance, default true
  172.   kill-application-when-task-failover: true
  173.   worker-group-refresh-interval: 10s
  174.  
  175. worker:
  176.   # worker listener port
  177.   listen-port: 1234
  178.   # worker execute thread number to limit task instances in parallel
  179.   exec-threads: 10
  180.   # worker heartbeat interval
  181.   heartbeat-interval: 10s
  182.   # worker host weight to dispatch tasks, default value 100
  183.   host-weight: 100
  184.   # tenant corresponds to the user of the system, which is used by the worker to submit the job. If system does not have this user, it will be automatically created after the parameter worker.tenant.auto.create is true.
  185.   tenant-auto-create: true
  186.   #Scenes to be used for distributed users.For example,users created by FreeIpa are stored in LDAP.This parameter only applies to Linux, When this parameter is true, worker.tenant.auto.create has no effect and will not automatically create tenants.
  187.   tenant-distributed-user: false
  188.   # worker max cpuload avg, only higher than the system cpu load average, worker server can be dispatched tasks. default value 1: will use 100% cpu.
  189.   max-cpu-load-avg: 1
  190.   # worker reserved memory, only lower than system available memory, worker server can be dispatched tasks. default value 0.1, only the available memory is higher than 10%, worker server can receive task.
  191.   reserved-memory: 0.1
  192.   task-execute-threads-full-policy: REJECT
  193.  
  194. alert:
  195.   port: 50052
  196.   # Mark each alert of alert server if late after x milliseconds as failed.
  197.   # Define value is (0 = infinite), and alert server would be waiting alert result.
  198.   wait-timeout: 0
  199.   heartbeat-interval: 60s
  200.  
  201. api:
  202.   audit-enable: false
  203.   # Traffic control, if you turn on this config, the maximum number of request/s will be limited.
  204.   # global max request number per second
  205.   # default tenant-level max request number
  206.   traffic-control:
  207.     global-switch: false
  208.     max-global-qps-rate: 300
  209.     tenant-switch: false
  210.     default-tenant-qps-rate: 10
  211.       #customize-tenant-qps-rate:
  212.     # eg.
  213.     #tenant1: 11
  214.     #tenant2: 20
  215.   python-gateway:
  216.     # Weather enable python gateway server or not. The default value is true.
  217.     enabled: true
  218.     # Authentication token for connection from python api to python gateway server. Should be changed the default value
  219.     # when you deploy in public network.
  220.     auth-token: jwUDzpLsNKEFER4*a8gruBH_GsAurNxU7A@Xc
  221.     # The address of Python gateway server start. Set its value to `0.0.0.0` if your Python API run in different
  222.     # between Python gateway server. It could be be specific to other address like `127.0.0.1` or `localhost`
  223.     gateway-server-address: 0.0.0.0
  224.     # The port of Python gateway server start. Define which port you could connect to Python gateway server from
  225.     # Python API side.
  226.     gateway-server-port: 25333
  227.     # The address of Python callback client.
  228.     python-address: 127.0.0.1
  229.     # The port of Python callback client.
  230.     python-port: 25334
  231.     # Close connection of socket server if no other request accept after x milliseconds. Define value is (0 = infinite),
  232.     # and socket server would never close even though no requests accept
  233.     connect-timeout: 0
  234.     # Close each active connection of socket server if python program not active after x milliseconds. Define value is
  235.     # (0 = infinite), and socket server would never close even though no requests accept
  236.     read-timeout: 0
  237.  
  238. server:
  239.   port: 12345
  240.   servlet:
  241.     session:
  242.       timeout: 120m
  243.     context-path: /dolphinscheduler/
  244.   compression:
  245.     enabled: true
  246.     mime-types: text/html,text/xml,text/plain,text/css,text/javascript,application/javascript,application/json,application/xml
  247.   jetty:
  248.     max-http-form-post-size: 5000000
  249.  
  250. management:
  251.   endpoints:
  252.     web:
  253.       exposure:
  254.         include: health,metrics,prometheus
  255.   endpoint:
  256.     health:
  257.       enabled: true
  258.       show-details: always
  259.   health:
  260.     db:
  261.       enabled: true
  262.     defaults:
  263.       enabled: false
  264.   metrics:
  265.     tags:
  266.       application: ${spring.application.name}
  267.  
  268. metrics:
  269.   enabled: true
  270.  
  271. # Override by profile
  272. ---
  273. spring:
  274.   config:
  275.     activate:
  276.       on-profile: postgresql
  277.   quartz:
  278.     properties:
  279.       org.quartz.jobStore.driverDelegateClass: org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
  280.   datasource:
  281.     driver-class-name: org.postgresql.Driver
  282.     url: jdbc:postgresql://127.0.0.1:5432/dolphinscheduler
  283.     username: root
  284.     password: root
  285.  
  286. ---
  287. spring:
  288.   config:
  289.     activate:
  290.       on-profile: mysql
  291.   sql:
  292.      init:
  293.        schema-locations: classpath:sql/dolphinscheduler_mysql.sql
  294.   datasource:
  295.     driver-class-name: com.mysql.cj.jdbc.Driver
  296.     url: jdbc:mysql://127.0.0.1:3306/dolphinscheduler?useUnicode=true&characterEncoding=UTF-8
  297.     username: root
  298.     password: root

2.3、dolphinscheduler_env.sh配置

  1. export JAVA_HOME=${JAVA_HOME:-/usr/local/jdk1.8.0_391}
  2. export REGISTRY_ZOOKEEPER_CONNECT_STRING=${REGISTRY_ZOOKEEPER_CONNECT_STRING:-node4:2181}
  3. export DATABASE=${DATABASE:-mysql}
  4. export SPRING_PROFILES_ACTIVE=${DATABASE}
  5. export SPRING_DATASOURCE_URL="jdbc:mysql://192.168.1.103:3306/dolphinscheduler?useUnicode=true&characterEncoding=UTF-8&useSSL=false&allowPublicKeyRetrieval=true"
  6. export SPRING_DATASOURCE_USERNAME=root
  7. export SPRING_DATASOURCE_PASSWORD=123456

三、dolphinscheduler操作

3.1、启动dolphinscheduler

 ./dolphinscheduler-daemon.sh start standalone-server

默认是采用H2的内存数据库，所以任务不能创建太多。

3.2、查看dolphinscheduler状态

  1. [root@node4 bin]# ./dolphinscheduler-daemon.sh status standalone-server
  2. Begin status standalone-server......
  3. standalone-server  [  RUNNING  ]
  4. End status standalone-server.

3.3、停止dolphinscheduler

 ./dolphinscheduler-daemon.sh stop standalone-server

3.4、查看dolphinscheduler进程

  1. [root@node4 bin]# jps
  2. 36069 Jps
  3. 35849 StandaloneServer

3.5、访问dolphinscheduler

http://192.168.42.142:12345/dolphinscheduler/ui
默认登录用户名/密码:admin/dolphinscheduler123

3.6、访问界面

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/菜鸟追梦旅行/article/detail/195517
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号