| How to replicate data ? [message #608652] |
Fri, 21 February 2014 13:48  |
Amine
Messages: 376
Registered: March 2010
|
Senior Member |
|
|
Hi all,
We have a central database, an Oracle 9iR2 DB, accessed by 20 regions in the country through the network (private network, not the Internet).
The database is accessed through a Client-server Forms 6i application. The application works fine in the central region except that it is very slow in the 20 th regions.
The access is slow, the authentication is slow, a simple search is slow (F7,F8 takes about 2 minutes).
Now to remove the slowness, we think about two options : the network option and the replicated database option.
And we want to think about the 2nd one.
Here it is :
The central database remains. We create 20 databases in each region. Each region sees its own data.
Writes on the DB (insert, update, delete) are done in the central database and in the 20th other databases.
We want to replicate writes from the central database to the 20th regions and from the 20 th regions to the central database all in sync.
To realize that, I heard about GoldenGate but I think there is much simpler than that. Could any one advice about how to do this (the best way) ?
Thanks in advance,
Amine
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: How to replicate data ? [message #612005 is a reply to message #608660] |
Thu, 10 April 2014 13:09  |
 |
Rayam69
Messages: 43
Registered: May 2012
|
Member |
|
|
Hi Amine,
If connectivity from other regions to your database in the central region is slower, it could be only two things.
1. Database not properly tuned.
2. Bandwidth at other regions are not enough.
Fixing these two would be lot more cheaper and efficient than going about creating multiple databases.....
Good luck.
regards.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
