REDROOM

Navigation

Breadcrumbs

/ / usr / share / mysql

Create

Create File | Create Folder | Upload Files | Run Command

Preview: wsrep.cnf Size: 3.39 KB

//usr/share/mysql/wsrep.cnf

# 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=

Directory Contents

Dirs: 30 × Files: 18

Sort:

Enable drag-to-move

Name	Size	Perms	Modified	Actions
bulgarian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
charsets DIR	-	drwxr-xr-x	2026-02-05 23:02:08	Edit Download recursive recursive
chinese DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
czech DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
danish DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
dutch DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
english DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
estonian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
french DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
georgian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
german DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
greek DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
hindi DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
hungarian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
italian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
japanese DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
korean DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
norwegian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
norwegian-ny DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
policy DIR	-	drwxr-xr-x	2026-01-31 17:44:55	Edit Download recursive recursive
polish DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
portuguese DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
romanian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
russian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
serbian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
slovak DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
spanish DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
swedish DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
systemd DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
ukrainian DIR	-	drwxr-xr-x	2026-02-05 23:02:17	Edit Download recursive recursive
binary-configure	1.13 KB	lrwxr-xr-x	2026-01-31 17:15:45	Edit Download recursive recursive
errmsg-utf8.txt	810.92 KB	lrw-r--r--	2026-01-31 10:47:55	Edit Download recursive recursive
fill_help_tables.sql	2.04 MB	lrw-r--r--	2026-01-31 10:47:55	Edit Download recursive recursive
magic	1.44 KB	lrw-r--r--	2026-01-31 10:47:56	Edit Download recursive recursive
mariadb.logrotate	1.82 KB	lrw-r--r--	2026-01-31 17:15:45	Edit Download recursive recursive
maria_add_gis_sp.sql	1.67 KB	lrw-r--r--	2026-01-31 17:15:44	Edit Download recursive recursive
maria_add_gis_sp_bootstrap.sql	1.64 KB	lrw-r--r--	2026-01-31 17:15:44	Edit Download recursive recursive
mini-benchmark	9.37 KB	lrwxr-xr-x	2026-01-31 17:15:45	Edit Download recursive recursive
mysql.server	12.02 KB	lrwxr-xr-x	2026-01-31 17:15:45	Edit Download recursive recursive
mysqld_multi.server	1.53 KB	lrwxr-xr-x	2026-01-31 17:15:45	Edit Download recursive recursive
mysql_performance_tables.sql	1.91 KB	lrw-r--r--	2026-01-31 10:47:55	Edit Download recursive recursive
mysql_system_tables.sql	29.86 KB	lrw-r--r--	2026-01-31 10:47:55	Edit Download recursive recursive
mysql_system_tables_data.sql	3.25 KB	lrw-r--r--	2026-01-31 10:47:55	Edit Download recursive recursive
mysql_sys_schema.sql	604.96 KB	lrw-r--r--	2026-01-31 17:15:45	Edit Download recursive recursive
mysql_test_data_timezone.sql	10.17 KB	lrw-r--r--	2026-01-31 10:47:55	Edit Download recursive recursive
mysql_test_db.sql	1.73 KB	lrw-r--r--	2026-01-31 10:47:55	Edit Download recursive recursive
wsrep.cnf	3.39 KB	lrw-r--r--	2026-01-31 17:15:45	Edit Download recursive recursive
wsrep_notify	4.86 KB	lrwxr-xr-x	2026-01-31 17:15:45	Edit Download recursive recursive