Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Replication for security access ?

2 posts in Replication Last posting was on 2006-10-31 18:07:17.0Z
Bruno Rinaldi Posted on 2006-10-30 08:04:13.0Z
Date: Mon, 30 Oct 2006 09:04:13 +0100
From: Bruno Rinaldi <rinaldi.bruno@cibaelectric.it>
User-Agent: Mozilla Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
Newsgroups: Advantage.Replication
Subject: Replication for security access ?
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 85.18.228.172
Message-ID: <4545b10b@solutions.advantagedatabase.com>
X-Trace: 30 Oct 2006 01:00:11 -0700, 85.18.228.172
Lines: 46
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!85.18.228.172
Xref: solutions.advantagedatabase.com Advantage.Replication:136
Article PK: 1133993

Hi,
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
automatically realign?

Thanks to all for the help. Bruno



Rinaldi Bruno
Analista Programmatore

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.
Grazie.

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.
Thank you.


Mark Wilkins Posted on 2006-10-31 18:07:17.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: Advantage.Replication
References: <4545b10b@solutions.advantagedatabase.com>
Subject: Re: Replication for security access ?
Date: Tue, 31 Oct 2006 11:07:17 -0700
Lines: 70
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <45478fdf@solutions.advantagedatabase.com>
X-Trace: 31 Oct 2006 11:03:11 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Replication:137
Article PK: 1133997

Hi Bruno,

Another approach you might consider would be to use the online backup
functionality.

http://devzone.advantagedatabase.com/dz/webhelp/Advantage8.1/server1/online_backup.htm

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.

Mark Wilkins
Advantage R&D

"Bruno Rinaldi" <rinaldi.bruno@cibaelectric.it> wrote in message
news:4545b10b@solutions.advantagedatabase.com...
> Hi,
> 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
> automatically realign?
>
> Thanks to all for the help. Bruno
>
>
>
> Rinaldi Bruno
> Analista Programmatore
>
> 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.
> Grazie.
>
> 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.
> Thank you.