More than 1 Distributor database per instance?
-
I've read that you can only have 1 distribution database per instance. The problem I am running into with that design is that now my point of failure rests on the Distributor, and since you cannot mirror the distribution database - I am left with little else than some form of clustering. The issues in my environment are mostly network related concerns, so justifying an MSCS cluster (or some other 3rd party configuration) is not easily sold.
Is there any possibility to get 2 or more Distributors (distribution databases) to work in the same instance? Or is this just the way it is?
Many thanks in advance for any and all help on this...
-
You can only have one distribution database per instance.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
Hi Gail - thank you for the confirmation on this (I was the bad guy for a while due to this news to my management team), but do you have a recommendation for some form of redundancy for the distribution database other than Clustering? The only other thing I have thought of is to spin up yet another mirrored pair that get replicated to themselves from the main mirrored pair, but that is still going to require a distribution server for their replication (to keep the secondary one in sync).
I am working with a mixture of AWS and Rackspace servers where the servers at the top will be on Rackspace, and the distribution server is in AWS, along with the edge clients (Wed Edition SQL Server). It looks like this...
-
Just for additional clarity - the top tier of servers in Rackspace are the mirrored pair and Publication server(s).
The AWS domain contains the remote Distributor for Replication, and the systems I am calling edge clients with Wed Edition are the Subscribers.
-
SQL_ME_RICH (1/8/2014)
I've read that you can only have 1 distribution database per instance.A publisher will only use a single distribution database, if that's what you're referring too?
SQL_ME_RICH (1/8/2014)
Is there any possibility to get 2 or more Distributors (distribution databases) to work in the same instance? Or is this just the way it is?The instance you use as the ditributor can indeed have more than 1 distribution database, the distribution database may be called anything you like, it does not have to be called Distribution. See my screenshots below
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Hi Perry - Thank you for the reply. I should have made my question a bit more clear...Can the instance which is holding the Publisher database utilize more than 1 Distribution database. To date - my findings say no, but if you have information otherwise - I am all ears/eyes.
Thanks again!
-
SQL_ME_RICH (1/13/2014)
Hi Perry - Thank you for the reply. I should have made my question a bit more clear...Can the instance which is holding the Publisher database utilize more than 1 Distribution database. To date - my findings say no, but if you have information otherwise - I am all ears/eyes.Thanks again!
I have edited my last post to display correctly, the answer is no
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply