wsrep_notify_cmd

Overview

Command to execute upon changes in node state or cluster membership.

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

USAGE

DETAILS

Cluster Nodes track changes in cluster membership and their own states. Whenever changes occur, such as when nodes become synchronized with the cluster, join, send or receive State Snapshot Transfers (SST), the node calls a notification script. The node passes to the notification script information regarding its current state and the change.

This system variable specifies the path to the script the node executes.

SYNONYMS

SCHEMA

PARAMETERS

Command-line

--wsrep_notify_cmd=arg

Configuration file

Supported

Dynamic

No

Scope

Global

Data Type

VARCHAR

Product Default Value

"" (an empty string)

SKYSQL

PRIVILEGES

EXAMPLES

Configuration

Set the notification script using the options file:

[mariadb]
wsrep_notify_cmd=/usr/bin/example_cluster_notification.sh

Show Configuration

To view the current configuration, use the SHOW VARIABLES statement:

SHOW VARIABLES LIKE "wsrep_notify_cmd";

+------------------+------------------------------------------+
| Variable_name    | Value                                    |
+------------------+------------------------------------------+
| wsrep_notify_cmd | /usr/bin/example_cluster_notification.sh |
+------------------+------------------------------------------+

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

  • Dynamic changed in MariaDB Enterprise Server 10.5.9-6 from Yes to No

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

  • Dynamic changed in MariaDB Community Server 10.5.9 from Yes to No

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

  • Dynamic changed in MariaDB Enterprise Server 10.4.18-11 from Yes to No

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

  • Dynamic changed in MariaDB Community Server 10.4.18 from Yes to No

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

  • Dynamic changed in MariaDB Enterprise Server 10.3.28-11 from Yes to No

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

  • Dynamic changed in MariaDB Community Server 10.3.28 from Yes to No

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

  • Dynamic changed in MariaDB Enterprise Server 10.2.37-11 from Yes to No

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

  • Dynamic changed in MariaDB Community Server 10.2.37 from Yes to No

EXTERNAL REFERENCES