Unleash on multi sites : DB replication

[labou77]

Dear Unleash community,
We are running 2 production sites on Cloud : 1 primary (active), 1 secondary with is a duplicate of the primary and which is only activated if primary crashes.
As Unleash has one instance on each site, what are the DB tables I need to replicate between my 2 sites? I try not to replicate everything to save cost. Do I need to replicate the migration table as well or not?

[chriswk]

Hi @labou77 - I think you should not need to replicate the migration table, Unleash runs migrations at startup, so running the same version in both sites, would mean you already have the exact same migration table.

For replication, you might not need the tables prefixed with stat_ nor client_metrics, they're only used for statistics and information about SDKs connected.
login_history and login_events can probably also be ignored, there really aren't any login_history on your standby instance.

Other than that, we have not run Unleash this way ourselves, so I'm sorry I can't help you further.