mysql> set global wsrep_desync=ON;
Query OK, 0 rows affected, 2 warnings (0.02 sec)
mysql> show warnings;
+---------+------+----------------------------------------+
| Level | Code | Message |
+---------+------+----------------------------------------+
| Warning | 1292 | Truncated incorrect DOUBLE value: 'ON' |
| Warning | 1231 | 'wsrep_desync' is already OFF. |
+---------+------+----------------------------------------+
2 rows in set (0.00 sec)
mysql> show global variables like '%desync%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wsrep_desync | ON |
+---------------+-------+
1 row in set (0.01 sec)
............
...........
mysql> set global wsrep_desync=OFF;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> set global wsrep_desync=ON;
Query OK, 0 rows affected, 2 warnings (0.02 sec)
mysql> show warnings; ---+--- ---+--- ------- ------- ------- ------- ------- --+ ---+--- ---+--- ------- ------- ------- ------- ------- --+ ---+--- ---+--- ------- ------- ------- ------- ------- --+
+------
| Level | Code | Message |
+------
| Warning | 1292 | Truncated incorrect DOUBLE value: 'ON' |
| Warning | 1231 | 'wsrep_desync' is already OFF. |
+------
2 rows in set (0.00 sec)
mysql> show global variables like '%desync%'; ------- --+---- ---+ ------- --+---- ---+ ------- --+---- ---+
+------
| Variable_name | Value |
+------
| wsrep_desync | ON |
+------
1 row in set (0.01 sec)
............
...........
mysql> set global wsrep_desync=OFF;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> show warnings ---+--- ---+--- ------- ------- ------- ------- ------- ---+ ---+--- ---+--- ------- ------- ------- ------- ------- ---+ ---+--- ---+--- ------- ------- ------- ------- ------- ---+
-> ;
+------
| Level | Code | Message |
+------
| Warning | 1292 | Truncated incorrect DOUBLE value: 'OFF' |
+------
1 row in set (0.00 sec)