A High Data Availability Mechanism on Database Management System

• Main Authors: LEE, PO-I, 李柏毅
• Other Authors: CHEN, YEN-JEN
• Format: Others
• Language: zh-TW
• Published: 2018
• Online Access: http://ndltd.ncl.edu.tw/handle/4yx2cs

碩士 === 明志科技大學 === 電子工程系碩士班 === 106 === This study provides a low-cost and high-availability database management system architecture for general SMEs to backup database data. To prove that the architecture designed by our Institute can support the high availability of the database, and can effectively avoid data loss in memory caused by failovers, this study applied the main test method of powering off the virtual machine and verified three cases: 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 this study effectively controls the WAL (Write Ahead Log) mechanism of the database, so that data correctness is maintained during failovers. Case 3 proves that this study 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 there is not 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.