1 # This file contains wsrep-related mysqld options. It should be included
2 # in the main MySQL configuration file.
4 # Options that need to be customized:
6 # - wsrep_cluster_address
8 # The rest of defaults should work out of the box.
11 ## mysqld options _MANDATORY_ for correct opration of the cluster
15 # (This must be substituted by wsrep_format)
18 # Currently only InnoDB storage engine is supported
19 default-storage-engine=innodb
21 # to avoid issues with 'bulk mode inserts' using autoinc
22 innodb_autoinc_lock_mode=2
24 # This is a must for paralell applying
25 innodb_locks_unsafe_for_binlog=1
27 # Query Cache is not supported with wsrep
31 # Override bind-address
32 # In some systems bind-address defaults to 127.0.0.1, and with mysqldump SST
33 # it will have (most likely) disastrous consequences on donor node
34 #bind-address={{ hostvars[inventory_hostname]['ansible_' + INTERNAL_INTERFACE].ipv4.address }}
35 bind-address={{ HA_VIP }}
41 # Full path to wsrep provider library or 'none'
42 wsrep_provider=/usr/lib/galera/libgalera_smm.so
44 # Provider specific configuration options
45 #wsrep_provider_options=
47 # Logical cluster name. Should be the same for all nodes.
48 wsrep_cluster_name="my_wsrep_cluster"
50 # Group communication system handle
51 wsrep_cluster_address=gcomm://{{ HA_CLUSTER[inventory_hostname] }}
53 # Human-readable node name (non-unique). Hostname by default.
56 # Base replication <address|hostname>[:port] of the node.
57 # The values supplied will be used as defaults for state transfer receiving,
58 # listening ports and so on. Default: address of the first network interface.
59 wsrep_node_address={{ hostvars[inventory_hostname]['ansible_' + INTERNAL_INTERFACE].ipv4.address }}
61 # Address for incoming client connections. Autodetect by default.
62 #wsrep_node_incoming_address=
64 # How many threads will process writesets from other nodes
67 # DBUG options for wsrep provider
70 # Generate fake primary keys for non-PK tables (required for multi-master
71 # and parallel applying operation)
74 # Maximum number of rows in write set
75 wsrep_max_ws_rows=131072
77 # Maximum size of write set
78 wsrep_max_ws_size=1073741824
80 # to enable debug level logging, set this to 1
83 # convert locking sessions into transactions
84 wsrep_convert_LOCK_to_trx=0
86 # how many times to retry deadlocked autocommits
87 wsrep_retry_autocommit=1
89 # change auto_increment_increment and auto_increment_offset automatically
90 wsrep_auto_increment_control=1
92 # retry autoinc insert, which failed for duplicate key error
93 wsrep_drupal_282555_workaround=0
95 # enable "strictly synchronous" semantics for read operations
98 # Command to call when node status or cluster membership changes.
99 # Will be passed all or some of the following options:
100 # --status - new status of this node
101 # --uuid - UUID of the cluster
102 # --primary - whether the component is primary or not ("yes"/"no")
103 # --members - comma-separated list of members
104 # --index - index of this node in the list
108 ## WSREP State Transfer options
111 # State Snapshot Transfer method
112 wsrep_sst_method=rsync
114 # Address on THIS node to receive SST at. DON'T SET IT TO DONOR ADDRESS!!!
115 # (SST method dependent. Defaults to the first IP of the first interface)
116 #wsrep_sst_receive_address=
118 # SST authentication string. This will be used to send SST to joining nodes.
119 # Depends on SST method. For mysqldump method it is root:<root password>
120 wsrep_sst_auth={{ WSREP_SST_USER }}:{{ WSREP_SST_PASS }}
122 # Desired SST donor name.
125 # Protocol version to use
126 # wsrep_protocol_version=