1# This file contains wsrep-related mysqld options. It should be included 2# in the main MySQL configuration file. 3# 4# Options that need to be customized: 5# - wsrep_provider 6# - wsrep_cluster_address 7# - wsrep_sst_auth 8# The rest of defaults should work out of the box. 9 10## 11## mysqld options _MANDATORY_ for correct opration of the cluster 12## 13[mysqld] 14 15# (This must be substituted by wsrep_format) 16binlog_format=ROW 17 18# Currently only InnoDB storage engine is supported 19default-storage-engine=innodb 20 21# to avoid issues with 'bulk mode inserts' using autoinc 22innodb_autoinc_lock_mode=2 23 24# Override bind-address 25# In some systems bind-address defaults to 127.0.0.1, and with mysqldump SST 26# it will have (most likely) disastrous consequences on donor node 27bind-address=0.0.0.0 28 29## 30## WSREP options 31## 32 33# Enable wsrep 34wsrep_on=1 35 36# Full path to wsrep provider library or 'none' 37wsrep_provider=none 38 39# Provider specific configuration options 40#wsrep_provider_options= 41 42# Logical cluster name. Should be the same for all nodes. 43wsrep_cluster_name="my_wsrep_cluster" 44 45# Group communication system handle 46#wsrep_cluster_address="dummy://" 47 48# Human-readable node name (non-unique). Hostname by default. 49#wsrep_node_name= 50 51# Base replication <address|hostname>[:port] of the node. 52# The values supplied will be used as defaults for state transfer receiving, 53# listening ports and so on. Default: address of the first network interface. 54#wsrep_node_address= 55 56# Address for incoming client connections. Autodetect by default. 57#wsrep_node_incoming_address= 58 59# How many threads will process writesets from other nodes 60wsrep_slave_threads=1 61 62# DBUG options for wsrep provider 63#wsrep_dbug_option 64 65# Generate fake primary keys for non-PK tables (required for multi-master 66# and parallel applying operation) 67wsrep_certify_nonPK=1 68 69# Maximum number of rows in write set 70wsrep_max_ws_rows=0 71 72# Maximum size of write set 73wsrep_max_ws_size=2147483647 74 75# to enable debug level logging, set this to 1 76wsrep_debug=0 77 78# convert locking sessions into transactions 79wsrep_convert_LOCK_to_trx=0 80 81# how many times to retry deadlocked autocommits 82wsrep_retry_autocommit=1 83 84# change auto_increment_increment and auto_increment_offset automatically 85wsrep_auto_increment_control=1 86 87# retry autoinc insert, which failed for duplicate key error 88wsrep_drupal_282555_workaround=0 89 90# enable "strictly synchronous" semantics for read operations 91wsrep_causal_reads=0 92 93# Command to call when node status or cluster membership changes. 94# Will be passed all or some of the following options: 95# --status - new status of this node 96# --uuid - UUID of the cluster 97# --primary - whether the component is primary or not ("yes"/"no") 98# --members - comma-separated list of members 99# --index - index of this node in the list 100wsrep_notify_cmd= 101 102## 103## WSREP State Transfer options 104## 105 106# State Snapshot Transfer method 107wsrep_sst_method=rsync 108 109# Address which donor should send State Snapshot to. 110# Should be the address of THIS node. DON'T SET IT TO DONOR ADDRESS!!! 111# (SST method dependent. Defaults to the first IP of the first interface) 112#wsrep_sst_receive_address= 113 114# SST authentication string. This will be used to send SST to joining nodes. 115# Depends on SST method. For mysqldump method it is root:<root password> 116wsrep_sst_auth=root: 117 118# Desired SST donor name. 119#wsrep_sst_donor= 120 121# Reject client queries when donating SST (false) 122#wsrep_sst_donor_rejects_queries=0 123 124# Protocol version to use 125# wsrep_protocol_version= 126