Does Fivetran Support Blue/Green Deployments for MariaDB?

Question

Does Fivetran support blue/green deployments for MariaDB?

Environment

All MariaDB connectors

Answer

Yes, Fivetran supports blue/green deployments for MariaDB, such as those offered by Amazon RDS.

In a blue/green deployment, a production database environment (blue) maintains an up-to-date copy of its data in a separate staging environment (green). When required, the green environment is promoted to production and begins serving production traffic.

During switchover, your infrastructure may briefly drop existing database connections and prevent new connections. If this occurs while a sync is in progress, you may experience a temporary sync failure. The connector automatically attempts to reconnect and resume syncing. You may pause the connection during this time if desired; it is optional.

After switchover, the Fivetran connector resumes incremental syncing from its last stored replication checkpoint on the promoted environment. Whether a historical re-sync is required depends on how that checkpoint is stored, which is determined by your connection's incremental sync method.

Fivetran Teleport Sync

If you are using the Fivetran Teleport Sync incremental sync method, no additional action is required before switchover. After switchover, Fivetran resumes incremental syncing on the promoted environment without requiring a historical re-sync, provided the promoted environment contains the same data.

Binary log

If you are using the binary log incremental sync method, Fivetran tracks replication progress using GTIDs when they are available. Because GTIDs are globally unique and consistent across instances in a deployment, a GTID-based checkpoint can be resolved on the promoted environment after a blue/green switchover, whereas a checkpoint based on a binary log file and position cannot.

To avoid a historical re-sync, verify that Fivetran is using GTID-based checkpoints before switchover by confirming the GTID Cursor field in the Setup tab of your Connection details page shows Enabled. After a switchover, Fivetran automatically resumes incremental syncing on the promoted environment using the GTID-based checkpoint without requiring a historical re-sync.