search

readysettech / readyset

Readyset is a MySQL and Postgres wire-compatible caching layer that sits in front of existing databases to speed up queries and horizontally scale read throughput. Under the hood, ReadySet caches the results of cached select statements and incrementally updates these results over time as the underlying data changes.
https://readyset.io
Other
4.54k stars 125 forks source link

Validate Support for MySQL 5.7 #1393

Closed altmannmarcelo closed 3 weeks ago

altmannmarcelo commented 1 month ago

Description

A lot of people are still using MySQL 5.7. We should check if we currently support MySQL 5.7.

Main area to check is around Snapshoting as LOCK INSTANCE FOR BACKUP is not available.

Change in user-visible behavior

Requires documentation change

altmannmarcelo commented 1 month ago

Another place to adjust:

const CHECKSUM_QUERY: &str = "SET @source_binlog_checksum='CRC32'";

This should be conditionally changed to master_binlog_checksum if we are in 5.7, same as we do for SHOW MASTER STATUS;