socket.ssl_reload

Overview

In 23.08 ES, 23.07 ES, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:

Not present

In 10.6 ES, 10.6 CS, 10.5 ES, 10.5 CS, 10.4 ES, 10.4 CS:

Reinitialize SSL context

The wsrep_provider_options system variable applies to MariaDB Enterprise Cluster, powered by Galera and to Galera Cluster available with MariaDB Community Server. This page relates specifically to the socket.ssl_reload wsrep_provider_options.

See also: wsrep Provider Options for MariaDB Enterprise Server 23.08, in 23.07 ES, in 10.6 ES, 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

Parameter used to dynamically reinitialize the Galera SSL context. This is most useful if you need to replace a certificate that is about to expire without restarting the server. You need to change the certificate and key files at the relevant paths defined by SSL variables.

Attribute

Value

Option Name

socket.ssl_reload

Default Value

"" (an empty string)

Dynamic

YES

Debug

NO

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

Display Current Value

wsrep_provider_options define optional settings the node passes to the wsrep provider.

To display current wsrep_provider_options values:

SHOW GLOBAL VARIABLES LIKE 'wsrep_provider_options';

The expected output will display the option and the value. Options with no default value, for example SSL options, will not be displayed in the output.

Set Dynamically

Changes made dynamically with SET GLOBAL are not durable and will be lost when the server is stopped. To be durable, changes must be set in the configuration file.

The socket.ssl_reload option can be set dynamically using the SET GLOBAL command. Setting wsrep_provider_options dynamically does not change the value of other wsrep_provider_options.

To set socket.ssl_reload dynamically:

SET GLOBAL wsrep_provider_options='socket.ssl_reload=1';

To dynamically set multiple options in a single statement:

SET GLOBAL wsrep_provider_options='socket.ssl_reload=1;cert.optimistic_pa=NO';

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.08 Enterprise

  • Not present.

23.07 Enterprise

  • Not present.

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

  • Removed in MariaDB Enterprise Server 10.6.9-5.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

  • Removed in MariaDB Community Server 10.6.11.

10.5 Enterprise

  • Added in MariaDB Enterprise Server 10.5.10-7.

  • Removed in MariaDB Enterprise Server 10.5.17-12.

10.5 Community

  • Added in MariaDB Community Server 10.5.10.

  • Removed in MariaDB Community Server 10.5.18.

10.4 Enterprise

  • Added in MariaDB Enterprise Server 10.4.19-12.

  • Removed in MariaDB Enterprise Server 10.4.26-17.

10.4 Community

  • Added in MariaDB Community Server 10.4.19.

  • Removed in MariaDB Community Server 10.4.27.

10.3 Enterprise

  • Not present.

10.3 Community

  • Not present.

10.2 Enterprise

  • Not present.

10.2 Community

  • Not present.

EXTERNAL REFERENCES