mysql_ plugin is not compatible with mysql 8.4

[Narazaka]

Describe the bug

I configured mysql_ plugin and munin-node-configure --suggest says ...

mysql_                     | yes  | yes (bin_relay_log binlog_groupcommit commands connections files_tables innodb_bpool innodb_bpool_act innodb_insert_buf innodb_io innodb_io_pend innodb_log innodb_rows innodb_semaphores innodb_tnx myisam_indexes network_traffic qcache qcache_mem replication select_types slow sorts table_locks tmp_tables)

I tryed to run munin-run mysql_ and errored.

# /usr/bin/munin-run mysql_                                                                                                                                                                                                                                                                                                                    [/etc/munin]
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MASTER LOGS' at line 1 at /etc/munin/plugins/mysql_ line 1223.
Warning: the execution of 'munin-run' via 'systemd-run' returned an error. This may either be caused by a problem with the plugin to be executed or a failure of the 'systemd-run' wrapper. Details of the latter can be found via 'journalctl'.
[1]    133936 exit 11    /usr/bin/munin-run mysql_

I fixed line 1221 'SHOW BINARY LOGS'.

then

# /usr/bin/munin-run mysql_                                                                                                                                                                                                                                                                                                                    [/etc/munin]
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SLAVE STATUS' at line 1 at /etc/munin/plugins/mysql_ line 1243.
Warning: the execution of 'munin-run' via 'systemd-run' returned an error. This may either be caused by a problem with the plugin to be executed or a failure of the 'systemd-run' wrapper. Details of the latter can be found via 'journalctl'.
[1]    134328 exit 11    /usr/bin/munin-run mysql_

I fixed line 1242 'SHOW REPLICA STATUS'.

then

# /usr/bin/munin-run mysql_                                                                                                                                                                                                                                                                                                                    [/etc/munin]
Unknown graph  at /etc/munin/plugins/mysql_ line 1061.
Warning: the execution of 'munin-run' via 'systemd-run' returned an error. This may either be caused by a problem with the plugin to be executed or a failure of the 'systemd-run' wrapper. Details of the latter can be found via 'journalctl'.
[1]    135983 exit 11    /usr/bin/munin-run mysql_

To Reproduce
Steps to reproduce the behavior:

1. install mysql>=8.4 (I used percona-server 8.4.3_3-4 @ arch linux)
2. setup mysql_ plugin
3. /usr/bin/munin-run mysql_

Expected behavior
should execute mysql 8.4 compatible query

• SHOW MASTER LOGS -> SHOW BINARY LOGS
• SHOW SLAVE STATUS -> SHOW REPLICA STATUS

Desktop (please complete the following information):

• OS+Distribution Version: [Arch Linux (live updated)]
• Browser (if relevant) [Chrome]
• Munin Version [2.0.76]