1 [client]                                        # 客户端设置，即客户端默认的连接参数
 2 port = 3306                                    # 默认连接端口
 3 socket = /home/appuser/mysql/3306/tmp/mysql.sock                        # 用于本地连接的socket套接字，mysqld守护进程生成了这个文件
 4 
 5 
 6 
 7 
 8 [mysqld]                                        # 服务端基本设置
 9 # 基础设置
10 server-id = 1                                  # Mysql服务的唯一编号 每个mysql服务Id需唯一
11 port = 3306                                    # MySQL监听端口
12 basedir = /home/appuser/mysql/mysql                      # MySQL安装根目录
13 datadir = /home/appuser/mysql/3306/data                      # MySQL数据文件所在位置
14 tmpdir  = /home/appuser/mysql/3306/tmp                                  # 临时目录，比如load data infile会用到
15 socket = /home/appuser/mysql/3306/tmp/mysql.sock        # 为MySQL客户端程序和服务器之间的本地通讯指定一个套接字文件
16 pid-file = /home/appuser/mysql/3306/log/mysql.pid      # pid文件所在目录
17 skip_name_resolve = 1                          # 只能用IP地址检查客户端的登录，不用主机名
18 character-set-server = utf8mb4                  # 数据库默认字符集,主流字符集支持一些特殊表情符号（特殊表情符占用4个字节）
19 transaction_isolation = READ-COMMITTED          # 事务隔离级别，默认为可重复读，MySQL默认可重复读级别
20 collation-server = utf8mb4_general_ci          # 数据库字符集对应一些排序等规则，注意要和character-set-server对应
21 init_connect=\'SET NAMES utf8mb4\'                # 设置client连接mysql时的字符集,防止乱码
22 lower_case_table_names = 1                      # 是否对sql语句大小写敏感，1表示不敏感
23 max_connections = 400                          # 最大连接数
24 max_connect_errors = 1000                      # 最大错误连接数
25 explicit_defaults_for_timestamp = true          # TIMESTAMP如果没有显示声明NOT NULL，允许NULL值
26 max_allowed_packet = 128M                      # SQL数据包发送的大小，如果有BLOB对象建议修改成1G
27 interactive_timeout = 1800                      # MySQL连接闲置超过一定时间后(单位：秒)将会被强行关闭
28 wait_timeout = 1800                            # MySQL默认的wait_timeout值为8个小时, interactive_timeout参数需要同时配置才能生效
29 tmp_table_size = 16M                            # 内部内存临时表的最大值 ，设置成128M；比如大数据量的group by ,order by时可能用到临时表；超过了这个值将写入磁盘，系统IO压力增大 

  1 #
  2 # Licensed to the Apache Software Foundation (ASF) under one or more
  3 # contributor license agreements.  See the NOTICE file distributed with
  4 # this work for additional information regarding copyright ownership.
  5 # The ASF licenses this file to You under the Apache License, Version 2.0
  6 # (the "License"); you may not use this file except in compliance with
  7 # the License.  You may obtain a copy of the License at
  8 #
  9 #     http://www.apache.org/licenses/LICENSE-2.0
 10 #
 11 # Unless required by applicable law or agreed to in writing, software
 12 # distributed under the License is distributed on an "AS IS" BASIS,
 13 # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 14 # See the License for the specific language governing permissions and
 15 # limitations under the License.
 16 #
 17 
 18 
 19 # NOTICE: If the following config has special characters in the variable `.*[]^${}\+?|()@#&`, Please escape, for example, `[` escape to `\[`
 20 # postgresql or mysql
 21 dbtype="mysql"
 22 
 23 # db config
 24 # db address and port
 25 dbhost="192.168.xx.xx:3306"
 26 
 27 # db username
 28 username="xx"
 29 
 30 # db password
 31 # NOTICE: if there are special characters, please use the \ to escape, for example, `[` escape to `\[`
 32 password="xx"
 33 
 34 # database name
 35 dbname="dolphinscheduler"
 36 
 37 
 38 # zk cluster
 39 zkQuorum="192.168.xx.xx:2181,192.168.xx.xx:2181,192.168.xx.xx:2181"
 40 
 41 # zk root directory
 42 zkRoot="/dolphinscheduler"
 43 
 44 # Note: the target installation path for dolphinscheduler, please not config as the same as the current path (pwd)
 45 installPath="/data1_1T/dolphinscheduler"
 46 
 47 # deployment user
 48 # Note: the deployment user needs to have sudo privileges and permissions to operate hdfs. If hdfs is enabled, the root directory needs to be created by itself
 49 deployUser="dolphinscheduler"
 50 
 51 
 52 # alert config
 53 # mail server host
 54 mailServerHost="smtp.exmail.qq.com"
 55 
 56 # mail server port
 57 # note: Different protocols and encryption methods correspond to different ports, when SSL/TLS is enabled, make sure the port is correct.
 58 mailServerPort="25"
 59 
 60 # sender
 61 mailSender="xxxxxxxxxx"
 62 
 63 # user
 64 mailUser="xxxxxxxxxx"
 65 
 66 # sender password
 67 # note: The mail.passwd is email service authorization code, not the email login password.
 68 mailPassword="xxxxxxxxxx"
 69 
 70 # TLS mail protocol support
 71 starttlsEnable="true"
 72 
 73 # SSL mail protocol support
 74 # only one of TLS and SSL can be in the true state.
 75 sslEnable="false"
 76 
 77 #note: sslTrust is the same as mailServerHost
 78 sslTrust="smtp.exmail.qq.com"
 79 
 80 
 81 # resource storage type：HDFS,S3,NONE
 82 resourceStorageType="NONE"
 83 
 84 # if resourceStorageType is HDFS，defaultFS write namenode address，HA you need to put core-site.xml and hdfs-site.xml in the conf directory.
 85 # if S3，write S3 address，HA，for example ：s3a://dolphinscheduler，
 86 # Note，s3 be sure to create the root directory /dolphinscheduler
 87 defaultFS="hdfs://mycluster:8020"
 88 
 89 # if resourceStorageType is S3, the following three configuration is required, otherwise please ignore
 90 s3Endpoint="http://192.168.xx.xx:9010"
 91 s3AccessKey="xxxxxxxxxx"
 92 s3SecretKey="xxxxxxxxxx"
 93 
 94 # if resourcemanager HA enable, please type the HA ips ; if resourcemanager is single, make this value empty
 95 yarnHaIps="192.168.xx.xx,192.168.xx.xx"
 96 
 97 # if resourcemanager HA enable or not use resourcemanager, please skip this value setting; If resourcemanager is single, you only need to replace yarnIp1 to actual resourcemanager hostname.
 98 singleYarnIp="yarnIp1"
 99 
100 # resource store on HDFS/S3 path, resource file will store to this hadoop hdfs path, self configuration, please make sure the directory exists on hdfs and have read write permissions。/dolphinscheduler is recommended
101 resourceUploadPath="/dolphinscheduler"
102 
103 # who have permissions to create directory under HDFS/S3 root path
104 # Note: if kerberos is enabled, please config hdfsRootUser=
105 hdfsRootUser="hdfs"
106 
107 # kerberos config
108 # whether kerberos starts, if kerberos starts, following four items need to config, otherwise please ignore
109 kerberosStartUp="false"
110 # kdc krb5 config file path
111 krb5ConfPath="$installPath/conf/krb5.conf"
112 # keytab username
113 keytabUserName="hdfs-mycluster@ESZ.COM"
114 # username keytab path
115 keytabPath="$installPath/conf/hdfs.headless.keytab"
116 
117 
118 # api server port
119 apiServerPort="12345"
120 
121 
122 # install hosts
123 # Note: install the scheduled hostname list. If it is pseudo-distributed, just write a pseudo-distributed hostname
124 ips="ds1,ds2,ds3,ds4,ds5"
125 
126 # ssh port, default 22
127 # Note: if ssh port is not default, modify here
128 sshPort="22"
129 
130 # run master machine
131 # Note: list of hosts hostname for deploying master
132 masters="ds1,ds2"
133 
134 # run worker machine
135 # note: need to write the worker group name of each worker, the default value is "default"
136 workers="ds1:default,ds2:default,ds3:default,ds4:default,ds5:default"
137 
138 # run alert machine
139 # note: list of machine hostnames for deploying alert server
140 alertServer="ds3"
141 
142 # run api machine
143 # note: list of machine hostnames for deploying api server
144 apiServers="ds1"

  1 #
  2 # Licensed to the Apache Software Foundation (ASF) under one or more
  3 # contributor license agreements.  See the NOTICE file distributed with
  4 # this work for additional information regarding copyright ownership.
  5 # The ASF licenses this file to You under the Apache License, Version 2.0
  6 # (the "License"); you may not use this file except in compliance with
  7 # the License.  You may obtain a copy of the License at
  8 #
  9 #     http://www.apache.org/licenses/LICENSE-2.0
 10 #
 11 # Unless required by applicable law or agreed to in writing, software
 12 # distributed under the License is distributed on an "AS IS" BASIS,
 13 # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 14 # See the License for the specific language governing permissions and
 15 # limitations under the License.
 16 #
 17 
 18 
 19 # NOTICE: If the following config has special characters in the variable `.*[]^${}\+?|()@#&`, Please escape, for example, `[` escape to `\[`
 20 # postgresql or mysql
 21 dbtype="mysql"
 22 
 23 # db config
 24 # db address and port
 25 dbhost="192.168.1.14:3306"
 26 
 27 # db username
 28 username="appuser"
 29 
 30 # db password
 31 # NOTICE: if there are special characters, please use the \ to escape, for example, `[` escape to `\[`
 32 password="appuser"
 33 
 34 # database name
 35 dbname="dolphinscheduler"
 36 
 37 
 38 # zk cluster
 39 zkQuorum="192.168.1.11:2181,192.168.1.12:2181,192.168.1.13:2181"
 40 
 41 # zk root directory
 42 zkRoot="/dolphinscheduler"
 43 
 44 # Note: the target installation path for dolphinscheduler, please not config as the same as the current path (pwd)
 45 installPath="/home/appuser/dolphin/soft"
 46 
 47 # deployment user
 48 # Note: the deployment user needs to have sudo privileges and permissions to operate hdfs. If hdfs is enabled, the root directory needs to be created by itself
 49 deployUser="appuser"
 50 
 51 
 52 # alert config
 53 # mail server host
 54 mailServerHost="smtp.exmail.qq.com"
 55 
 56 # mail server port
 57 # note: Different protocols and encryption methods correspond to different ports, when SSL/TLS is enabled, make sure the port is correct.
 58 mailServerPort="25"
 59 
 60 # sender
 61 mailSender="xxxxxxxxxx"
 62 
 63 # user
 64 mailUser="xxxxxxxxxx"
 65 
 66 # sender password
 67 # note: The mail.passwd is email service authorization code, not the email login password.
 68 mailPassword="xxxxxxxxxx"
 69 
 70 # TLS mail protocol support
 71 starttlsEnable="true"
 72 
 73 # SSL mail protocol support
 74 # only one of TLS and SSL can be in the true state.
 75 sslEnable="false"
 76 
 77 #note: sslTrust is the same as mailServerHost
 78 sslTrust="smtp.exmail.qq.com"
 79 
 80 
 81 # resource storage type：HDFS,S3,NONE
 82 resourceStorageType="HDFS"
 83 
 84 # if resourceStorageType is HDFS，defaultFS write namenode address，HA you need to put core-site.xml and hdfs-site.xml in the conf directory.
 85 # if S3，write S3 address，HA，for example ：s3a://dolphinscheduler，
 86 # Note，s3 be sure to create the root directory /dolphinscheduler
 87 defaultFS="hdfs://server001:8020"
 88 
 89 # if resourceStorageType is S3, the following three configuration is required, otherwise please ignore
 90 s3Endpoint="http://192.168.xx.xx:9010"
 91 s3AccessKey="xxxxxxxxxx"
 92 s3SecretKey="xxxxxxxxxx"
 93 
 94 # if resourcemanager HA enable, please type the HA ips ; if resourcemanager is single, make this value empty
 95 yarnHaIps=""
 96 
 97 # if resourcemanager HA enable or not use resourcemanager, please skip this value setting; If resourcemanager is single, you only need to replace yarnIp1 to actual resourcemanager hostname.
 98 singleYarnIp="192.168.1.12"
 99 
100 # resource store on HDFS/S3 path, resource file will store to this hadoop hdfs path, self configuration, please make sure the directory exists on hdfs and have read write permissions。/dolphinscheduler is recommended
101 resourceUploadPath="/dolphinscheduler"
102 
103 # who have permissions to create directory under HDFS/S3 root path
104 # Note: if kerberos is enabled, please config hdfsRootUser=
105 hdfsRootUser="hdfs"
106 
107 # kerberos config
108 # whether kerberos starts, if kerberos starts, following four items need to config, otherwise please ignore
109 kerberosStartUp="false"
110 # kdc krb5 config file path
111 krb5ConfPath="$installPath/conf/krb5.conf"
112 # keytab username
113 keytabUserName="hdfs-mycluster@ESZ.COM"
114 # username keytab path
115 keytabPath="$installPath/conf/hdfs.headless.keytab"
116 
117 
118 # api server port
119 apiServerPort="12345"
120 
121 
122 # install hosts
123 # Note: install the scheduled hostname list. If it is pseudo-distributed, just write a pseudo-distributed hostname
124 ips="server004"
125 
126 # ssh port, default 22
127 # Note: if ssh port is not default, modify here
128 sshPort="22"
129 
130 # run master machine
131 # Note: list of hosts hostname for deploying master
132 masters="server004"
133 
134 # run worker machine
135 # note: need to write the worker group name of each worker, the default value is "default"
136 workers="server004:default"
137 
138 # run alert machine
139 # note: list of machine hostnames for deploying alert server
140 alertServer="server004"
141 
142 # run api machine
143 # note: list of machine hostnames for deploying api server
144 apiServers="server004"