pxc_strict_mode
WARNING
Rule IDs: pxc_006
Overview
- Purpose
- Percona XtraDB Cluster SQL compatibility mode.
- Dynamic (MySQL 8.4 reference)
- Documented for PXC; may be changeable at runtime depending on version — verify in Percona XtraDB Cluster documentation.
- Default value
- See Percona docs for your release.
- Version and product notes
- Not in the Oracle MySQL 8.4 variable summary excerpt.
- Documentation
- Primary reference depends on product (MySQL, MariaDB, Percona, or OS documentation).
- Vendor documentation
What is checked
Rules that reference this variable, with their severity and what each rule detects:
- WARNING
pxc_006: Set pxc_strict_mode=ENFORCING or MASTER in production to prevent operations that are unsafe for Galera replication.
Tuning guidance
- Recommended actions:
- Set pxc_strict_mode=ENFORCING or MASTER in production to prevent operations that are unsafe for Galera replication.
- Trade-offs: Galera cluster settings affect write throughput, consistency, and failover behavior. Flow control protects slow nodes but can stall the entire cluster. SST method choice affects donor impact during node joins.
Example
SET GLOBAL pxc_strict_mode = 'ENFORCING'; -- See Percona XtraDB Cluster docs for mode options