search

osheroff / mysql-binlog-connector-java

MySQL Binary Log connector
666 stars 163 forks source link

MySQL 8.4 removed "Show master status" SQL command #147

Open alejandrosanchezcabana opened 3 months ago

alejandrosanchezcabana commented 3 months ago

https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html

According to the MySQL release notes for MySQL 8.4 they just removed a bunch of SQL commands

SQL statements removed. The following SQL statements have been removed (replacements in brackets): START SLAVE (START REPLICA); STOP SLAVE (STOP REPLICA); SHOW SLAVE STATUS (SHOW REPLICA STATUS); SHOW SLAVE HOSTS (SHOW REPLICAS); RESET SLAVE (RESET REPLICA); CHANGE MASTER TO (CHANGE REPLICATION SOURCE TO); RESET MASTER (RESET BINARY LOGS AND GTIDS); SHOW MASTER STATUS (SHOW BINARY LOG STATUS); PURGE MASTER LOGS (PURGE BINARY LOGS); and SHOW MASTER LOGS (SHOW BINARY LOGS).

The statements just listed have also been removed from all MySQL test programs and files, and elsewhere, where used internally.

That leads to com.github.shyiko.mysql.binlog.network.ServerException: 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 while trying to initialize

xcp19870906 commented 2 months ago

Urgent need MySQL 8.4 update