[mysql] # CLIENT # port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld] # GALERA # wsrep_on = ON wsrep_provider = /usr/lib/galera/libgalera_smm.so wsrep_provider_options = "gcache.size=4G" wsrep_cluster_address = gcomm://XXXXXXXXXXX wsrep_cluster_name = prd-dbs-cluster01 wsrep_node_address = XXXXXXXXX wsrep_sst_method = mariabackup wsrep_sst_auth = XXXXXXXXX wsrep_sst_receive_address = XXXXXXXXX wsrep_retry_autocommit = 5 wsrep_max_ws_size = 4G wsrep_max_ws_rows = 1M wsrep_slave_threads = 16 #consider using twice the number of CPU cores #wsrep_gtid_mode=ON #wsrep_gtid_domain_id=100 #log_slave_updates=1 #gtid_domain_id=101 #log_bin = /data/mysql/mariadb-bin #log_bin_index = /data/mysql/mariadb-bin.index #expire_logs_days = 10 #max_binlog_size = 100M # GALERA Mandatory setting default-storage-engine = InnoDB query-cache-size = 0 binlog_format = ROW innodb_autoinc_lock_mode = 2 #innodb_doublewrite = 1 #this is the default and it should stay this way # GENERAL # user = mysql default-storage-engine = InnoDB socket = /var/run/mysqld/mysqld.sock pid-file = /var/run/mysqld/mysqld.pid bind-address = 0.0.0.0 # MyISAM # key-buffer-size = 32M myisam-recover = FORCE,BACKUP # SAFETY # max-allowed-packet = 128M max-connect-errors = 1000000 skip-name-resolve # DATA STORAGE # datadir = /data/mysql/ tmpdir = /data/tmp/ # CACHES AND LIMITS # tmp-table-size = 32M #max-heap-table-size = 32M max_heap_table_size = 1G query-cache-type = 0 max-connections = 500 connect_timeout = 5 wait_timeout = 600 thread-cache-size = 50 open-files-limit = 65535 table-definition-cache = 4096 table-open-cache = 10240 # INNODB # #innodb-flush-method = O_DIRECT innodb-log-files-in-group = 2 innodb-log-file-size = 512M innodb-flush-log-at-trx-commit = 1 innodb-file-per-table = 1 innodb-buffer-pool-size = 10G # LOGGING # log-error = /var/log/mysql/mysql-error.log #log-queries-not-using-indexes = 0 #slow-query-log = 1 #long_query_time = 1 min_examined_row_limit = 1000 #slow-query-log-file = /var/log/mysql/mysql-slow.log innodb_monitor_enable=all performance_schema=ON sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"