Re: I really don't get it: Asynchronous replication every 2 seconds

Make sure that your job_queue_interval is set to 1 for both database

In article <39a2959f.1946082_at_news.a2000.nl>,   sorry_at_no.mail.back.com (Sander) wrote:
> I have to synchronise 2 databases (on 2 servers). If someone modifies
> a record it should as soon as possible modified on the second server.
> First I used synchronous master-replication, but the problem with that
> is if server2 is down, server1 will not modify the record. The same
> vice versa, if I modify something on server 2 it should be propagated
> as soon possible to server 1.
>
> So I thought I will use asynchronous, 2 a 3 seconds, almost the same
> as synchronous.
>
> thanks,
> Sander
>
> >Yes, you can do it. In test environments I've done it every 10
 seconds
> >(10/86400). You're burning up a lot of cpu and io for this - seems
 like
> >there are better ways. What are you trying to accomplish?
 

> >> The problem is that I did not design it, I only have to implement
 it.
> >> It has to be asynchronous. No synchrone, no standby.
> >>
> >> I have been wondering if it is possible to have asynchronous
> >> replication every 2 a 3 seconds, because Oracle polls only once a
> >> minute.
 

> >> >You're really asking too much.
> >> >If you would set the interval to 2 seconds, the only thing your
 server
 would
> >> >do is replicate. Once a minute is already placing a burden on the
 system.
> >> >For what purpose do you replicate?
> >> >If you do this to maintain a live backup copyh, you should use
 the hot
> >> >standby option.
 

> >> >> I'm trying to configure (using oracle replication manager) 2
 databases
> >> >> to replicate every 2 seconds.
> >> >> It replicates twice a minute, and not 30 times a minute ?
> >> >> even I have said: interval 2 seconds.
 

> >> >> Can someone explain me step by step how to configure
 asynchronous
> >> >> replication or give me some tips, etc.
 

> >> >> Another question, if you modify something in the configuration,
 how
> >> >> fast will the modifications be modified by the Oracle server.
> >> >> Immediatelly, or do you have to wait a minute, 10 minutes, ...
 Can you
> >> >> test immediatelly or do you have to wait for a while.
>
>

--
                 Alex Shterenberg


Sent via Deja.com http://www.deja.com/
Before you buy.