sql_log_bin
Topics on This Page:
If set to 0 (1 is the default), no logging to the binary log is done for the client. Only clients with the SUPER privilege can update this variable. Can have unintended consequences if set globally, see SET SQL_LOG_BIN. Starting MariaDB 10.1.7, this variable does not affect the replication of events in a Galera cluster.
See also: System Variables in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS
DETAILS
PARAMETERS
Command-line |
Not Supported |
Configuration file |
Not Supported |
Dynamic |
Yes |
Scope |
Global, Session |
Data Type |
BOOLEAN (OFF, ON) |
Default Value |
ON |
SKYSQL
Cloud |
SkySQL Topology |
ES Ver |
Default |
---|---|---|---|
AWS |
HA (Primary/Replica) |
10.4 |
ON |
AWS |
HA (Primary/Replica) |
10.5 |
ON |
AWS |
Transactional Standalone |
10.4 |
ON |
AWS |
Transactional Standalone |
10.5 |
ON |
AWS |
Distributed Transactions |
10.5 |
ON |
GCP |
ColumnStore |
10.5 |
ON |
GCP |
ColumnStore Multi |
10.5 |
ON |
GCP |
Galera |
10.4 |
ON |
GCP |
Galera |
10.5 |
ON |
GCP |
HA (Primary/Replica) |
10.4 |
ON |
GCP |
HA (Primary/Replica) |
10.5 |
ON |
GCP |
HTAP |
10.5 |
ON |
GCP |
Transactional Standalone |
10.4 |
ON |
GCP |
Transactional Standalone |
10.5 |
ON |
GCP |
Distributed Transactions |
10.5 |
ON |
See MariaDB SkySQL documentation to learn more about the MariaDB SkySQL database as a service.
CHANGE HISTORY
Release Series |
History |
---|---|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.
Information specific to MariaDB SkySQL can be found on the sql_log_bin page in the SkySQL Documentation.