# 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
# 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=0.0.0.0
##
## WSREP options
##
# Enable wsrep
wsrep_on=1
# Full path to wsrep provider library or 'none'
wsrep_provider=none
# Provider specific configuration options
#wsrep_provider_options=
# Logical cluster name. Should be the same for all nodes.
wsrep_cluster_name="my_wsrep_cluster"
# Group communication system handle
#wsrep_cluster_address="dummy://"
# 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=
# Address for incoming client connections. Autodetect by default.
#wsrep_node_incoming_address=
# How many threads will process writesets from other nodes
wsrep_slave_threads=1
# 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=0
# Maximum size of write set
wsrep_max_ws_size=2147483647
# 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=rsync
# Address which donor should send State Snapshot to.
# Should be the address of THIS node. 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:
# Desired SST donor name.
#wsrep_sst_donor=
# Reject client queries when donating SST (false)
#wsrep_sst_donor_rejects_queries=0
# Protocol version to use
# wsrep_protocol_version=
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| charsets | Folder | 0755 |
|
|
| czech | Folder | 0755 |
|
|
| danish | Folder | 0755 |
|
|
| dutch | Folder | 0755 |
|
|
| english | Folder | 0755 |
|
|
| estonian | Folder | 0755 |
|
|
| french | Folder | 0755 |
|
|
| german | Folder | 0755 |
|
|
| greek | Folder | 0755 |
|
|
| hindi | Folder | 0755 |
|
|
| hungarian | Folder | 0755 |
|
|
| italian | Folder | 0755 |
|
|
| japanese | Folder | 0755 |
|
|
| korean | Folder | 0755 |
|
|
| norwegian | Folder | 0755 |
|
|
| norwegian-ny | Folder | 0755 |
|
|
| policy | Folder | 0755 |
|
|
| polish | Folder | 0755 |
|
|
| portuguese | Folder | 0755 |
|
|
| romanian | Folder | 0755 |
|
|
| russian | Folder | 0755 |
|
|
| serbian | Folder | 0755 |
|
|
| slovak | Folder | 0755 |
|
|
| spanish | Folder | 0755 |
|
|
| swedish | Folder | 0755 |
|
|
| systemd | Folder | 0755 |
|
|
| ukrainian | Folder | 0755 |
|
|
| binary-configure | File | 1.13 KB | 0755 |
|
| errmsg-utf8.txt | File | 532.62 KB | 0644 |
|
| fill_help_tables.sql | File | 2 MB | 0644 |
|
| install_spider.sql | File | 22.77 KB | 0644 |
|
| magic | File | 1.3 KB | 0644 |
|
| maria_add_gis_sp.sql | File | 1.65 KB | 0644 |
|
| maria_add_gis_sp_bootstrap.sql | File | 1.63 KB | 0644 |
|
| mysql-log-rotate | File | 892 B | 0755 |
|
| mysql.server | File | 11.9 KB | 0755 |
|
| mysql_performance_tables.sql | File | 1.91 KB | 0644 |
|
| mysql_system_tables.sql | File | 28.31 KB | 0644 |
|
| mysql_system_tables_data.sql | File | 3.56 KB | 0644 |
|
| mysql_test_data_timezone.sql | File | 10.17 KB | 0644 |
|
| mysql_test_db.sql | File | 1.63 KB | 0644 |
|
| mysqld_multi.server | File | 1.53 KB | 0755 |
|
| wsrep.cnf | File | 3.39 KB | 0644 |
|
| wsrep_notify | File | 4.8 KB | 0755 |
|