SHOW GLOBAL VARIABLES LIKE '%version%';
+-------------------------+-----------------------------------+
| Variable_name | Value |
+-------------------------+-----------------------------------+
| innodb_version | 5.6.22-72.0 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 10.0.17-MariaDB-wsrep |
| version_comment | MariaDB Server, wsrep_25.10.r4144 |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
| version_malloc_library | bundled jemalloc |
+-------------------------+-----------------------------------+
[root@basedatos-d ~]# more /etc/my.cnf
[MYSQLD]
user=mysql
basedir=/usr/
datadir=/Data/mysql
tmpdir=/Data/mysql/tmp
socket=/var/lib/mysql/mysql.sock
pid_file=mysqld.pid
port=3306
log_error=/var/log/mysqld.log
log_warnings=2
#log_output=FILE
### INNODB OPTIONS
innodb_buffer_pool_size=5000M
innodb_flush_log_at_trx_commit=2
innodb_file_per_table=1
innodb_data_file_path = ibdata1:100M:autoextend
## You may want to tune the below depending on number of cores and disk sub
innodb_read_io_threads=4
innodb_write_io_threads=4
innodb_io_capacity=200
innodb_doublewrite=1
innodb_log_file_size=512M
innodb_log_buffer_size=64M
innodb_buffer_pool_instances=4
innodb_log_files_in_group=2
innodb_thread_concurrency=64
#innodb_file_format=barracuda
innodb_flush_method = O_DIRECT
innodb_autoinc_lock_mode=2
## avoid statistics update when doing e.g show tables
innodb_stats_on_metadata=0
default_storage_engine=innodb
# CHARACTER SET
#collation_server = utf8_unicode_ci
#init_connect='SET NAMES utf8'
#character_set_server = utf8
event_scheduler=ON
# REPLICATION SPECIFIC
#server_id must be unique across all mysql servers participating in replication.
#server_id=SERVERID
binlog_format=ROW
#log_slave_updates=1
#log_bin=binlog
#relay_log=relay-bin
#expire_logs_days=7
#gtid_mode=ON
#enforce_gtid_consistency=1
# OTHER THINGS, BUFFERS ETC
key_buffer_size = 24M
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 512M
#sort_buffer_size = 256K
#read_buffer_size = 256K
#read_rnd_buffer_size = 512K
#myisam_sort_buffer_size = 8M
skip_name_resolve
memlock=0
sysdate_is_now=1
max_connections=700
max_user_connections=350
thread_cache_size=512
query_cache_type = 0
query_cache_size = 0
table_open_cache=1024
lower_case_table_names=0
# 5.6 backwards compatibility
explicit_defaults_for_timestamp=1
##
## WSREP options
##
# Full path to wsrep provider library or 'none'
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_node_address=192.168.111.55
# Provider specific configuration options
wsrep_provider_options="gcache.size=8192M; gmcast.segment=0"
# Logical cluster name. Should be the same for all nodes.
wsrep_cluster_name="my_wsrep_cluster"
# Group communication system handle
wsrep_cluster_address=gcomm://192.168.111.55,192.168.111.56,192.168.111.57
# Human_readable node name (non-unique). Hostname by default.
wsrep_node_name=192.168.111.55
# Address for incoming client connections. Autodetect by default.
#wsrep_node_incoming_address=
# How many threads will process writesets from other nodes
wsrep_slave_threads=8
# DBUG options for wsrep provider
#wsrep_dbug_option
# Generate fake primary keys for non-PK tables (required for multi-master
# and parallel applying operation)
wsrep_certify_nonPK=1
# Location of the directory with data files. Needed for non-mysqldump
# state snapshot transfers. Defaults to mysql_real_data_home.
#wsrep_data_home_dir=
# Maximum number of rows in write set
wsrep_max_ws_rows=131072
# Maximum size of write set
wsrep_max_ws_size=1073741824
# to enable debug level logging, set this to 1
wsrep_debug=0
# convert locking sessions into transactions
wsrep_convert_LOCK_to_trx=0
# how many times to retry deadlocked autocommits
wsrep_retry_autocommit=1
# change auto_increment_increment and auto_increment_offset automatically
wsrep_auto_increment_control=1
# replicate myisam
wsrep_replicate_myisam=1
# retry autoinc insert, which failed for duplicate key error
wsrep_drupal_282555_workaround=0
# enable "strictly synchronous" semantics for read operations
wsrep_causal_reads=0
# Command to call when node status or cluster membership changes.
# Will be passed all or some of the following options:
# --status - new status of this node
# --uuid - UUID of the cluster
# --primary - whether the component is primary or not ("yes"/"no")
# --members - comma-separated list of members
# --index - index of this node in the list
#wsrep_notify_cmd=
##
## WSREP State Transfer options
##
# State Snapshot Transfer method
# ClusterControl currently DOES NOT support wsrep_sst_method=mysqldump
wsrep_sst_method=xtrabackup-v2
# Address on THIS node to receive SST at. DON'T SET IT TO DONOR ADDRESS!!!
# (SST method dependent. Defaults to the first IP of the first interface)
#wsrep_sst_receive_address=
# SST authentication string. This will be used to send SST to joining nodes.
# Depends on SST method. For mysqldump method it is root:<root password>
wsrep_sst_auth=root:pp3zwc02
# Desired SST donor name.
#wsrep_sst_donor=
# Protocol version to use
# wsrep_protocol_version=
[MYSQL]
socket=/var/lib/mysql/mysql.sock
#default_character_set=utf8
[client]
socket=/var/lib/mysql/mysql.sock
#default_character_set=utf8
[mysqldump]
max_allowed_packet = 512M
socket=/var/lib/mysql/mysql.sock
#default_character_set=utf8
[MYSQLD_SAFE]
pid_file=mysqld.pid
log_error=/var/log/mysqld.log
basedir=/usr/
datadir=/Data/mysql
SHOW GLOBAL VARIABLES LIKE '%version%'; ------- ------- -----+- ------- ------- ------- ------- ------+ ------- ------- -----+- ------- ------- ------- ------- ------+ conversions | | MariaDB- wsrep | compile_ machine | x86_64 | malloc_ library | bundled jemalloc | ------- ------- -----+- ------- ------- ------- ------- ------+
+------
| Variable_name | Value |
+------
| innodb_version | 5.6.22-72.0 |
| protocol_version | 10 |
| slave_type_
| version | 10.0.17-
| version_comment | MariaDB Server, wsrep_25.10.r4144 |
| version_
| version_compile_os | Linux |
| version_
+------
[root@basedatos-d ~]# more /etc/my.cnf /Data/mysql/ tmp /var/lib/ mysql/mysql. sock /var/log/ mysqld. log buffer_ pool_size= 5000M flush_log_ at_trx_ commit= 2 file_per_ table=1 data_file_ path = ibdata1: 100M:autoextend read_io_ threads= 4 write_io_ threads= 4 io_capacity= 200 doublewrite= 1 log_file_ size=512M log_buffer_ size=64M buffer_ pool_instances= 4 log_files_ in_group= 2 thread_ concurrency= 64 file_format= barracuda autoinc_ lock_mode= 2 stats_on_ metadata= 0 storage_ engine= innodb set_server = utf8 updates= 1 log=relay- bin gtid_consistenc y=1 buffer_ size = 512K sort_buffer_ size = 8M connections= 350 cache_size= 512 cache=1024 table_names= 0 defaults_ for_timestamp= 1 /usr/lib64/ galera/ libgalera_ smm.so address= 192.168. 111.55 options= "gcache. size=8192M; gmcast.segment=0" name="my_ wsrep_cluster" address= gcomm:/ /192.168. 111.55, 192.168. 111.56, 192.168. 111.57 name=192. 168.111. 55 node_incoming_ address= threads= 8 nonPK=1 data_home. data_home_ dir= ws_rows= 131072 ws_size= 1073741824 LOCK_to_ trx=0 autocommit= 1 increment and auto_increment_ offset automatically increment_ control= 1 _myisam= 1 282555_ workaround= 0 reads=0 method= mysqldump method= xtrabackup- v2 sst_receive_ address= auth=root: pp3zwc02 version= /var/lib/ mysql/mysql. sock character_ set=utf8 /var/lib/ mysql/mysql. sock character_ set=utf8 /var/lib/ mysql/mysql. sock character_ set=utf8 /var/log/ mysqld. log
[MYSQLD]
user=mysql
basedir=/usr/
datadir=/Data/mysql
tmpdir=
socket=
pid_file=mysqld.pid
port=3306
log_error=
log_warnings=2
#log_output=FILE
### INNODB OPTIONS
innodb_
innodb_
innodb_
innodb_
## You may want to tune the below depending on number of cores and disk sub
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
#innodb_
innodb_flush_method = O_DIRECT
innodb_
## avoid statistics update when doing e.g show tables
innodb_
default_
# CHARACTER SET
#collation_server = utf8_unicode_ci
#init_connect='SET NAMES utf8'
#character_
event_scheduler=ON
# REPLICATION SPECIFIC
#server_id must be unique across all mysql servers participating in replication.
#server_id=SERVERID
binlog_format=ROW
#log_slave_
#log_bin=binlog
#relay_
#expire_logs_days=7
#gtid_mode=ON
#enforce_
# OTHER THINGS, BUFFERS ETC
key_buffer_size = 24M
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 512M
#sort_buffer_size = 256K
#read_buffer_size = 256K
#read_rnd_
#myisam_
skip_name_resolve
memlock=0
sysdate_is_now=1
max_connections=700
max_user_
thread_
query_cache_type = 0
query_cache_size = 0
table_open_
lower_case_
# 5.6 backwards compatibility
explicit_
##
## WSREP options
##
# Full path to wsrep provider library or 'none'
wsrep_provider=
wsrep_node_
# Provider specific configuration options
wsrep_provider_
# Logical cluster name. Should be the same for all nodes.
wsrep_cluster_
# Group communication system handle
wsrep_cluster_
# Human_readable node name (non-unique). Hostname by default.
wsrep_node_
# Address for incoming client connections. Autodetect by default.
#wsrep_
# How many threads will process writesets from other nodes
wsrep_slave_
# DBUG options for wsrep provider
#wsrep_dbug_option
# Generate fake primary keys for non-PK tables (required for multi-master
# and parallel applying operation)
wsrep_certify_
# Location of the directory with data files. Needed for non-mysqldump
# state snapshot transfers. Defaults to mysql_real_
#wsrep_
# Maximum number of rows in write set
wsrep_max_
# Maximum size of write set
wsrep_max_
# to enable debug level logging, set this to 1
wsrep_debug=0
# convert locking sessions into transactions
wsrep_convert_
# how many times to retry deadlocked autocommits
wsrep_retry_
# change auto_increment_
wsrep_auto_
# replicate myisam
wsrep_replicate
# retry autoinc insert, which failed for duplicate key error
wsrep_drupal_
# enable "strictly synchronous" semantics for read operations
wsrep_causal_
# Command to call when node status or cluster membership changes.
# Will be passed all or some of the following options:
# --status - new status of this node
# --uuid - UUID of the cluster
# --primary - whether the component is primary or not ("yes"/"no")
# --members - comma-separated list of members
# --index - index of this node in the list
#wsrep_notify_cmd=
##
## WSREP State Transfer options
##
# State Snapshot Transfer method
# ClusterControl currently DOES NOT support wsrep_sst_
wsrep_sst_
# Address on THIS node to receive SST at. DON'T SET IT TO DONOR ADDRESS!!!
# (SST method dependent. Defaults to the first IP of the first interface)
#wsrep_
# SST authentication string. This will be used to send SST to joining nodes.
# Depends on SST method. For mysqldump method it is root:<root password>
wsrep_sst_
# Desired SST donor name.
#wsrep_sst_donor=
# Protocol version to use
# wsrep_protocol_
[MYSQL]
socket=
#default_
[client]
socket=
#default_
[mysqldump]
max_allowed_packet = 512M
socket=
#default_
[MYSQLD_SAFE]
pid_file=mysqld.pid
log_error=
basedir=/usr/
datadir=/Data/mysql