[mysqld] # # 1. server system settings. begin. # autocommit=0 binlog_format=ROW bind-address=0.0.0.0 datadir=/var/lib/mysql default_storage_engine=innodb default_time_zone='+00:00' expire_logs_days=1 #large_pages #shoud not use binlog_format=MIXED log_bin=/app/db/logs/mysql-binlog log_bin_index=/app/db/logs/mysql-binlog log_error=/var/lib/mysql/mysqlcloudrdbms.log log_queries_not_using_indexes=ON log_slow_verbosity=query_plan,explain long_query_time=2 max_connect_errors=4294967295 max_connections=800 max_delayed_threads=0 max_digest_length=10240 min_examined_row_limit=1000 open_files_limit=16384 #query cache must be zero. It's actually result cache. query_cache_size=0 relay_log=mysql-relay-log relay_log_index=mysql-relay-log socket=/var/lib/mysql/mysql.sock slow_query_log=1 #set to 1, along with innodb_flush_log_at_trx_commit=1 for the greatest level of fault tolerance sync_binlog=1 thread_handling=pool-of-threads transaction_isolation=READ-COMMITTED use_stat_tables=preferably user=app # server system settings. end. # # 2. innodb_* settings. begin. # innodb_autoinc_lock_mode=2 # calculate this: 70% of RAM. Format 1024MB innodb_buffer_pool_size=900M # calculate this: round(innodb_buffer_pool_size/1024) innodb_buffer_pool_instances=1 #double write must be enabled innodb_doublewrite=1 innodb_fast_shutdown=0 innodb_file_per_table=TRUE #set to 1 for great level of fault tolerance innodb_flush_log_at_trx_commit=1 # 500MB to start innodb_log_file_size=500M innodb_thread_concurrency=2 # innodb_* settings. end. # # 3. performance_schema deserves its own section. begin. # performance_schema=ON # performance_schema deserves its own section. end. # # 4. replication related settings. begin. # # Set to 1 if you want to daisy-chain the slaves. log_slave_updates=1 skip-slave-start=1 server-id=6523089 # this sets both "slave_load_tmpdir" and "tmpdir" tmpdir=/var/tmp # replication related settings. end. # # 5. wsrep_* settings. begin. # wsrep_provider=/usr/lib64/galera/libgalera_smm.so wsrep_provider_options="gcache.size=1024M; gcache.page_size=1024M" wsrep_node_address=172.16.202.226 wsrep_cluster_name="db1" wsrep_cluster_address="gcomm://172.16.98.29:4567,172.16.98.147:4567,172.16.202.226:4567" #wsrep_sst_method=xtrabackup-v2 or mysqldump or rsync or xtrabackup, prefer xtrabackup-v2 wsrep_sst_method=xtrabackup-v2 wsrep_sst_auth=root:pass123 #wsrep_certify_nonPK=1 #wsrep_convert_LOCK_to_trx=0 #wsrep_auto_increment_control=1 #wsrep_drupal_282555_workaround=1 #wsrep_OSU_method=TOI #must set it to 1 wsrep_on=1 #wsrep_desync=0 #wsrep_retry_autocommit=2 #wsrep_slave_FK_checks=1 wsrep_slave_UK_checks=1 wsrep_slave_threads=8 #wsrep_causal_reads is deprecated by wsrep_sync_wait wsrep_sync_wait=0 wsrep_debug=1 #wsrep_dbug_option= wsrep_log_conflicts=0 #wsrep_max_ws_rows= #wsrep_max_ws_size= #wsrep_recover= #wsrep_sst_donor= #wsrep_sst_donor_rejects_queries=0 #wsrep_start_position= # wsrep_* settings. end. [mysql_safe] log_error=/var/lib/mysql/mysqlcloudrdbms.log pid_file=/var/run/mysqld/mysqld.pid # # include all files from the config directory # !includedir /etc/my.cnf.d