Implementing strong cross-platform resiliency in agile environments with logical replication
-
Data platform architect and long-term Postgres user.
Resiliency means that data of critical applications are not lost even in cases of extended and complete downtime of infrastructure providers. In particular, we have to guarantee that no more than 15 minutes worth of data are lost in such a scenario. The issue is exacerbated by the fact that applications may release schema changes at any point in time, without the possibility to enforce release windows. The obvious solution - physical replication - is not possible because it is not supported by the infrastructure provider. In this talk we show how logical replication in Postgres can be used to implement the required level of resiliency and how we deal with the fact that DDL-statements are not replicated.
