www.Usenet.com
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
Date: Wed, 26 Nov 2003 06:19:46 -0800 (PST)
From: Armand Pirvu <[EMAIL PROTECTED]>
Subject: RE: Replication - Again
To: Yehudah Edelstein <[EMAIL PROTECTED]>
Not to be sarcastic, but I am not sure if in English there is a different meaning for password. I will look into the definition since English is a second langauage for me.For example, connecting to SQL Server , there is either a config file or a table where the password is in plain text. I do recall having this seen, but only in the HVR configuration stage. Look in the documentation. I am not sure if they could be encrypted, not that I have seen so far.Only looking at (in) the manual won't help much.If you want to play with that, just do yourself an installation, configuration and you will figure it out some good stuff about it. At least that is how I did it. Not that I would not trust the guys from HVR, especially Steve Scheile, which is a fine dude, but consideraing my previous work with Replicator and Gateways, I kinda had a feeling I could do it on my own. Most I did, and there were things where Steve gave me a lot of help. On the performace, as I said, little impact.I was using HVR to replicate at the end of the day.Besides the transactions per second, bare in mind that those go into some tables, similar to Ingres Replicator (as I said they share a lot of stuff), and from there transactions go to the target database. It is not really only the updates in your case, you gotta consider also the rest, like propagating data and deleting from the shadow tables.I am sorry I responded to this thread. I assumed we are talking Ingres stuff and not getting translating things.BTW, any way one could get out of this group ?Cheers,Armand
Yehudah Edelstein <[EMAIL PROTECTED]> wrote:"But config files, do have on some instances, plain text password."What did you mean by "password"? Passwords can be encrypted with HVR utilities?We have HVR running by us with intervals of 23 seconds and we're getting more than 40 updates per second. Very little impact on system, though we have occasional timeouts (where we set the timeout for some time critical transactions).Yehudah-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Armand Pirvu
Sent: Monday, November 24, 2003 9:19 PM
To: Gareth Williams; '[EMAIL PROTECTED]'
Subject: Re: Replication - AgainHi Gareth,I worked with both of them.Although Ingres Replicator , I found it more secure in terms of logins (how it connects to a database), it adds some burden on a heavy duty system. And it works with tables having primary keyes or unique indexes. The burden is on the locking system, and some significant impact on the Ingres DBMS server if say you would choose replication to happen once in a while and that would translate into massive data accumulated in the shadow tables.HVR is more easy on the system load. But config files, do have on some instances, plain text password. However, I haven't seen locking issues, nor Ingres DBMS performance issues. I found tricky though it's Java interface.The good side is that one could actually use tables without any unique constraints.The bad side is for tables with big row width, at the configuration time it requires some significant resources, mainly QSF, QEF.Another good part is that even if used it (HVR) once a day, for let's say about half of million records accumulated, no performance impact has been noticed, maybe say tops 2% degradation (worst case).Overall I do think HVR is better.Both of them share some principles and concepts.If you look on both, both create rules and procedures on the originating Ingres database, and I could tell, HVR builds better ones.A major point, HVR could use source / target combination either way you want it. And it doesn't need the gateways. Oracle I assume would be the same stuff, Oracle Net etc, but SQL Server for example, bye bye ODBC in HVR which I can tell you is a major bottleneck.Armand
Gareth Williams <[EMAIL PROTECTED]> wrote:Hello all,
Sorry, I know we've touched on this in the past... but...
Other than HVR (promising) and Ingres Replication (which seems a shocking
bit of software), are there any other software vendors out there that'll
attempt to replicate - and work?
I'd really like to hear from people who have had good and bad experience
with the above or any type of replication.
(Ingres 2.6 on Solaris)
Thanks
Gareth Williams
-----------------------------------
Gareth Williams non-random quote #1: "Switch it off, then turn it back on"
Engliish:- This message is confidential. If you are not the intended
recipient of the message then please notify the sender immediately. Any of
the statements or comments made above should be regarded as personal and not
necessarily those of Bro Morgannwg NHS Trust, any constituent part or
connected body. Cymraeg:- Mae'r neges hon yn gyfrinachol. Os nad chi yw'r
derbynnydd y bwriedid y neges ar ei gyfer, byddwch mor garedig â rhoi gwybod
i'r anfonydd yn ddi-oed. Dylid ystyried unrhyw ddatganiadau neu sylwadau a
wneir uchod yn rhai personol, ac nid o angenrhaid yn rhai o eiddo
Ymddiriedolaeth GIG Bro Morgannwg, nac unrhyw ran gyfansoddol ohoni na
chorff cysylltiedig.
Do you Yahoo!?
Free Pop-Up Blocker - Get it now---------------------------------------------------------------------------------------------------------------
This e-mail message may contain confidential, commercial and privileged information or data that constitute proprietary information of Cellcom Israel Ltd. Any review or distribution by others is strictly prohibited. If you are not the intended recipient you are hereby notified that any use of this information or data by any other person is absolutely prohibited. If you are not the intended recipient, please delete all copies.
Thank You.
http://www.cellcom.co.il
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
| <-- __Chronological__ --> | <-- __Thread__ --> |
