Oracle Multimaster Replication Maintance Optimization

Hakik Paci and Aleksander Xhuvani

Academicus International Scientific Journal, 2011, issue 3, 145-152

Abstract: This paper presents a new solution for adding a new database server on an existing Oracle Multimaster data replication system. In normal conditions adding a new database server on this system we cannot insert, delete and update data during this time. So during this time the system is down and we can make only queries. The time for adding the new database server depends on the number of tables on the replication group and on the network conditions. To reduce this time we propose to replace the Replication group in more than one replication group based on logic of database schema. So we will have a replication group for base data, one replication group for most populated tables and another group for non most used tables. Using this method on the Oracle database schema with 250 replication tables and communication speed 1Mbit/s, the time reduced seven times. This research is implemented on border control system (Total Information Management System at Ministry of Interior) in Albania and using this solution we can add or remove replication sites with minimal down time.

Keywords: Oracle Multimaster Data Replication; Replication; Replication group (search for similar items in EconPapers)
Date: 2011
References: View complete reference list from CitEc
Citations:

Downloads: (external link)
https://academicus.edu.al/nr3/Academicus-MMXI-3-145-152.pdf (application/pdf)
https://academicus.edu.al/nr3/Academicus-MMXI-3-145-152.html (text/html)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:etc:journl:y:2011:i:3:p:145-152

Access Statistics for this article

Academicus International Scientific Journal is currently edited by Arta Musaraj

More articles in Academicus International Scientific Journal from Entrepreneurship Training Center Albania Contact information at EDIRC.
Bibliographic data for series maintained by Gabor Vasmatics ().