Sample Header Ad - 728x90

Can I create a Geo Replica of a Named Replica?

0 votes
1 answer
43 views
For clarity, we have two databases on a server in a given region. One database is the primary for the read/write workload, and one is a replica for the read-only workload. I'm trying to set up a failover which will work for both workloads. So I'm trying to get the primary, as well as its named replica, replicated over to the standby server. We're using Azure's hosted database (PaaS) service. We have a primary DB which handles our transactional workload. I created a Named Replica on the same server, to offload read-only workloads. I also created a Geo Replica of the primary DB which is hosted on a separate server in a different region. I created a failover group which can swap my server back and forth between regions. But now I'd like to have a Geo Replica of the Named Replica (the read-only DB on my primary server) so that when I go into failover mode, I can support both my transactional and read-only workloads. Is this possible? Seemingly, the only replica I can make is from the primary DB. I can't find any way to use the Named Replica as the base for a Geo Replica. Which leaves me in a catch-22. I can't create a second Geo Replicated database onto the failover server because there's already a database there by that name. I can't create a Named Replica onto the failover server because a Named Replica must be in the same region (which would be useless for failover purposes, anyway). See the screenshot. In a nutshell, I am trying to get a replicated database named test_read onto my server r8standby in the South Central datacenter, but I'm having trouble figuring out how to set this up. Is this at all possible? enter image description here
Asked by Yossi Geretz (359 rep)
May 13, 2024, 11:54 PM
Last activity: May 14, 2024, 10:33 PM