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 121
- Downloads 0
Visa liberalisation and economic implication for the Western Balkans
When in April, 2007, western Balkan countries started the facilitation of the visa agreement that will allow them extremely simplified procedures for visa application in order to enter EU countries, many of the citizens...
The Sentencing System in the Albanian Criminal Code and the Demand for Special Tretament of Juveniles
Juveniles are subject to a cognitive process and growth, where the physical, intellectual, emotional and personality are still in phase of development phase. As a result, they enjoy a special status which arises the dema...
Confrontation Between Judicial Activism and State of Exception
The judiciary has excelled in the international and national scene, reaching role of great importance, thus creating opposition to the legislative and executive powers. The center of gravity of the sovereign power of the...
Economic crisis impact on Remittances and Migration level in Albania
Remittances of international migrants as the second largest flow of incomes contribute to the well-being of their households of origin and also have an impact at macro-economic level. Out-migration is an effective means...
Gaming mirrors at play through ludic data-selves
The focus of the article is on data-self technology in digital entertainment - virtual entities that replicate and/or are influenced by players’ behaviors and actions, working as agential mirrors on the screen. Little ef...