# # These groups are read by MariaDB server. # Use it for options that only the server (but not clients) should see # # See the examples of server my.cnf files in /usr/share/mysql/ # # this is read by the standalone daemon and embedded servers [server] # this is only for the mysqld standalone daemon [mysqld] datadir = /u01/mydata/mariadb/e3logintp1 socket = /u01/mydata/mariadb/e3logintp1/mysql.sock pid-file = /u01/mydata/mariadb/e3logintp1/mysqld.pid log-error = /u01/mydata/mariadb/e3logintp1/mysqld.err slow_query_log_file = /u01/mydata/mariadb/e3logintp1/mysqld-slow.log general_log_file = /u01/mydata/mariadb/e3logintp1/mysqld.log tmpdir = /u01/mydata/mariadb/mytmp autocommit = 0 skip-external-locking key_buffer_size = 256M max_allowed_packet = 64M table_open_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M log_bin_trust_function_creators = TRUE myisam_sort_buffer_size = 64M thread_cache_size = 8 character-set-server = utf8mb4 character-set-client-handshake = false table_open_cache_instances = 2 explicit_defaults_for_timestamp = true lower_case_table_names = 1 #transaction-isolation = read-committed transaction-isolation = REPEATABLE-READ expire_logs_days = 3 log-bin = /u01/myarch/mariadb/e3logintp1/mysql-bin log_slave_updates max_binlog_size = 104857600 innodb_data_home_dir = /u01/mydata/mariadb/e3logintp1 #innodb_data_file_path = systemts1:1G:autoextend:max:4G innodb_log_group_home_dir = /u01/mydata/mariadb/e3logintp1 innodb_log_file_size = 100M innodb_log_files_in_group = 10 innodb_file_per_table = 1 innodb_undo_directory = /u01/mydata/mariadb/e3logintp1/undotbs innodb_undo_tablespaces = 1 innodb_undo_logs=1 #innodb_large_prefix = ON innodb_adaptive_hash_index=0 user = e3logint binlog_format = ROW bind-address = 10.88.227.147 port = 20306 sql_mode = no_engine_substitution language = /u01/app/mariadb/current/share/english/ plugin_dir = /u01/app/mariadb/current/lib/plugin innodb_autoinc_lock_mode = 2 innodb_flush_log_at_trx_commit = 0 innodb_buffer_pool_size = 122M innodb_lock_wait_timeout = 1 server_id = 2 #wsrep_sst_method = mariabackup #wsrep_sst_method = xtrabackup-v2 #wsrep_sst_method = xtrabackup #wsrep_sst_auth = backup_user:egis1234 # # * Galera-related settings # #[galera] # Mandatory settings wsrep_on = ON #wsrep_provider = /usr/lib64/galera-3/libgalera_smm.so wsrep_provider = /u01/app/mariadb/current/lib/libgalera_smm.so #wsrep_provider_options = "gcache.recover=yes; gcache.size=300M; gcache.page_size=300M; gmcast.listen_addr=tcp://10.88.227.147:4567" wsrep_provider_options = "gcache.size=300M; gcache.page_size=300M;" wsrep_cluster_name = "e3logint" wsrep_cluster_address = "gcomm://10.88.227.147,10.88.99.147,10.88.99.35" wsrep_sst_method = rsync #wsrep_sst_method = xtrabackup #wsrep_sst_method = xtrabackup-v2 #wsrep_sst_method = mariabackup #wsrep_sst_auth = backup_user:egis1234 wsrep_node_address = "10.88.227.147" wsrep_node_name = "e3logintp1" #wsrep_debug=ON default_storage_engine = InnoDB # # Allow server to accept connections on all interfaces. # #bind-address=0.0.0.0 # # Optional setting #wsrep_slave_threads=1 #innodb_flush_log_at_trx_commit=0 # this is only for embedded server [embedded] # This group is only read by MariaDB servers, not by MySQL. # If you use the same .cnf file for MySQL and MariaDB, # you can put MariaDB-only options here [mariadb] # This group is only read by MariaDB-10.2 servers. # If you use the same .cnf file for MariaDB of different versions, # use this group for options that older servers don't understand [mariadb-10.2]