High Availability of Relational Database Deployed Over Corporate Lan
There is a need to provide uninterrupted services of servers, networks and databases in the current organizational environment relying heavily on computing technologies. Database replication solutions can be used to increase reliability and availability of data. Database replication entails duplication of data from one master database server to one or more slave database servers. The project implements database replication system with one master database server and two slave database servers. It is proposed to use MariaDB database, an open source relational database for the project. The database Block Diagram replication system ensures slave database servers keep a replica of data of master servers which can be used to restore services in case master database server fails. However, restoring services using data of one of slave database servers require human intervention making it a time consuming process. Therefore, there is need to implement database replication system with automatic failover capabilities which ensures one of the slaves is promoted as master database in real time. This failover happens in real time and the process is transparent to user.
Keywords - MariaDB, High availability, Fault tolerance, Automatic failover, Downtime