2 # Copyright © 2018 AT&T, Amdocs, Bell Canada Intellectual Property. All rights reserved.
4 # Licensed under the Apache License, Version 2.0 (the "License");
5 # you may not use this file except in compliance with the License.
6 # You may obtain a copy of the License at
8 # http://www.apache.org/licenses/LICENSE-2.0
10 # Unless required by applicable law or agreed to in writing, software
11 # distributed under the License is distributed on an "AS IS" BASIS,
12 # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 # See the License for the specific language governing permissions and
14 # limitations under the License.
15 # Example MySQL config file for medium systems.
17 # This is for a system with memory 8G where MySQL plays
18 # an important part, or systems up to 128M where MySQL is used together with
19 # other programs (such as a web server)
21 # In this file, you can use all long options that a program supports.
22 # If you want to know which options a program supports, run the program
23 # with the "--help" option.
26 # The following options will be passed to all MySQL clients
30 ##socket = //opt/app/mysql/mysql.sock
32 # Here follows entries for some specific programs
40 slow_query_log_file =//var/lib/mysql/slow_query.log
41 ##basedir = //opt/app/mysql/product/mariadb-10.1.11-linux-x86_64
42 ##datadir = //opt/app/mysql/data
44 ##socket = //opt/app/mysql/mysql.sock
46 explicit_defaults_for_timestamp = true
49 #ignore_db_dir=lost+found
51 max_allowed_packet = 4M
52 table_open_cache = 100
53 sort_buffer_size = 512K
54 net_buffer_length = 8K
55 read_buffer_size = 256K
56 read_rnd_buffer_size = 512K
57 myisam_sort_buffer_size = 8M
59 lower_case_table_names = 1
61 thread_cache_size = 25
64 query_prealloc_size = 512K
65 query_cache_limit = 1M
68 ##plugin-load-add=simple_password_check.so
69 ##simple_password_check_other_characters=0
72 plugin-load-add=server_audit.so
73 server_audit=FORCE_PLUS_PERMANENT
74 server_audit_file_path=//var/lib/mysql/audit.log
75 server_audit_file_rotate_size=50M
76 server_audit_events=CONNECT,QUERY,TABLE
77 server_audit_logging=on
79 # Don't listen on a TCP/IP port at all. This can be a security enhancement,
80 # if all processes that need to connect to mysqld run on the same host.
81 # All interaction with mysqld must be made via Unix sockets or named pipes.
82 # Note that using this option without enabling named pipes on Windows
83 # (via the "enable-named-pipe" option) will render mysqld useless!
87 # Replication Master Server (default)
88 # binary logging is required for replication
89 ##log-bin=//var/lib/mysql/mysql-bin
91 # binary logging format - mixed recommended
94 # required unique id between 1 and 2^32 - 1
95 # defaults to 1 if master-host is not set
96 # but will not function as a master if omitted
98 # Replication Slave (comment out master section to use this)
100 # To configure this host as a replication slave, you can choose between
103 # 1) Use the CHANGE MASTER TO command (fully described in our manual) -
106 # CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
107 # MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
109 # where you replace <host>, <user>, <password> by quoted strings and
110 # <port> by the master's port number (3306 by default).
114 # CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
115 # MASTER_USER='joe', MASTER_PASSWORD='secret';
119 # 2) Set the variables below. However, in case you choose this method, then
120 # start replication for the first time (even unsuccessfully, for example
121 # if you mistyped the password in master-password and the slave fails to
122 # connect), the slave will create a master.info file, and any later
123 # change in this file to the variables' values below will be ignored and
124 # overridden by the content of the master.info file, unless you shutdown
125 # the slave server, delete master.info and restart the slaver server.
126 # For that reason, you may want to leave the lines below untouched
127 # (commented) and instead use CHANGE MASTER TO (see above)
129 # required unique id between 2 and 2^32 - 1
130 # (and different from the master)
131 # defaults to 2 if master-host is set
132 # but will not function as a slave if omitted
135 # The replication master for this slave - required
136 #master-host = <hostname>
138 # The username the slave will use for authentication when connecting
139 # to the master - required
140 #master-user = <username>
142 # The password the slave will authenticate with when connecting to
143 # the master - required
144 #master-password = <password>
146 # The port the master is listening on.
147 # optional - defaults to 3306
148 #master-port = <port>
150 # binary logging - not required for slaves, but recommended
153 # Uncomment the following if you are using InnoDB tables
154 ##innodb_data_home_dir = //opt/app/mysql/data
155 ##innodb_data_file_path = ibdata1:20M:autoextend:max:32G
156 ##innodb_log_group_home_dir = //opt/app/mysql/iblogs
157 # You can set .._buffer_pool_size up to 50 - 80 %
158 # of RAM but beware of setting memory usage too high
159 innodb_buffer_pool_size = 128M
160 #innodb_additional_mem_pool_size = 2M
161 # Set .._log_file_size to 25 % of buffer pool size
162 innodb_log_file_size = 10M
163 innodb_log_files_in_group = 3
164 innodb_log_buffer_size = 8M
165 #innodb_flush_log_at_trx_commit = 1
166 innodb_lock_wait_timeout = 50
167 innodb_autoextend_increment = 100
169 open_files_limit = 2000
170 transaction-isolation=READ-COMMITTED
171 ####### Galera parameters #######
172 ## Galera Provider configuration
173 wsrep_provider=/usr/lib/galera/libgalera_smm.so
174 wsrep_provider_options="gcache.size=128M; gcache.page_size=10M"
175 ## Galera Cluster configuration
176 wsrep_cluster_name="MSO-automated-tests-cluster"
177 wsrep_cluster_address="gcomm://"
178 #wsrep_cluster_address="gcomm://mariadb1,mariadb2,mariadb3"
179 ##wsrep_cluster_address="gcomm://192.169.3.184,192.169.3.185,192.169.3.186"
180 ## Galera Synchronization configuration
181 wsrep_sst_method=rsync
182 #wsrep_sst_method=xtrabackup-v2
183 #wsrep_sst_auth="sstuser:Mon#2o!6"
184 ## Galera Node configuration
185 wsrep_node_name="mariadb1"
186 ##wsrep_node_address="192.169.3.184"
188 ## Status notification
189 #wsrep_notify_cmd=/opt/app/mysql/bin/wsrep_notify
195 max_allowed_packet = 16M
199 # Remove the next comment character if you are not familiar with SQL
203 key_buffer_size = 20971520
206 ##interactive-timeout
208 ##malloc-lib=//opt/app/mysql/local/lib/libjemalloc.so.1
209 ##log-error=//opt/app/mysql/log/mysqld.log