Why PostgreSQL High Availability Matters and How to Achieve It

Re:Why PostgreSQL High Availability Matters and How to Achie... by conqrr on Wednesday June 14, 2023 @12:36PM (#36328495)

Very Interesting. Glossing over the article, it states HA within a Region. Curious if anyone is successful in running any Database with multi-region HA? How are you doing it?

[ Parent | on HN ]

Re:Why PostgreSQL High Availability Matters and How to Achie... by chzblck on Wednesday June 14, 2023 @12:43PM (#36328644)

There's another article from them that covers it https://www.yugabyte.com/blog/exploring-multi-region-databas...

[ Parent | on HN ]

Re:Why PostgreSQL High Availability Matters and How to Achie... by audioheavy on Wednesday June 14, 2023 @01:33PM (#36329417)

Fauna can do multi-region HA, across clouds, serverless, with transparent sharding and replication. We get plenty of people struggling with not being able to do low-latency, performant, strict serializability distributed writes. It is designed to be a turnkey hosted solution. https://dev.to/luiseduardocolon/fauna-deep-dive-architecting... - Luis

[ Parent | on HN ]

Re:Why PostgreSQL High Availability Matters and How to Achie... by electroly on Wednesday June 14, 2023 @02:37PM (#36330536)

In SQL Server you can use a multi-subnet failover cluster.

https://learn.microsoft.com/en-us/sql/sql-server/failover-cl...

[ Parent | on HN ]

Re:Why PostgreSQL High Availability Matters and How to Achie... by bob1029 on Wednesday June 14, 2023 @02:58PM (#36330849)

We are going down the path of using Azure SQL Hyperscale to address availability concerns:

https://learn.microsoft.com/en-us/azure/azure-sql/database/s...

[ Parent | on HN ]