Details
Description
The problem it's we can have a working configuration but mysqld refuse to start and it's should not because Galera is off.
oct. 09 14:15:02 hb03-mariatac01-new mysqld[11737]: 2017-10-09 14:15:02 139748708274752 [ERROR] WSREP: Only binlog_format = 'ROW' is currently supported. Configured value: 'MIXED'. Please adjust your configuratio |
with WSREP_ON = off
I am agree if WSREP_ON = ON but with OFF it's should not bklock the start of MySQL server.
Mixed format works just fine without Galera:
MariaDB [test]> select @@log_bin, @@binlog_format, @@wsrep_on, @@version;
+-----------+-----------------+------------+--------------------+
| @@log_bin | @@binlog_format | @@wsrep_on | @@version |
+-----------+-----------------+------------+--------------------+
| 1 | MIXED | 0 | 10.2.9-MariaDB-log |
+-----------+-----------------+------------+--------------------+
1 row in set (0.00 sec)
Is it possible that you have wsrep_provider set in your configuration, even though wsrep_on is turned off?