Research on highly available database Hot Standby system and its performance

Database management system(DBMS) is the core engine of an IT system,which availability is critical to the availability of the whole system.Hot standby DBMS is the most simplest and practical highly available database system schema.The architecture,various configuration scenarios,log persistence strategy and replication strategy of hot standby system were analyzed.Performances of various configuration scenarios were investigated.When response time of transaction is the top concern and persistence of logging could be relaxed,a performance improvement of system of 68.7%-226.8% could be achieved using an asynchronous logging.