Multiple Deployment Solution Servers
Updated: 28 May 2010 | 4 comments
Can I install multiple Deployment Servers against a single SQL database?
I am also examining my options regarding Redundancy and Fault tolerance for DS. We will have the ability to create Geo-clusters for SQL.
I have 2 datacenters (1 is primary and 1 is Disaster Recovery) and want to run a deployment solution server in each one. Can I strive to keep both on a single SQL instance, or should I hae each DS point to its own SQL instance.
I didn't think DS is a good fit for running itself on a MSCS cluster. Is this true?
How do Notification servers fit it, or do they not fit into this discussion. I understand these now replicate "everything"...?
Thank you all very much for any insight you can provide.
Regards,
Rismoneyman!
discussion Filed Under:
Comments
Separate Instances
I'm not 100% certain, but I believe each DS has to have it's own database. I don't believe you can tie more than one DS to the same database, at least not with 6.9. I'm not sure what's changed in 7 though.
I would imagine you could set up two database servers and two DS's and have the SQL database synchronized. Being as the secondary data center (DR site) is mainly off-line unless the main data center is compromised, this should work. The point of having a DR is not for load balancing, but to be able to cut over to the exact same named servers in the DR site.
NS is a completely different animal. NS is more designed to have multiple NS servers that point to the same database instances. DS 7 is more based on the NS architecture.
I don't do a lot with NS, so I'll leave someone else to really explain that.
Brian Hawver
Systems Engineer
Yaskawa America, Inc.
Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.
> Can I install multiple
> Can I install multiple Deployment Servers against a single SQL database?
Yes, you can ;-). DS uses the eXpress database as a default but you can rename the DB to whatever suits you and then modify the System DSN in your Deployment Server to point to the newly named DB.
This can be done multiple times to have many DS databases into a single SQL instance.
> I have 2 datacenters (1 is primary and 1 is Disaster Recovery) and want to run a deployment solution server in each one. Can I strive to keep both on a single SQL instance, or should I have each DS point to its own SQL instance.
You can have both DS into a single instance or SQL cluster (better if you are considering DR). In term of Database synchronisation a single back up can allow you to restore your jobs and computers history from one (failed) instance to a live one. This shouldn't be too long as the DS databases are never really too large (unless something's wrong).
Ludovic FERRÉ
Principal Remote Product Specialist
Symantec
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect
Database
To clarify,
Can 2 DS share a single Database, or does each DS needs its own unique Database? I understand they can share an instance...
Thank you for all your help.
No DB sharing in DS
Okay, I got the idea now.
It would be good, but that's a No-no.
Ludovic FERRÉ
Principal Remote Product Specialist
Symantec
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect
Would you like to reply?
Login or Register to post your comment.