search

Altinn / altinn-platform

Altinn Platform infrastructure
6 stars 1 forks source link

Enable replication for PostgreSQL servers #499

Open ootneim opened 1 year ago

ootneim commented 1 year ago

Enable replication for PostgreSQL servers (tt02 and production) to another Azure region

Using PostgreSQL flexible replication to another region provides several benefits in terms of data availability, disaster recovery, and improved performance. Here are some reasons why you might choose to implement flexible replication to another region in PostgreSQL:

  1. High Availability: Replicating your PostgreSQL database to another region ensures that you have a standby copy of your data available in case of a regional outage or failure. If the primary region becomes unavailable, you can seamlessly switch to the replicated database in the secondary region, minimizing downtime and ensuring continuous availability of your application.

  2. Disaster Recovery: Replicating data to another region acts as a disaster recovery mechanism. In the event of a catastrophic failure or natural disaster affecting the primary region, you can failover to the replicated database in the secondary region. This allows you to recover your data and resume operations with minimal data loss and downtime.

  3. Geographic Redundancy: Replicating data to another region provides geographic redundancy. By maintaining copies of your data in multiple regions, you mitigate the risk of data loss due to localized incidents such as power outages, network failures, or regional disasters. Geographic redundancy enhances the overall resilience of your application.

  4. Improved Performance: Replicating your database to a region closer to your end-users can improve performance by reducing latency. By placing a replica in a region that is geographically closer to your users, you can reduce the network round-trip time and improve the responsiveness of your application.

  5. Scaling Read Workloads: Replication can also be used to offload read-heavy workloads from the primary database. By directing read queries to the replica in the secondary region, you can distribute the load and improve the overall scalability and performance of your application.

PostgreSQL Flexibleserver is not available in Norway West. Closest is Sweden Central.

annerisbakk commented 9 months ago

@ootneim er dette noe vi skal jobbe videre med?

ootneim commented 9 months ago

@annerisbakk Dette kommer nok en del senere. Om vi ønsker replikering utenfor Oslo. Jeg legger denne i backloggen.