{\rtf1\ansi\ansicpg1252\cocoartf2577
\cocoatextscaling0\cocoaplatform0{\fonttbl\f0\fnil\fcharset0 Monaco;\f1\fswiss\fcharset0 Helvetica;}
{\colortbl;\red255\green255\blue255;\red22\green21\blue22;\red22\green21\blue22;\red246\green246\blue246;
}
{\*\expandedcolortbl;;\cssrgb\c11373\c10980\c11373;\cssrgb\c11373\c10980\c11373\c3922;\cssrgb\c97255\c97255\c97255;
}
\margl1440\margr1440\vieww50700\viewh27940\viewkind0
\deftab720
\pard\pardeftab720\sl360\partightenfactor0

\f0\fs24 \cf2 \cb3 \expnd0\expndtw0\kerning0
\outl0\strokewidth0 \strokec2 root@mariadb-server-0:/etc/mysql/conf.d# ls -arlht\
total 20K\
-r--r--r-- 1 root root   44 Oct 20 00:05 99-force.cnf\
-r--r--r-- 1 root root 3.4K Oct 20 00:05 00-base.cnf\
drwxr-xr-x 1 root root 4.0K Oct 20 00:06 ..\
drwxrwxrwx 2 root root 4.0K Oct 20 00:06 .\
-rw-r--r-- 1 root root  348 Oct 20 00:06 10-cluster-config.cnf\
root@mariadb-server-0:/etc/mysql/conf.d# cat 00-base.cnf \
[mysqld]\
# Charset\
character_set_server=utf8\
collation_server=utf8_general_ci\
skip-character-set-client-handshake\
# Logging\
slow_query_log=off\
slow_query_log_file=/var/log/mysql/mariadb-slow.log\
log_warnings=2\
# General logging has huge performance penalty therefore is disabled by default\
general_log=off\
general_log_file=/var/log/mysql/mariadb-error.log\
long_query_time=3\
log_queries_not_using_indexes=on\
# Networking\
bind_address=0.0.0.0\
port=3306\
# When a client connects, the server will perform hostname resolution,\
# and when DNS is slow, establishing the connection will become slow as well.\
# It is therefore recommended to start the server with skip-name-resolve to\
# disable all DNS lookups. The only limitation is that the GRANT statements\
# must then use IP addresses only.\
skip_name_resolve\
# Tuning\
user=mysql\
max_allowed_packet=256M\
open_files_limit=10240\
max_connections=8192\
max-connect-errors=1000000\
# General security settings\
# Reference link below:\
# {\field{\*\fldinst{HYPERLINK "https://dev.mysql.com/doc/mysql-security-excerpt/8.0/en/general-security-issues.html"}}{\fldrslt https://dev.mysql.com/doc/mysql-security-excerpt/8.0/en/general-security-issues.html}}\
# secure_file_priv is set to '/home' because it is read-only, which will\
# disable this feature completely.\
secure_file_priv=/home\
local_infile=0\
symbolic_links=0\
sql_mode="STRICT_ALL_TABLES,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"\
## Generally, it is unwise to set the query cache to be larger than 64-128M\
## as the costs associated with maintaining the cache outweigh the performance\
## gains.\
## The query cache is a well known bottleneck that can be seen even when\
## concurrency is moderate. The best option is to disable it from day 1\
## by setting query_cache_size=0 (now the default on MySQL 5.6)\
## and to use other ways to speed up read queries: good indexing, adding\
## replicas to spread the read load or using an external cache.\
query_cache_size=0\
query_cache_type=0\
sync_binlog=0\
thread_cache_size=16\
table_open_cache=2048\
table_definition_cache=1024\
#\
# InnoDB\
#\
# The buffer pool is where data and indexes are cached: having it as large as possible\
# will ensure you use memory and not disks for most read operations.\
# Typical values are 50..75% of available RAM.\
# TODO(tomasz.paszkowski): This needs to by dynamic based on available RAM.\
innodb_buffer_pool_size=1024M\
innodb_doublewrite=0\
innodb_file_format=Barracuda\
innodb_file_per_table=1\
innodb_flush_method=O_DIRECT\
innodb_io_capacity=500\
innodb_locks_unsafe_for_binlog=1\
innodb_log_file_size=128M\
innodb_old_blocks_time=1000\
innodb_read_io_threads=8\
innodb_write_io_threads=8\
# Clustering\
binlog_format=ROW\
default-storage-engine=InnoDB\
innodb_autoinc_lock_mode=2\
innodb_flush_log_at_trx_commit=2\
wsrep_cluster_name=mariadb-server_openstack\
wsrep_on=1\
wsrep_provider=/usr/lib/galera/libgalera_smm.so\
wsrep_provider_options="evs.suspect_timeout=PT30S; evs.max_install_timeouts=100; 
\f1\fs30 \cb4 evs.install_timeout=PT1M;evs.inactive_timeout=PT1M;evs.inactive_check_period=PT1S;evs.keepalive_period=PT1S;debug=yes
\f0\fs24 \cb3 ; gmcast.peer_timeout=PT15S; gmcast.listen_addr={\field{\*\fldinst{HYPERLINK "tcp://0.0.0.0:4567"}}{\fldrslt tcp://0.0.0.0:4567}}"\
wsrep_slave_threads=12\
wsrep_sst_auth=sst:b421b1cf302ac80f43be\
wsrep_sst_method=mariabackup\
\
# TLS\
ssl_ca=/etc/mysql/certs/ca.crt\
ssl_key=/etc/mysql/certs/tls.key\
ssl_cert=/etc/mysql/certs/tls.crt\
# tls_version = TLSv1.2,TLSv1.3\
\
[mysqldump]\
max-allowed-packet=16M\
[client]\
default_character_set=utf8\
protocol=tcp\
port=3306\
\
# TLS\
ssl_ca=/etc/mysql/certs/ca.crt\
ssl_key=/etc/mysql/certs/tls.key\
ssl_cert=/etc/mysql/certs/tls.crt\
# tls_version = TLSv1.2,TLSv1.3\
ssl-verify-server-cert=false\
  \
root@mariadb-server-0:/etc/mysql/conf.d# cat 99-force.cnf \
[mysqld]\
datadir=/var/lib/mysql\
tmpdir=/tmp\
root@mariadb-server-0:/etc/mysql/conf.d# LS -ARLHT\
bash: LS: command not found\
root@mariadb-server-0:/etc/mysql/conf.d# ls -arlht\
total 20K\
-r--r--r-- 1 root root   44 Oct 20 00:05 99-force.cnf\
-r--r--r-- 1 root root 3.4K Oct 20 00:05 00-base.cnf\
drwxr-xr-x 1 root root 4.0K Oct 20 00:06 ..\
drwxrwxrwx 2 root root 4.0K Oct 20 00:06 .\
-rw-r--r-- 1 root root  348 Oct 20 00:06 10-cluster-config.cnf\
root@mariadb-server-0:/etc/mysql/conf.d# cat 10-cluster-config.cnf \
[mysqld]\
wsrep_node_address = mariadb-server-0.mariadb-discovery.openstack.svc.cluster.local:4567\
wsrep_node_name = mariadb-server-0.mariadb-discovery.openstack.svc.cluster.local\
wsrep_cluster_address = {\field{\*\fldinst{HYPERLINK "gcomm://mariadb-server-1.mariadb-discovery.openstack.svc.cluster.local:4567"}}{\fldrslt gcomm://mariadb-server-1.mariadb-discovery.openstack.svc.cluster.local:4567}},mariadb-server-2.mariadb-discovery.openstack.svc.cluster.local:4567\
\
root@mariadb-server-0:/etc/mysql/conf.d# \
}