February 9, 2024 at 6:54 pm
I currently have a setup where we have an Active/Passive Cluster Environment that also has a Disaster Recovery Secondary Availability Group. There is a need for another secondary replica to use the read-only functionality to reduce the workload on the Primary Replica. My main question here is I'm assuming I will have to have another server to have create the secondary replica on. I'm not sure it would be possible/wise to have the secondary replica on the Passive Cluster. This shop installed Active/Passive Clustering prior to utilizing Always on Availability Groups. Any recommendations would be greatly appreciated.
February 10, 2024 at 7:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
February 12, 2024 at 6:19 pm
It isn't clear from your description what you are asking. I assume by active/passive you mean an FCI (Failover Cluster Instance) where you have 2 or more nodes clustered with shared storage and an instance installed into the cluster.
And then - added to this cluster is a 3rd node in a DR site setup as an availability group.
But it gets confusing because you then state you have a Passive Cluster - but that would mean you then have 2 or more nodes configured as a separate FCI, but I don't think that is what you meant.
To add a read-only secondary you will need an additional node in the cluster. Because you already have an AG configured - then you also need to add all databases to that read-only instance.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply