January 10, 2014 at 6:39 am
I'm going to be playing with this, this weekend, but thought I'd ask about it as well.
If I have two servers in an AO Group, can I have two instances of SQL on each server, each pair of instances as their own AO group? Presumably both groups would need to be on different ports, as well.
Maybe a better explanation of what I'm trying:
Server A has SQL Instance A and B
Server B has SQL Instance A and B
SQL instances A form an AO group A, listening on port 1433
SQL instances B form an AO group B, listening on port 1443
Server A is the AO Primary for AO group A
Server B is the AO Primary for AO group B
Possible? From my reading of the Technet there's nothing to indicate that this wouldn't work. Basically, I'd be looking to ensure that we don't have one server sitting around twiddling its thumbs, waiting for the primary to fail. The server I'm looking at doing this to has ~33 DBs that would be part of the AO group(s)
Related question: Can SSRS databases be part of an AO group? I lean towards the answer being yes, except for the RSTempDBs, as the DBs are Full Recovery.
Thanks all.
Jason
January 10, 2014 at 8:36 am
Hi Jason,
I've done a fair bit of tinkering with Availability Groups, mostly from the Virtual Labs at:
http://www.microsoft.com/en-us/sqlserver/learning-center/virtual-labs.aspx
I think what you are proposing is possible, although I haven't tried it... seems like it should work right? Any 2 instances can be joined in an Availability Group (assuming their host machines are part of the Windows Cluster)
Although... since you'll have multiple instances per machine, you'll have at least one NAMED instance (I'd probably make both Instance A and B NAMED for consistency). Because of this, you have to have separate ports (on each machine per instance) to listen on, but having the same port defined between machines will work as you described:
SQL instances A form an AO group A, listening on port 1433
SQL instances B form an AO group B, listening on port 1443
Each instance of SQL will have its Mirroring Endpoint, with it's own Port number assigned.
Good luck, seems feasible... but let us know if you run into problems.
Todd Carrier
MCITP - Database Administrator (SQL 2008)
MCSE: Data Platform (SQL 2012)
January 12, 2014 at 12:36 pm
jasona.work (1/10/2014)
I'm going to be playing with this, this weekend, but thought I'd ask about it as well.If I have two servers in an AO Group, can I have two instances of SQL on each server, each pair of instances as their own AO group?
Based on what you're planning and the way i'm reading it, No, they cannot.
jasona.work (1/10/2014)
Presumably both groups would need to be on different ports, as well.Maybe a better explanation of what I'm trying:
Server A has SQL Instance A and B
Server B has SQL Instance A and B
SQL instances A form an AO group A, listening on port 1433
SQL instances B form an AO group B, listening on port 1443
Server A is the AO Primary for AO group A
Server B is the AO Primary for AO group B
By group i'm assuming you mean instance?
Instance installation follows the same rules as always. One default instance, the remaining instances must be named and use separate port numbers.
jasona.work (1/10/2014)
Basically, I'd be looking to ensure that we don't have one server sitting around twiddling its thumbs, waiting for the primary to fail.
Guess what, that is exactly what a high availability solution is generally all about, unless of course you're using Oracle RAC! 😉
Todd Carrier (1/10/2014)
Any 2 instances can be joined in an Availability Group (assuming their host machines are part of the Windows Cluster)
Not entirely true, if the replicas\instances are on the same node then this violates the AlwaysOn group pre reqs. All replicas must be hosted on different nodes in the cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply