proxysql MySQL Binlog Reader is not compatible with MySQL 8.4+

[ParveezBaig]

proxysql MySQL Binlog Reader fails while initializing for MySQL 8.4+ version. Its because of removal of master/slave terminology commands in MySQL 8.4. SHOW BINARY LOG STATUS shall be used instead of SHOW MASTER STATUS. Ensure that all relevant commands have been updated.

Starting ProxySQL MySQL Binlog
Sucessfully started
Angel process started ProxySQL MySQL Binlog process 11266
2024-10-25 11:12:03 [INFO] proxysql_binlog_reader version 2.1-5-g7f50bd0
2024-10-25 11:12:03 [INFO] Initializing client...
Error in initializing slave: mysql_query() 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 STATUS' at line 1 : 1064 : [SHOW MASTER STATUS]
2024-10-25 11:12:03 [INFO] Exiting...
Shutdown angel process