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