Aurora MySQL as Source

Capture

Fivetran HVR allows you to capture changes from an Aurora MySQL database. This section describes configuration requirements for capturing changes from the Aurora MySQL database. For the list of supported Aurora MySQL versions from which HVR can capture changes, see Capture changes from location in Capabilities.

Capture Methods

HVR supports only the following method for capturing (Capture) changes from Aurora MySQL database:

Binary Logs via SQL

In this capture method (Capture_Method=SQL), HVR captures changes over an SQL connection. The benefit of this capture method is the ability to run with minimal OS and database privileges.

Grants for Capture

To capture changes from Aurora MySQL, the database User requires the following grants:

grant replication client on *.* to 'username'@'%' ;

grant replication slave on *.* to 'username'@'%' ;

grant select on *.* to 'username'@'%' ;

Configuration for Binary Logging

In Aurora MySQL, the transaction updates are recorded in the binary logs. For HVR to capture changes, the binary logging should be configured in the Aurora MySQL database.

1. To enable binary logging, perform the steps mentioned in Amazon documentation - How do I enable binary logging for Amazon Aurora for MySQL?

   While performing the steps to enable binary logging, the following parameters should be defined:

   • binlog_format=ROW - to set the binary logging format.
   • binlog_checksum=CRC32 - to enable writing a checksum for each event in the binary log.

2. The cluster should be restarted after enabling the binary logging. The replication will begin only after restarting the cluster.

Compare and Refresh from Aurora MySQL

HVR allows you to perform only Compare and Refresh from Aurora MySQL database (without using Capture). This section describes the configuration requirements for performing only Compare and Refresh from Aurora MySQL database.

Grants for Compare and Refresh from Aurora MySQL

This section lists the grants required for performing only Compare and Refresh from Aurora MySQL database.

To read from an Aurora MySQL database, the HVR database User must be granted the following privilege: shell grant select on table_name to username;