Printable View
Hi,
I have a question for you:
I am going to setting up oracle replication system on 2 servers. Is anybody knows how load from inserting, updating and deliting operation affect on performance?
I just have a two options: Standby server or Multimaster replication system.
What is preferable?
Thanks a lot.
I don't see any compatibility in this two options! You are comparing apples and bannanas. In multimaster replication both databases are active, transactions are executed on both sites and are replicated to the other site.Quote:
Originally posted by kgb
Hi,
I just have a two options: Standby server or Multimaster replication system.
What is preferable?
On the other hand, in standby configuration only one database is active, the other one is in constant recovery mode, hence can't be used at all. You can temporaryly open the standby database in read only mode, but while being able to read from database in this mode the changes from the other database are not applied to it while in read-only open mode.
Again, the functionality and the purpose of this two concepts are totaly different and can't be compared in terms "one or the other" for any situaton.
well the only similar thing between replication (let's talk about standard not advanced) and standby database is that they can both be used for disaster recovery, I would say standby is a cheap way of replication (but really cheap huh)
Can a standby server work over remote sites?
I need to have a copy of all regional databases updated continuously at HQ as separate DB's. What is the best solution?
As I know, you have to upload redo log files through the ftp and them applied their on standby server.
Quote:
Originally posted by nabaig
Can a standby server work over remote sites?
I need to have a copy of all regional databases updated continuously at HQ as separate DB's. What is the best solution?
I would go for replication.
Thanks.
Replication seems to be the consensus but can you elaborate a bit more please.
Nizar
You can have Standby over remote server. First of all tell us whats the purpose of this task ? Just for High availability or You need to access those databases simaultaneously ? I mean you have any plans of using the HQ databases for user access ?Quote:
Originally posted by nabaig
Can a standby server work over remote sites?
I need to have a copy of all regional databases updated continuously at HQ as separate DB's. What is the best solution?
As Jmodic said Just for High availability means you can use Standby. If you want use your regional databases copied over to HQ and use 'em for user activity you are left with REPLICATION is the only option and you don't have the second option standby, as you know that standby can only be READONLY mode while primary is in use.
Hope this helps...
I think everyone make it very clear. unless you can verify the purpose, these 2 options are incompatable.
Last week, I opened a thread standby vs. multi-master replication. unfortunately, only one response. since so many response in this thread. I want open my question in here if no one disagree:
my situation is: I have been asked to create two read-only sites that need to reflect all transactions "instantly" when master site been updated. for read-only I can use snapshot with a time-based refresh interval. for instantly update, I need a transaction based update which mutli-master support this feature. the issue is using very short interval (my test is 5 sec) will create hugh archive log files on master site. (my test data is no any activity, 3Gb per day). so what's the suggestion or option?
thanks
members,
This is neither for high availability nor HQ user activity, this is for auditing purposes. By auditing I done mean database auditing but functional auditing.
Customer is Saudi Arabia's only telecom company and they have servers all across the kingdom. What we are tring to do here is have all work order information at regions(local site)
available at HQ on a read only basis and for work auditing.
I know that you folks will ask mw why doesn't HQ query the region databases via links. That is not an option unfortunately.
This telecom needs all region DB's also at HQ on a real time basis.
Thanks,
Nizar
Hope you are aware that even your replication option also works on database links. The difference is the data in HQ will not be real time if you use replication option and readonly snapshots. Your data will be real time only when you have synchronous bidirectional replication, which is not an option as you have lots of resolution conflicts to deal with.
This is what I understood from you saying real time data availability at HQ.
For auditing, my suggestion is standby. much less overhead and maintenance work.