# This file contains wsrep-related mysqld options. It should be included
# in the main MySQL configuration file.
#
# Options that need to be customized:
# - wsrep_provider
# - wsrep_cluster_address
# - wsrep_sst_auth
# The rest of defaults should work out of the box.
##
## mysqld options _MANDATORY_ for correct opration of the cluster
##
[mysqld]
# (This must be substituted by wsrep_format)
binlog_format=ROW
# Currently only InnoDB storage engine is supported
default-storage-engine=innodb
# to avoid issues with 'bulk mode inserts' using autoinc
innodb_autoinc_lock_mode=2
# This is a must for paralell applying
innodb_locks_unsafe_for_binlog=1
#Try to fix futex loop
innodb_thread_concurrency = 32
# Query Cache is not supported with wsrep
query_cache_size=0
query_cache_type=0
# Override bind-address
# In some systems bind-address defaults to 127.0.0.1, and with mysqldump SST
# it will have (most likely) disastrous consequences on donor node
bind-address=10.0.176.3
port=3307
##
## WSREP options
##
# Full path to wsrep provider library or 'none'
wsrep_provider=/usr/lib/galera/libgalera_smm.so
# Logical cluster name. Should be the same for all nodes.
wsrep_cluster_name="openstack"
wsrep_cluster_address="gcomm://"
# Human-readable node name (non-unique). Hostname by default.
#wsrep_node_name=
# Base replication <address|hostname>[:port] of the node.
# The values supplied will be used as defaults for state transfer receiving,
# listening ports and so on. Default: address of the first network interface.
wsrep_node_address=10.0.176.3
# Address for incoming client connections. Autodetect by default.
#wsrep_node_incoming_address=
# How many threads will process writesets from other nodes
wsrep_slave_threads=2
# 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
# 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
# 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
wsrep_sst_method=mysqldump
# 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=10.0.176.3:3307
# 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=wsrep_sst:password
# Desired SST donor name.
#wsrep_sst_donor=
# Protocol version to use
# wsrep_protocol_version=
Hi
Config follows:
# This file contains wsrep-related mysqld options. It should be included address
# in the main MySQL configuration file.
#
# Options that need to be customized:
# - wsrep_provider
# - wsrep_cluster_
# - wsrep_sst_auth
# The rest of defaults should work out of the box.
##
## mysqld options _MANDATORY_ for correct opration of the cluster
##
[mysqld]
# (This must be substituted by wsrep_format)
binlog_format=ROW
# Currently only InnoDB storage engine is supported storage- engine= innodb
default-
# to avoid issues with 'bulk mode inserts' using autoinc autoinc_ lock_mode= 2
innodb_
# This is a must for paralell applying locks_unsafe_ for_binlog= 1
innodb_
#Try to fix futex loop thread_ concurrency = 32
innodb_
# Query Cache is not supported with wsrep
query_cache_size=0
query_cache_type=0
# Override bind-address 10.0.176. 3
# In some systems bind-address defaults to 127.0.0.1, and with mysqldump SST
# it will have (most likely) disastrous consequences on donor node
bind-address=
port=3307
##
## WSREP options
##
# Full path to wsrep provider library or 'none' /usr/lib/ galera/ libgalera_ smm.so
wsrep_provider=
# Provider specific configuration options
# See http:// www.codership. com/wiki/ doku.php? id=faq
wsrep_provider_ options= "pc.ignore_ sb = no;ist. recv_addr= 10.0.176. 3;gmcast. listen_ addr=tcp: //10.0. 176.3:4567"
# Logical cluster name. Should be the same for all nodes. name="openstack " cluster_ address= "gcomm: //"
wsrep_cluster_
wsrep_
# Human-readable node name (non-unique). Hostname by default.
#wsrep_node_name=
# Base replication <address| hostname> [:port] of the node. address= 10.0.176. 3
# The values supplied will be used as defaults for state transfer receiving,
# listening ports and so on. Default: address of the first network interface.
wsrep_node_
# Address for incoming client connections. Autodetect by default. node_incoming_ address=
#wsrep_
# How many threads will process writesets from other nodes threads= 2
wsrep_slave_
# DBUG options for wsrep provider
#wsrep_dbug_option
# Generate fake primary keys for non-PK tables (required for multi-master nonPK=1
# and parallel applying operation)
wsrep_certify_
# Maximum number of rows in write set ws_rows= 131072
wsrep_max_
# Maximum size of write set ws_size= 1073741824
wsrep_max_
# to enable debug level logging, set this to 1
wsrep_debug=0
# convert locking sessions into transactions LOCK_to_ trx=0
wsrep_convert_
# how many times to retry deadlocked autocommits autocommit= 1
wsrep_retry_
# change auto_increment_ increment and auto_increment_ offset automatically increment_ control= 1
wsrep_auto_
# retry autoinc insert, which failed for duplicate key error 282555_ workaround= 0
wsrep_drupal_
# enable "strictly synchronous" semantics for read operations reads=0
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 method= mysqldump
wsrep_sst_
# Address on THIS node to receive SST at. DON'T SET IT TO DONOR ADDRESS!!! receive_ address= 10.0.176. 3:3307
# (SST method dependent. Defaults to the first IP of the first interface)
wsrep_sst_
# SST authentication string. This will be used to send SST to joining nodes. auth=wsrep_ sst:password
# 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 version=
# wsrep_protocol_