Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Amazon Aurora MySQL after blue-green deployment is broken

Completed
Damian Kleczko User
  • Edited

Hello,

Some time ago AWS introduced feature that is called blue-green deployment. We can migrate/update database or change schema without almost any downtime. But in fivetran connector such switchover always ends with error: "Full re-sync needed due to binary log failure". It require to do resyncing all data that causes cpu spikes and for large databases takes a lot of time. 

AC: 

- we don't have to do full resync after aurora mysql blue-green deployment and switchover.

- Connector is not broken after switchover

Thank you in advance for taking this improvement into consideration

Br

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Official comment
    Valentin Kulichenko Fivetranner

    MySQL blue/green deployments are fully supported with GTID mode: https://fivetran.com/docs/connectors/databases/mysql/troubleshooting/blue-green-deployments

    Thanks,
    Val Kulichenko, Fivetran Product Team

  • Rean Fivetranner
    • Edited

    Hi Damian,

    Thank you so much for taking the time to share this request — we really appreciate the clear explanation and context.

    You're absolutely right that AWS Aurora MySQL’s blue-green deployment feature is designed to enable seamless switchovers with minimal downtime. We understand how frustrating it can be when a full re-sync is triggered during this process, especially with large datasets.

    Today, our connector interprets the switchover as a break in the binary log stream, which unfortunately leads to the “full re-sync” behavior you’ve encountered. This is definitely something we’d like to improve.

    To help us better evaluate how we might address this, could you share a bit more detail about:

    • The version of Aurora MySQL you're running.

    • How you're managing the switchover.

    • How often you expect to run blue-green switchovers

    This extra context helps us better understand your use case and inform our internal discussions.

    We’ve added your request to our product backlog. While I can’t promise an immediate solution, we’ll definitely take this into account as we plan future enhancements.

    Thanks again for surfacing this — please don’t hesitate to reach out if you have more to add or if anything changes on your end.

    Best,
    Rean

  • Ramki Rajendran User

    Any update on this feature?