[THIN] Re: Oracle data store
- From: "Lilley, Brian" <brian.lilley@xxxxxxxx>
- To: "'thin@xxxxxxxxxxxxx'" <thin@xxxxxxxxxxxxx>
- Date: Wed, 9 Jun 2004 09:53:24 +0100
Yup, exactly what I had concluded previously until I spoke to our Oracle guys.
I will let you know the outcome.
-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx]On
Behalf Of Ron Oglesby
Sent: 08 June 2004 17:51
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Oracle data store
It may be different in oracle (I FOR SURE am not an oracle guy) But
imagine this change. Change on remote server. Change sent to
master/publisher, publisher verifies change is ok/no conflict, commits
change, then pushes change out to all other partners and change is
committed on the first server.
Now in my last environment with this running we are talking 2 seconds of
latency generally. At the highest 3. sometimes faster. All depends
right?
Anyway there can be lag. I don't know what to really tell ya, its just
what they support. Also remember that a best practice in replicated
environments is to publish the CMC from Servers communicating with the
publisher. This ensures smooth replication. Changes made at the remote
site to the DS then are rarer.
Ron Oglesby
Senior Technical Architect
Microsoft MVP, Windows Server
RapidApp, Chicago
Office 312.372.7188
Mobile 815.325.7618
email roglesby@xxxxxxxxxxxx
-----Original Message-----
From: Lilley, Brian [mailto:brian.lilley@xxxxxxxx]
Sent: Tuesday, June 08, 2004 11:38 AM
To: 'thin@xxxxxxxxxxxxx'
Subject: [THIN] Re: Oracle data store
Ron,
Our Oracle DBA said that two-phase commit with synchronous transactions,
requires that the database which you are updating will not commit the
update
until it has ensured that the transaction has been committed on all
other
replication partners first. With four replication partners over a WAN,
the
overall latency could be something like 5-10 secs for an update.
I was under the impression that the two phase commit process meant that
the
database you are updating would simply send update to the publisher
(master)
which would commit immediately, thus allowing the sending database to
commit,
and the publisher database would then replicate that change to the other
replication partners?
Brian
-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx]On
Behalf Of Ron Oglesby
Sent: 08 June 2004 17:14
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Oracle data store
Sorry, have done oracle, but not replicated. Don't worry the heavy SQL
dba's say the same thing about Citrix's recommendations. I got merge
replication to work for SQL with FR3 on like 20 servers in the lab.
Worked real well. But Citrix wont support it. Their stance is "It will
corrupt your data store". Which really means "we have a way to do it
already, even if MS supports a newer way of doing it". For an ISV they
spend money on development and testing where they need to (new features)
to get more bang for their buck.
Ron Oglesby
Senior Technical Architect
Microsoft MVP, Windows Server
RapidApp, Chicago
Office 312.372.7188
Mobile 815.325.7618
email roglesby@xxxxxxxxxxxx
-----Original Message-----
From: Lilley, Brian [mailto:brian.lilley@xxxxxxxx]
Sent: Tuesday, June 08, 2004 11:10 AM
To: 'thin@xxxxxxxxxxxxx'
Subject: [THIN] Oracle data store
Hi list,
I approached our Oracle DBA's with the Citrix recommendations for data
store
replication.
Their initial response was not positive. Basically, they view the
replication
recommendation as out of date and is much better implemented with async
transactions and some other components that escape me.
I would be very interested to hear from anyone that has implemented a
replicated data store on Oracle.
thanks in advance, Brian
========================================================================
======
This message is for the sole use of the intended recipient. If you
received
this message in error please delete it and notify us. If this message
was
misdirected, CSFB does not waive any confidentiality or privilege. CSFB
retains and monitors electronic communications sent through its network.
Instructions transmitted over this system are not binding on CSFB until
they
are confirmed by us. Message transmission is not guaranteed to be
secure.
========================================================================
======
********************************************************
This Week's Sponsor - RTO Software / TScale What's keeping
you from getting more from your terminal servers? Did you
know, in most cases, CPU Utilization IS NOT the single
biggest constraint to scaling up?! Get this free white paper
to understand the real constraints & how to overcome them.
SAVE MONEY by scaling-up rather than buying more servers.
http://www.rtosoft.com/Enter.asp?ID=147
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm
********************************************************
This Week's Sponsor - RTO Software / TScale What's keeping
you from getting more from your terminal servers? Did you
know, in most cases, CPU Utilization IS NOT the single
biggest constraint to scaling up?! Get this free white paper
to understand the real constraints & how to overcome them.
SAVE MONEY by scaling-up rather than buying more servers.
http://www.rtosoft.com/Enter.asp?ID7
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm
========================================================================
======
This message is for the sole use of the intended recipient. If you
received
this message in error please delete it and notify us. If this message
was
misdirected, CSFB does not waive any confidentiality or privilege. CSFB
retains and monitors electronic communications sent through its network.
Instructions transmitted over this system are not binding on CSFB until
they
are confirmed by us. Message transmission is not guaranteed to be
secure.
========================================================================
======
********************************************************
This Week's Sponsor - RTO Software / TScale What's keeping
you from getting more from your terminal servers? Did you
know, in most cases, CPU Utilization IS NOT the single
biggest constraint to scaling up?! Get this free white paper
to understand the real constraints & how to overcome them.
SAVE MONEY by scaling-up rather than buying more servers.
http://www.rtosoft.com/Enter.asp?ID=147
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm
********************************************************
This Week's Sponsor - RTO Software / TScale What's keeping
you from getting more from your terminal servers? Did you
know, in most cases, CPU Utilization IS NOT the single
biggest constraint to scaling up?! Get this free white paper
to understand the real constraints & how to overcome them.
SAVE MONEY by scaling-up rather than buying more servers.
http://www.rtosoft.com/Enter.asp?ID7
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm
==============================================================================
This message is for the sole use of the intended recipient. If you received
this message in error please delete it and notify us. If this message was
misdirected, CSFB does not waive any confidentiality or privilege. CSFB
retains and monitors electronic communications sent through its network.
Instructions transmitted over this system are not binding on CSFB until they
are confirmed by us. Message transmission is not guaranteed to be secure.
==============================================================================
********************************************************
This Week's Sponsor - RTO Software / TScale What's keeping
you from getting more from your terminal servers? Did you
know, in most cases, CPU Utilization IS NOT the single
biggest constraint to scaling up?! Get this free white paper
to understand the real constraints & how to overcome them.
SAVE MONEY by scaling-up rather than buying more servers.
http://www.rtosoft.com/Enter.asp?ID=147
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm
Other related posts:
