Interligando Bases De Dados Do Sistema Controle De Marcas E Sinais Utilizando O Mysql Cluster

Abstract

We can clearly perceive a new generation on web, where speed and reliability are needed for any application, therefore, a good Distributed Database Management System (DDBMS) must to work with goals and offer different advantages over centralized system model. The desired reliability in an application is reached with a high level of falt tolerance. To satisfy these necessities, new distributed technologies and architectures has been developed, tested and standarized. During this research, we have dealt with synchronous and asynchronous replication strategies, which was divided based on changes’ propagation latency of an object to the others. In a fundamental importance’s scope, the failures on databases are dealt since the simplest, where it affects only one transaction, until failures considered biggest, where all transactions are affected. When it perceives a fault, a reliable DDBMS must recover all finished tasks or that are on progress, in order to try to minimize damage of work, in other words, the task must go on its execution, starting from its last valid state before the fault. A solution to connect databases of Marks and Signals Control system was developed by me, using the MySQL Cluster tool. The application it must access data and replicate them among bases, ensuring content integrity. The presented structure is based on open source-code software.