Adding a new site in an existing Oracle Multimaster replication without quiescing the replication
This paper presents a new solution, which adds a new database server on an existing Oracle Multimaster Data replication system with Online Instantiation method. During this time the system is down, because we cannot execute DML statements on replication objects but we can only make queries. The time...
Main Authors: | , , , |
---|---|
Format: | Text |
Language: | unknown |
Published: |
2011
|
Subjects: | |
Online Access: | http://arxiv.org/abs/1109.1302 |
id |
ftarxivpreprints:oai:arXiv.org:1109.1302 |
---|---|
record_format |
openpolar |
spelling |
ftarxivpreprints:oai:arXiv.org:1109.1302 2023-09-05T13:19:05+02:00 Adding a new site in an existing Oracle Multimaster replication without quiescing the replication Paci, Hakik Kajo, Elinda Tafa, Igli Xhuvani, Aleksander 2011-09-06 http://arxiv.org/abs/1109.1302 unknown http://arxiv.org/abs/1109.1302 Computer Science - Databases text 2011 ftarxivpreprints 2023-08-16T12:32:42Z This paper presents a new solution, which adds a new database server on an existing Oracle Multimaster Data replication system with Online Instantiation method. During this time the system is down, because we cannot execute DML statements on replication objects but we can only make queries. The time for adding the new database server depends on the number of objects, on the replication group and on the network conditions. We propose to add a new layer between replication objects and the database sessions, which contain DML statements. The layer eliminates the system down time exploiting our developed packages. The packages will be active only during the addition of a new site process and will modify all DML statements and queries based on replication objects. Comment: 9 pages, 4 figures, in International Journal of Database Management Systems (IJDMS) (2011) Text DML ArXiv.org (Cornell University Library) |
institution |
Open Polar |
collection |
ArXiv.org (Cornell University Library) |
op_collection_id |
ftarxivpreprints |
language |
unknown |
topic |
Computer Science - Databases |
spellingShingle |
Computer Science - Databases Paci, Hakik Kajo, Elinda Tafa, Igli Xhuvani, Aleksander Adding a new site in an existing Oracle Multimaster replication without quiescing the replication |
topic_facet |
Computer Science - Databases |
description |
This paper presents a new solution, which adds a new database server on an existing Oracle Multimaster Data replication system with Online Instantiation method. During this time the system is down, because we cannot execute DML statements on replication objects but we can only make queries. The time for adding the new database server depends on the number of objects, on the replication group and on the network conditions. We propose to add a new layer between replication objects and the database sessions, which contain DML statements. The layer eliminates the system down time exploiting our developed packages. The packages will be active only during the addition of a new site process and will modify all DML statements and queries based on replication objects. Comment: 9 pages, 4 figures, in International Journal of Database Management Systems (IJDMS) (2011) |
format |
Text |
author |
Paci, Hakik Kajo, Elinda Tafa, Igli Xhuvani, Aleksander |
author_facet |
Paci, Hakik Kajo, Elinda Tafa, Igli Xhuvani, Aleksander |
author_sort |
Paci, Hakik |
title |
Adding a new site in an existing Oracle Multimaster replication without quiescing the replication |
title_short |
Adding a new site in an existing Oracle Multimaster replication without quiescing the replication |
title_full |
Adding a new site in an existing Oracle Multimaster replication without quiescing the replication |
title_fullStr |
Adding a new site in an existing Oracle Multimaster replication without quiescing the replication |
title_full_unstemmed |
Adding a new site in an existing Oracle Multimaster replication without quiescing the replication |
title_sort |
adding a new site in an existing oracle multimaster replication without quiescing the replication |
publishDate |
2011 |
url |
http://arxiv.org/abs/1109.1302 |
genre |
DML |
genre_facet |
DML |
op_relation |
http://arxiv.org/abs/1109.1302 |
_version_ |
1776199892488683520 |