Abstract
This study provides a low-cost and high-availability database management system architecture for general Small/Medium Enterprises (SMEs) to backup database data access. To prove that the proposed architecture can support the high availability of the database, and can effectively avoid data loss in memory caused by failovers, this study applies the main test method of powering off the virtual machine and verified three cases on two commonly used databases MySQL and PostgreSQL: Case 1 proves that this study combines the database native disaster recovery mechanism to effectively achieve high availability of the database. Case 2 proves that it effectively controls the WAL (Write Ahead Log) of the PostgreSQL database and Redo log mechanism of the MySQL database, so that data correctness is maintained during failovers. Case 3 proves that it can analyze and control the timing of the database in writing data in the cache memory to the hard disk. This study also designed a failover process to avoid data loss during failovers due to no enough time to write the data in the cache memory back to the hard disk; and finally to realize the high-availability of the database management system architecture in a practical way.
 
 Keywords: Database, DBMS, High Availability, Failover, DRBD
Highlights
1.1 Motivation Information technology infrastructure is an indispensable part of the information environment of modern Small/Medium Enterprises (SMEs)
During the operation of the backup mechanism of the database, since the database software has a mechanism for storing data in the memory to enhance the operational efficiency of the system; this mechanism will lead to data loss due to the switching of the database server while the backup mechanism is in operation
The subject of this study is data loss caused by the operation of database backup mechanism, and we discuss about high data availability mechanism on database management systems
Summary
1.1 Motivation Information technology infrastructure is an indispensable part of the information environment of modern SMEs. The database (DB) for storing enterprise operational data is the most important part of the information environment because it relates to the lifeblood of a company. In the course of business operation, in order to avoid business interruption, enterprises adopt a backup mechanism so that the network and system services in the information environment will be uninterrupted. The subject of this study is data loss caused by the operation of database backup mechanism, and we discuss about high data availability mechanism on database management systems. Yen-Jen Chen , Han Tsai; Implementation and Verification of High Data Availability on Database, Transactions on Networks and Communications, Volume 7 No 5, October (2019); pp: 1-12
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Free) 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call
