[THIN] Re: Citrix XP and SQL2000 Replication
- From: "Ron Oglesby" <roglesby@xxxxxxxxxxxx>
- To: <thin@xxxxxxxxxxxxx>
- Date: Thu, 22 Jan 2004 07:49:41 -0600
Ok having a DB in Indonesia that is read only is a bad idea. I mean lets
think about it, there are little things that update the SQL DS that has
nothing to do with changes YOU make in the CMC. You install a print
driver , update the datastore, you install a hotfix (MS or CTX) update
the DS. Etc etc
These are all things that can effect the datastore. Now the copy of the
DS these servers talk to on a normal basis can not accept these
connections.
For Merge Replication I have tried it in the lab with MetaFrame and it
Seems to work. The Problem here is that Citrix wont support it since
they never tested it. So what they do support is transactional
replication.
In transactional replication changes to the Indonesia SQL subscriber
(sent from ctx servers in that sight) are taken by the SQL Subscriber
server and sent to the Publisher (in Canada). The change is then checked
for a conflict and if there is no conflict it is entered into the DB on
both side (really entered into the DB in Canada then pushed to the
subscribers.
I have used this model With Citrix with up to 3 Subscribers in different
datacenters in the US. It works pretty well but of course we always had
a lot of bandwidth too.
In either case you need to setup transactional replication not merge and
accept writes from both sets of Citrix servers. The whole "Second
datastore is read only" is a Myth that Citrix its self created when they
had no clue of the effect on the DS and servers when a hundred or so
remote servers get talking to a Read only data base. Some SE's may still
tell you to do read only but there are too many things that update that
DS to do that.
OH, BTW< as a best practice I still use the CMC off of servers that talk
directly to the publisher. BUT if I goof up or am in a hurry I can make
changes from servers talking to the subscriber and have found over the
wan the Change has only about a second or two lag.
Ron Oglesby
Senior Technical Architect
RapidApp
Office 312.372.7188
Mobile 815.325.7618
email roglesby@xxxxxxxxxxxx
-----Original Message-----
From: Cherie Kelly [mailto:cherie.kelly@xxxxxxxxxx]
Sent: Wednesday, January 21, 2004 9:38 PM
To: 'thin@xxxxxxxxxxxxx'
Subject: [THIN] Citrix XP and SQL2000 Replication
Hi Everyone
I have what I hope is not an overly unique situation.
A citrix XPe Farm with the Datastore on an SQL 2000 server in Canada.
The
company is expanding into Indonesia.
We have another SQL 2000 server locally in Indonesia with 3 Citrix
servers
so far. The Datastore is replicated from Canada whenever changes are
made.
The datastore locally is read only, so to make changes we need to
connect to
the Canada Datastore.
I have read that SQL 2000 can handle merge replication. But can Citrix
handle this type of Replication?
We also have a problem where the local host cache becomes corrupt fairly
frequently. But to recreate the LHC, I have to point the server to the
datastore in Canada. It fails to recreate when pointed to the local
Datastore. It takes around 3 hrs for the IMA service to start when
pointed
to Canada.
When recreating the LHC does the server need to update the datastore?
If anyone can answer my questions or give advise on improvements, I
would
appreciate it.
Thanks for your Help in advance.
Cherie Kelly
NT Administrator
--
This transmission is for the intended addressee only and is confidential
information. If you have received this transmission in error, please
notify the sender and delete the transmission. The contents of this
e-mail are the opinion of the writer only and are not endorsed by the
Mincom Group of companies unless expressly stated otherwise.
********************************************************
This Week's Sponsor - Emergent Online 99Point9.com
EOL THINssentials(tm) Bring You TRUE Universal Printing Solutions
and Time Zone Support. EOL delivers any print job, any
time zone, to any client, over Any protocol (ICA or RDP)!
http://www.99point9.com/public/products/index.asp
*********************************************************
Useful Thin Client Computing Links are available at:
http://thethin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thethin.net/citrixlist.cfm
********************************************************
This Week's Sponsor - Emergent Online 99Point9.com
EOL THINssentials? Bring You TRUE Universal Printing Solutions
and Time Zone Support. EOL delivers any print job, any
time zone, to any client, over Any protocol (ICA or RDP)!
http://www.99point9.com/public/products/index.asp
*********************************************************
Useful Thin Client Computing Links are available at:
http://thethin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thethin.net/citrixlist.cfm
Other related posts:
