Skip to content

Instantly share code, notes, and snippets.

@erichowey

erichowey/my.cnf Secret

Created October 30, 2021 18:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save erichowey/b88795e19a68d174dddf55383e488919 to your computer and use it in GitHub Desktop.
Save erichowey/b88795e19a68d174dddf55383e488919 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
my.cnf
[mysqld]
skip-name-resolve=1
datadir=/var/lib/mysql
sql-mode="ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
bind-address=0.0.0.0
expire_logs_days=2
performance_schema=ON
character-set-server=utf8mb4
collation-server=utf8mb4_general_ci
join_buffer_size=1M
log_slave_updates=1
join_buffer_size=786K
innodb_buffer_pool_size=120G
innodb_buffer_pool_instances=10
innodb_log_file_size=1G
innodb_file_per_table=ON
innodb_lock_wait_timeout=600
max_connections=1000
max_allowed_packet=150M
slow_query_log=ON
long_query_time=3
### GALERA MANDETORY SETTINGS
default_storage_engine=innodb
binlog_format=ROW
log_bin=binlog
query_cache_size=0
innodb_autoinc_lock_mode=2
innodb_doublewrite=1
wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so
### GALERA SETTINGS
wsrep_on=ON
wsrep_cluster_name=<redacted>
wsrep_node_address=10.99.1.68
wsrep_sst_receive_address=10.99.1.68
wsrep_cluster_address=gcomm://10.99.1.66,10.99.1.67,10.99.1.68
wsrep_sst_method=mariabackup
wsrep_sst_auth=<redacted>:<redacted>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment