POC - logical replication
Since the database decomposition, our traffic got split and our database clusters have a lower TPS in each of them. This high TPS was generating an high WAL volume that was a blocker to use logical replication.
Since the scenario changed, we can re-evaluate logical replication in our current datasets.
Please document all the tests, and generate a runbook how to enable logical replication.
Acceptance criteria:
-
In benchmarking execute the test to verify if with simulated traffic from production logical replication working properly. -
If yes create a runbook that will be used for staging.
Edited by Jose Finotto