search

risingwavelabs / risingwave

Best-in-class stream processing, analytics, and management. Perform continuous analytics, or build event-driven applications, real-time ETL pipelines, and feature stores in minutes. Unified streaming and batch. PostgreSQL compatible.
https://go.risingwave.com/slack
Apache License 2.0
6.98k stars 575 forks source link

CDC for MySQL 8.4 #16701

Open yuhao-su opened 5 months ago

yuhao-su commented 5 months ago

There are some changes in MySQL 8.4. For example SHOW MASTER STATUS, which is used for get the bin log position, does not exist.

cyliu0 commented 5 months ago

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

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).

cyliu0 commented 5 months ago

Now we can't create MySQL CDC shared source on MySQL 8.4 since the above MySQL changes.

StrikeW commented 5 months ago

SHOW MASTER STATUS is replaced by SHOW BINARY LOG STATUS https://dev.mysql.com/doc/refman/8.4/en/show-binary-log-status.html