Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Move Farm to SQL
- Thread starter djacobus
- Start date
Well yes you can move the server to SQL see dsmaint command, and docs on Citrix on "How to move Data Store"
Should you, well once you are above 1 server then it does give you a vulnerability having an access data store. Lose the Data store server you are stuffed.
[blue]Arguably the best cat skinner around ! [/blue]
Cheers
Scott
Should you, well once you are above 1 server then it does give you a vulnerability having an access data store. Lose the Data store server you are stuffed.
[blue]Arguably the best cat skinner around ! [/blue]
Cheers
Scott
- Thread starter
- #3
Here is my advice.
If you have SQL then use it. If you don't then access will work fine.
If I was you I would move it. Then either server can go down without any side effects.
[blue]Arguably the best cat skinner around ! [/blue]
Cheers
Scott
If you have SQL then use it. If you don't then access will work fine.
If I was you I would move it. Then either server can go down without any side effects.
[blue]Arguably the best cat skinner around ! [/blue]
Cheers
Scott
- Thread starter
- #5
MikeBatters
Technical User
DJ - If the farm grows you will need to move the datastore anyway becuase it does give some performance advatages so i too would do it now.
- Thread starter
- #7
MatthewJones
Technical User
Doesn't SQL end up being the Single point of failure at that point. Here's my delemma.
If SQL is replicated can Citix be configured to pick from a primary or backup SQL server?
I need to expand my farm to a 2nd box and SQL is obviously the answer but my boss had concerns of SQL being the single point of failure in the long run. Yes, we can replicate SQL but can Citrix dynamically recover and/or how easy is it to repoint the database to the back up server?
If SQL is replicated can Citix be configured to pick from a primary or backup SQL server?
I need to expand my farm to a 2nd box and SQL is obviously the answer but my boss had concerns of SQL being the single point of failure in the long run. Yes, we can replicate SQL but can Citrix dynamically recover and/or how easy is it to repoint the database to the back up server?
MikeBatters
Technical User
Matthew,
Even though SQL Server is potentially a single point of failure in this configuration there are two points to consider:
SQL Server based farms always seem to perform better and you do not have the DB overhead on one of the servers.
Even if you do completely loose the SQL Server you have 72 hours to put it back on another box, restore CitrixDB and change the DSNs before anything significant stops working (like connectivity). In the mean time you will loose the CMC but we have been through this excerise and you can build any old piece of kit and put SQL server on it in half a day.
As for how easy is it to change the DSN - Its a 2 minute per box job.
Does that help the dilema?
Even though SQL Server is potentially a single point of failure in this configuration there are two points to consider:
SQL Server based farms always seem to perform better and you do not have the DB overhead on one of the servers.
Even if you do completely loose the SQL Server you have 72 hours to put it back on another box, restore CitrixDB and change the DSNs before anything significant stops working (like connectivity). In the mean time you will loose the CMC but we have been through this excerise and you can build any old piece of kit and put SQL server on it in half a day.
As for how easy is it to change the DSN - Its a 2 minute per box job.
Does that help the dilema?
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question