Is it possible to migrate a tenant on Aurora Serverless v2 without downtime?

Question

Hello,

I'm trying to figure out if there is a way with Aurora Serverless v2 to migrate tenants from one db instance to another.

Say for example that I'm using "Aurora Serverless v2 - Postgres compatible" and that I have two clusters with one writer instance in each cluster. Then inside each writer I might have one schema per tenant.

After some time one of the tenants becomes noisy and might require to be moved to the other DB cluster. Would something like fast database clone help here? Is there some feature in AWS that would allow tenants to be moved without downtime or do I have to code it?

When I say "without downtime" it means that I should still be able to write into the schema while it's being moved.

Answer

The easiest way is to achieve this is using DMS (Database Migration Service) and choose your source and destination connections and define a Full Load + CDC(change data capture) job. In this case the migration becomes transparent and you can write to the source without any interruption and being assured that all the commits are being replicated to the destination.  The only downtime will be the time you switch the endpoints in your application.

Is it possible to migrate a tenant on Aurora Serverless v2 without downtime?

Contenuto pertinente