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 143
- Downloads 0
Loss of parental responsibility – a new legal instrument between need of protection of the best interest of the child and respect of parent fundamental rights
The new Albanian Family Code provides an additional measure reading the protection of the child, namely, the “loss of parental responsibility.” Differently from the measure of “removal of the parental responsibility” tha...
The External Dimension of EU Migration Policy
The policies relating to the management of migration - control of external borders, asylum and immigration have been, as is well known, sovereign prerogatives for excellence. The long-standing refuse of the EU Member Sta...
Energetic diplomacy and its role on creation of a new multipolar world
International correlations through the last years have been remarked as dramatic in character, and very often followed through with unpredictable events, such as the Arab spring, chronic and confessional wars raging thro...
Between Individual Rights and Group Rights
The politicization of ethnocultural diversity and the demands posed by minority cultures for greater public recognition of their distinctive identities, and greater freedom and opportunity to retain and develop their dis...
Basic Principles of the System of Social Services and Assistance
This paper deals with some basic principles as the key components for the establishment and functioning of the system of social protection and assistance. The paper analyzes the principles of universality, equality of...