Construcción de escenarios para comparar la replicación activa optimista y pesimista

Abstract

At present due to the large volume of ¡nformation being processed and not in one
piace, it is necessary to determine the most appropriate settíngs to implement and
configure the distribution of informatíon ín organízations. The Database Managers
distríbute the informatíon among múltiple sites, but do not configure the settíngs
according to the real needs of performance, security and availabilityof information.
This paper aims to show the ítems that should be consídered to set up scenarios
which take advantage of distríbuting ¡nformation, not oniy considering safety aspects but aiso factors that substantially ímprove the performance of database systems.
Transactíonal replicatíon ís selected for a more detailed study, selectíon justifíed
from the point of view that this type of replicatíon ensures transactíonal consístency, a condítion required in most commercíal applicatíons, relying on a protocol
that does not belong to replicatíon itself, and that is the Commít Protocol in two
phases, however, aiso addresses two other ways to replícate informatíon.
Finally, we compare the replicatíon Turns Pessímistic and Optimistic Active Replica
tíon (whích correspond to SQLServer transactíonal replicatíon with immediate updating and queued updatíng, respectively). To achíeve this goal we buílt a Front -
End acts as a clíent that makes requests of executíon of both query transactíons
and update, it also set up replicatíon scenarios and conducted a seríes of experiments varyíng parameters, thereby statístícal data obtaíned enabled a compahson
between replicatíon techníques mentioned above and ídentífy advantages and dísadvantages