上位机历史数据库的HA改进  

The HA Improvement of Historical Database in Upper Machine

作　　者：吴建伟[1] 麻红昭[2] 张伟[2] 张华[2] 

机构地区：[1]浙江大学材料与化学工程学院,杭州310027 [2]浙江大学智达信息工程研究所,杭州310027

出　　处：《化工自动化及仪表》2007年第4期45-48,共4页Control and Instruments in Chemical Industry

摘　　要：针对控制系统中上位机HM I软件单一历史数据库可靠性不高、最大历史数据量不能超过2G的限制,探讨了一种低成本的PostgreSQL历史数据库替代方案。以两台普通微机组成集群,并在其上实现了基于Slo-ny-I的历史数据库双机实时热备系统。这一"高可用集群"[H igh-Availab ility(HA)C luster]配置方案极大地提高了历史数据的安全性。To solve the problem of low security with single history database and the maximum data quantity less than 2G in HMI software of upper machine, one substitutable project was discussed. The project which was low cost adopts PostgreSQL as history database. The history database dual PC real time hot backup based on Slony-Ⅰ was realized on the cluster which consists of two common PC. This High-Availability（HA） cluster configuration project improves the security of history database.

关 键 词：历史数据库 POSTGRESQL 双机实时热备 Slony—Ⅰ 高可用集群(High—Availability Cluster) 

分 类 号：TP31[自动化与计算机技术—计算机软件与理论]