煤矿企业纯软件方式的双机热备系统研究

针对煤矿监控系统双机热备标准方案中硬件设备昂贵、维护成本较高的问题,设计了一种纯软件方式的双机热备系统。该系统利用文件差异备份以及MYSQL增量备份相结合的方式将数据保存到主、备机中,即采用RSYNC文件同步算法对文件进行备份,利用MYSQL数据库的Binary Log机制开启日志记录文件,将在一个时间间隔内发生修改的数据信息导出到增量备份文件中,并将增量备份文件发送到备机中,备机将修改数据导入数据库,从而达到数据库同步操作的目的。同样地,在主机出现故障后,在备机中修改的数据以同样的方式同步到主机中。该双机热备系统已投入实际应用,满足了煤矿监控系统中数据实时性与数据完整性的要求。

Research of Hot Standby System with Pure Software Mode for Coal Mine Enterprises

In view of problems of expensive hardware and higher maintenance cost in standard hot standby scheme of coal mine monitoring and control system,the paper designed a hot standby system with pure software mode.The system uses combinations of file differential backup and MYSQL incremental backup to store data in main and standby computer,that is,using RSYNC file synchronization algorithm to backup file,using Binary Log mechanism of MYSQL database to open a log file,exporting modified data in a period to incremental backup file and sending incremental backup files to standby computer,and the standby computer introduces the data into database,so as to achieve synchronization operation of database.In the same way,modified data in the standby computer was synchronized to the main computer when the main computer has fault.The hot standby system has been applied in coal enterprises and meets with requirements of real-time and completeness of the data in coal mine momitoring and control system.