Re: Replication and Switchover

[Sam Stearns <sam.stearns@xxxxxxx>]

Ah.  Got it.  Makes sense.  Thanks, Christoph!

Sam

On Fri, Jun 6, 2025 at 8:09 AM Christoph Berg <myon@xxxxxxxxxx> wrote:

Re: Sam Stearns > We would like to switchover the database that is ready now so we can start > performing load testing against it. Is it possible to switchover one > database in a cluster while not switching over the other? Create a

ZjQcmQRYFpfptBannerStart

This Message Is From an Untrusted Sender

You have not previously corresponded with this sender.

 

ZjQcmQRYFpfptBannerEnd

Re: Sam Stearns
> We would like to switchover the database that is ready now so we can start
> performing load testing against it.  Is it possible to switchover one
> database in a cluster while not switching over the other?

Create a second database cluster, and move one of the databases into
that cluster.

"Move" is either dump-restore, or a full restore of the old cluster
and dropping the other database.

Christoph

--

Samuel Stearns
Team Lead - Database
c: 971 762 6879 | o: 971 762 6879 | DAT.com