mysqlutilities does not work with MySQL 8.0

[erolatreston]

Specifically, mysqlfailover does not work with MySQL 8.0. It immediately fails with the following error

# Discovering slaves for master at <master-ip>:3306
# Discovering slave at <slave-1-ip>:3306
# Found slave: <slave-1-ip>:3306
# Discovering slave at <slave-2-ip>:3306
# Found slave: <slave-2-ip>:3306
# Checking privileges.
ERROR: Query failed. 1694 (HY000): Cannot modify @@session.sql_log_bin inside a transaction

[erolatreston]

I narrowed this problem to the SHOW DATABASES statement. In MySQL 8.0, executing the SHOW DATABASES statement somehow starts a transaction. This later prevents the SET SQL_LOG_BIN=0 statement from executing successfully.

mysql> SET SQL_LOG_BIN=0;
Query OK, 0 rows affected (0.00 sec)

mysql> SET SQL_LOG_BIN=1;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

mysql> SET SQL_LOG_BIN=0;
ERROR 1694 (HY000): Cannot modify @@session.sql_log_bin inside a transaction