Oracle Multimaster Replication Maintance Optimization
Journal Title: Academicus - International Scientific Journal - Year 2011, Vol 2, Issue 3
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.
Authors and Affiliations
Hakik Paci, Aleksander Xhuvani
Keywords
Related Articles
- EP ID EP156397
- DOI -
- Views 107
- Downloads 0
Review of “Marked Identities. Narrative lives between social labels and individual biographies”
This is a book review of the volume edited by Roberta Piazza and Alessandra Fasulo, and entitled Marked Identities. Narrative Lives Between Social Labels and Individual Biographies, Palgrave Macmillan, London-New York, 2...
Lawyer of defendant and his role in the criminal process from the viewpoint of the European Convention on Human Rights and the Albanian criminal procedural legislation
A guarantee for real ensuring of defendant’s rights is the qualified legal assistance by the side of the lawyer, chosen or assigned by the proceeding body. Providing legal protection to defendants was an important achiev...
The Extent of Judicial Administrative Control the Power of the Administrative Court
The application of the principle of legality must meet various requirements dealing specifically with its extent or its reach in the administrative activity. The question that we will seek to answer in this paper is the...
Smuggling of human beings and connection with organized crime
Through this paper is intended to note the difference between human smuggling and trafficking in human beings, emphasizing the distinctive items and those that are common. During work the focus is on criminal offenses co...
Eco-Education: A Required Element of Public Policies for Sustainable Social and Economic Development
In this article, the author analyzes eco-education from a transdisciplinary perspective, as part of the “new education”, referring to its current dimensions, its goals and its utility in shaping the attitudes and behavio...