MySQL Agent for Gluesync: Features & Compatibility

Index

Core principles

This agent establishes a connection to MySQL via a built-in JDBC driver.

Change data capture

This agent implements the scraping of Bin log’s transaction logs by connecting to your master, slave or MaxScale instances depending on the desired configuration. To scrape the Bin log it connects to MySQL using a socket TCP connection.

Supported version

With this agent, you can target any version of MySQL, whether is Enterprise, Percona, AWS RDS, MaxScale instances or just the Community edition.

This agent’s version supports one master node with single server ID.

Change data capture

Works with MySQL starting from 5.5 and above, 8.4 included.

Q&A

I am connecting towards an AWS RDS instance, is it supported? Yes, it is. MySQL RDS instances are supported. Remember to enable SSL connection during agent’s setup phase. For AWS Aurora MySQL-compatible instances, you may want to use instead the MariaDB agent as it is the right choice for this scenario.

I have got MySQL running under a managed DBaaS offered from AWS | CGP | Azure | OCI | …, is it supported? Yes, they are. Just make sure you have enabled transaction logs - Bin log - redaction support.

Video Tutorial

Real time data integration between MySQL 8 to Snowflake 9.15