Re: <None>

as360114_at_orion.yorku.ca writes:
: Lately, I have been hearing about "replication servers" related to database
: engines.
:
: With no experience about this item, I am asking for your help:
:
: (1) What is a replication server?

As far as I know, a Replication server "seats" over the log of an SQL server and tryes to keep another SQL server with an syncronized database.
I havn't used it yetm but I think that this replication don't need to be at database level, it can be done at table level. Here I may be wrong.

: (2) What applications need a replication server?

It's not only a question of application, it may be a performance problem. Or just a topological problem, imagine 2 sites connected with a WAN, why to add the WAN overhead to every access if you can replicate de info locally just with one (permanent) WAN connection...

It looks a good idea, but I don't really know if it is safe.

--
regards,

Antonio Vasconcelos
_at_ The Lisbon $tock Exchange   (Associacao da Bolsa de Valores de Lisboa)
........................................................................
mailto:vasco_at_bvl.pt               mailto:vasco_at_individual.puug.pt (MIME)
mailto:postmaster_at_bvl.pt          mailto:webmaster_at_bvl.pt         (soon)
........................................................................
        All opinions are my own, my employer thinks I'm working
........................................................................
<<< Unable to locate Coffee -- Operator Halted! >>>