question

praveenkg avatar image
praveenkg asked Erick Ramirez answered

How can we achieve automatic failover to another region with Astra DB?

I wanted to know how we can achieve automatic failover to second region with Astra DB multi region set up in case primary region cluster is not available? I know we can configure this in DSE, looking at similar configuration or approach in Astra DB.

astra dbload balancing
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

smadhavan avatar image
smadhavan answered smadhavan edited

@praveenkg it can be achieved using the same fashion how you're achieving it today with DataStax Enterprise (DSE) cluster.

I am assuming your app is deployed similar to the below with DC1 and DC2 being Astra DB regions.

1654805941898.png


Other useful resources are available here,

I hope that helps!


1654805941898.png (81.9 KiB)
Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Erick Ramirez avatar image
Erick Ramirez answered

It is not possible to do an automatic failover at the application layer. It requires manual intervention since you need to use a different secure connect bundle -- each bundle is encoded with a specific region's contact points.

In any case, most production environments deploy app instances in the same regions as the Cassandra cluster for lowest latency and maximum performance. Our recommendation is to perform the failover at the infrastructure layer meaning that you should divert users to the other region. The simple reason for this is that if the database cluster is unavailable in one region, it is almost always due to a region-wide service disruption/outage which means that the app instances hosted in the same region would be unavailable as well.

For example if "Region1" is unavailable for whatever reason, your front-end web load balancers should divert all users to "Region2". Cheers!

Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.