A High Data Availability Mechanism on Database Management System
碩士 === 明志科技大學 === 電子工程系碩士班 === 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 effectivel...
Main Authors: | , |
---|---|
Other Authors: | |
Format: | Others |
Language: | zh-TW |
Published: |
2018
|
Online Access: | http://ndltd.ncl.edu.tw/handle/4yx2cs |
id |
ndltd-TW-106MIT00428014 |
---|---|
record_format |
oai_dc |
spelling |
ndltd-TW-106MIT004280142019-05-16T00:37:22Z http://ndltd.ncl.edu.tw/handle/4yx2cs A High Data Availability Mechanism on Database Management System 資料庫系統之資料高可用度機制 LEE, PO-I 李柏毅 碩士 明志科技大學 電子工程系碩士班 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. CHEN, YEN-JEN 陳延禎 2018 學位論文 ; thesis 54 zh-TW |
collection |
NDLTD |
language |
zh-TW |
format |
Others
|
sources |
NDLTD |
description |
碩士 === 明志科技大學 === 電子工程系碩士班 === 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.
|
author2 |
CHEN, YEN-JEN |
author_facet |
CHEN, YEN-JEN LEE, PO-I 李柏毅 |
author |
LEE, PO-I 李柏毅 |
spellingShingle |
LEE, PO-I 李柏毅 A High Data Availability Mechanism on Database Management System |
author_sort |
LEE, PO-I |
title |
A High Data Availability Mechanism on Database Management System |
title_short |
A High Data Availability Mechanism on Database Management System |
title_full |
A High Data Availability Mechanism on Database Management System |
title_fullStr |
A High Data Availability Mechanism on Database Management System |
title_full_unstemmed |
A High Data Availability Mechanism on Database Management System |
title_sort |
high data availability mechanism on database management system |
publishDate |
2018 |
url |
http://ndltd.ncl.edu.tw/handle/4yx2cs |
work_keys_str_mv |
AT leepoi ahighdataavailabilitymechanismondatabasemanagementsystem AT lǐbǎiyì ahighdataavailabilitymechanismondatabasemanagementsystem AT leepoi zīliàokùxìtǒngzhīzīliàogāokěyòngdùjīzhì AT lǐbǎiyì zīliàokùxìtǒngzhīzīliàogāokěyòngdùjīzhì AT leepoi highdataavailabilitymechanismondatabasemanagementsystem AT lǐbǎiyì highdataavailabilitymechanismondatabasemanagementsystem |
_version_ |
1719168548651139072 |