[TABLE=“class: table_results ajax pma_table”]
[TR]
[TD] [/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_local_state_uuid[/TD]
[TD=“class: data text”]a8e8a277-6f03-11e2-0800-5896d9f10d3c[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_protocol_version[/TD]
[TD=“class: data text”]4[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_last_committed[/TD]
[TD=“class: data text”]93828567[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_replicated[/TD]
[TD=“class: data text”]3305034[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_replicated_bytes[/TD]
[TD=“class: data text”]7215828937[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_received[/TD]
[TD=“class: data text”]4690946[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_received_bytes[/TD]
[TD=“class: data text”]10461552800[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_local_commits[/TD]
[TD=“class: data text”]3300961[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_local_cert_failures[/TD]
[TD=“class: data text”]3027[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_local_replays[/TD]
[TD=“class: data text”]0[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_local_send_queue[/TD]
[TD=“class: data text”]0[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_local_send_queue_avg[/TD]
[TD=“class: data text”]0.000000[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_local_recv_queue[/TD]
[TD=“class: data text”]0[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_local_recv_queue_avg[/TD]
[TD=“class: data text”]0.000000[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_flow_control_paused[/TD]
[TD=“class: data text”]0.000000[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_flow_control_sent[/TD]
[TD=“class: data text”]0[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_flow_control_recv[/TD]
[TD=“class: data text”]0[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_cert_deps_distance[/TD]
[TD=“class: data text”]87.147799[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_apply_oooe[/TD]
[TD=“class: data text”]0.000000[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_apply_oool[/TD]
[TD=“class: data text”]0.000000[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_apply_window[/TD]
[TD=“class: data text”]0.000000[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_commit_oooe[/TD]
[TD=“class: data text”]0.000000[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_commit_oool[/TD]
[TD=“class: data text”]0.000000[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_commit_window[/TD]
[TD=“class: data text”]0.000000[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_local_state[/TD]
[TD=“class: data text”]4[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_local_state_comment[/TD]
[TD=“class: data text”]Synced[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_cert_index_size[/TD]
[TD=“class: data text”]1293[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_causal_reads[/TD]
[TD=“class: data text”]0[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_incoming_addresses[/TD]
[TD=“class: data text”]111.111.111.11:1111,111.111.111.111:111[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_cluster_conf_id[/TD]
[TD=“class: data text”]15[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_cluster_size[/TD]
[TD=“class: data text”]2[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_cluster_state_uuid[/TD]
[TD=“class: data text”]a8e8a277-6f03-11e2-0800-5896d9f10d3c[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_cluster_status[/TD]
[TD=“class: data text”]Primary[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_connected[/TD]
[TD=“class: data text”]ON[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_local_bf_aborts[/TD]
[TD=“class: data text”]181[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_local_index[/TD]
[TD=“class: data text”]0[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_provider_name[/TD]
[TD=“class: data text”]Galera[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_provider_vendor[/TD]
[TD=“class: data text”]Codership Oy <info@codership.com>[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_provider_version[/TD]
[TD=“class: data text”]2.11(r318911d)[/TD]
[/TR]
[TR=“class: even”]
[TD=“class: data not_null text”]wsrep_ready[/TD]
[TD=“class: data text”]ON[/TD]
[/TR]
[TR=“class: odd”]
[TD=“class: data not_null text”]wsrep_thread_count[/TD]
[TD=“class: data text”]9[/TD]
[/TR]
[/TABLE]
[root@db02 etc]# cat my.cnf
The following options will be passed to all MySQL clients
[client]
#password = ################
port = 3306
socket = /var/lib/mysql/mysql.sock
The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
Set up SSL
ssl-ca = /etc/mysql/certs/ca-cert.pem
ssl-cert = /etc/mysql/certs/server-cert.pem
ssl-key = /etc/mysql/certs/server-key.pem
ssl-cipher = AES256-GCM-SHA384:AES256-SHA256:AES256-SHA
skip-external-locking
log-error = /var/log/mysql/mysqld.log
slow_query_log_file = /var/log/mysql/mysql-slow.log
key_buffer_size = 32M
max_allowed_packet = 16M
table_open_cache = 2048
thread_cache_size = 50
query_cache_type = 0
query_cache_size = 0
table_definition_cache = 4096
tmp_table_size = 32M
max_heap_table_size = 32M
long_query_time = 2
slow_query_log = 1
wait_timeout = 30
interactive_timeout = 300
max_connections = 450
open_files_limit = 65535
innodb_stats_on_metadata = 0
Percona Settings
wsrep_cluster_address = gcomm:(deleted this part)
wsrep_provider = /usr/lib64/libgalera_smm.so
wsrep_slave_threads = 8
wsrep_sst_method = xtrabackup-v2
wsrep_sst_auth =
wsrep_cluster_name = the_web
wsrep_node_name = web2
wsrep_provider_options = “pc.weight=2;socket.ssl_cert=/etc/mysql/certs/server-cert.pem;socket.ssl_key=/etc/mysql/certs/server-key.pem;socket.ssl_ca=/etc/mysql/certs/ca-cert.pem;”
innodb_autoinc_lock_mode = 2
innodb_locks_unsafe_for_binlog = 1
datadir = /var/lib/mysql
binlog_format=ROW
log_slave_updates
Replication Master Server (default)
binary logging is required for replication
#log-bin=mysql-bin
required unique id between 1 and 2^32 - 1
defaults to 1 if master-host is not set
but will not function as a master if omitted
server-id = 2
innodb_buffer_pool_size = 10G
innodb_log_file_size = 256M
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
Remove the next comment character if you are not familiar with SQL
#safe-updates
[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[sst]
encrypt=3
tkey=/etc/mysql/certs/server-key.pem
tcert=/etc/mysql/certs/server-cert.pem