Implementing strong cross-platform resiliency in agile environments with logical replication
October 21–24
Level: Intermediate
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 allow deployments only during 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 schema changes are not replicated.
