I would like to propose the use of the replication of the database as
safety of the data in a plant that makes production.
It deals with installing a license server that is used by all the
clients and a replication license on a second database "Slave" that it
is consulted only after a damage of the principal system.
Thing done think of it?
Am I forgetting me anything?
Will I warn a meaningful deceleration of the performances of the database?
In case of temporary skew of the systems (the principal file server or
the secondary one it falls) as I can realign the two database? Does They
Thanks to all for the help. Bruno
Please, consider your environmental responsibility.
Before printing this e-mail ask yourself: "Do I need a hard copy?"
Nota di riservatezza : Il presente messaggio, corredato dei relativi
allegati, contiene informazioni da considerarsi strettamente riservate,
ed ? destinato esclusivamente al destinatario sopra indicato, il quale ?
l'unico autorizzato ad usarlo, copiarlo e, sotto la propria
responsabilit?, diffonderlo. Chiunque ricevesse questo messaggio per
errore o comunque lo leggesse senza esserne legittimato ? avvertito che
trattenerlo, copiarlo, divulgarlo, distribuirlo a persone diverse dal
destinatario ? severamente proibito, ed ? pregato di rinviarlo
immediatamente al mittente distruggendone l'originale.
Confidentiality Notice : This message, together with its annexes,
contains information to be deemed strictly confidential and is destined
only to the addressee(s) identified above who only may use, copy and,
under his/their responsibility, further disseminate it. If anyone
received this message by mistake or reads it without entitlement is
forewarned that keeping, copying, disseminating or distributing this
message to persons other than the addressee(s) is strictly forbidden and
is asked to transmit it immediately to the sender and to erase the
original message received.
From: Bruno Rinaldi <email@example.com>
User-Agent: Mozilla Thunderbird 18.104.22.168 (Windows/20060909)
Subject: Replication for security access ?
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
X-Trace: 30 Oct 2006 01:00:11 -0700, 22.214.171.124
Xref: solutions.advantagedatabase.com Advantage.Replication:136
Article PK: 1133993
Subject: Re: Replication for security access ?
Date: Tue, 31 Oct 2006 11:07:17 -0700
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Response
X-Trace: 31 Oct 2006 11:03:11 -0700, 10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Replication:137
Article PK: 1133997
Another approach you might consider would be to use the online backup
In general, though, the idea of using replication for this should work,
although it might be a little more effort to set up than if you used the
backup functionality. In general, using replication for this task should
not affect the performance very much. It obviously adds some load to the
server, but the replication updates are queued up and processed
asynchronously, so the impact on a given operation is minimal.
The two servers will not realign themselves if they get out of sync. With
replication, specific updates are sent from one server to the other. It does
not perform synchronization of the data.