wsrep_cluster_name

Name for the cluster

See also: System Variables for MariaDB Enterprise Server 10.6, in 10.5 ES, and in 10.4 ES

DETAILS

This system variable specifies the logical name of the cluster. Every Cluster Node that connects to each other must have the same logical name in order to form a component or join the Primary Component.

PARAMETERS

Dynamic

Yes

Scope

Global

Data Type

VARCHAR

Default Value

my_wsrep_cluster

SKYSQL

Cloud

SkySQL Topology

ES Ver

Default

AWS

HA (Primary/Replica)

10.4

my_wsrep_cluster

AWS

HA (Primary/Replica)

10.5

my_wsrep_cluster

AWS

Transactional Standalone

10.4

my_wsrep_cluster

AWS

Transactional Standalone

10.5

my_wsrep_cluster

AWS

Distributed Transactions

10.5

Not present

GCP

ColumnStore

10.5

my_wsrep_cluster

GCP

ColumnStore Multi

10.5

my_wsrep_cluster

GCP

Galera

10.4

130b1e790ce941db9b8511f6959964d2

GCP

Galera

10.5

ff95f49314594c1b994a2ec11efa4799

GCP

HA (Primary/Replica)

10.4

my_wsrep_cluster

GCP

HA (Primary/Replica)

10.5

my_wsrep_cluster

GCP

HTAP

10.5

my_wsrep_cluster

GCP

Transactional Standalone

10.4

my_wsrep_cluster

GCP

Transactional Standalone

10.5

my_wsrep_cluster

GCP

Distributed Transactions

10.5

Not present

EXAMPLES

Configuration

Set the cluster name using an options file:

[mariadb]
wsrep_provider        = /usr/lib/galera/libgalera_smm.so
wsrep_cluster_name    = example_cluster
wsrep_cluster_address = gcomm://192.0.2.1,192.0.2.2,192.0.2.3

Show Configuration

To view the current cluster name, use the SHOW VARIABLES statement:

SHOW VARIABLES LIKE "wsrep_cluster_name";
+--------------------+-----------------+
| Variable_name      | Value           |
+--------------------+-----------------+
| wsrep_cluster_name | example_cluster |
+--------------------+-----------------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES