PostgreSQL High Availability

Sparky

老会员

普通会员

Rank: 1

社区积分: 0
技术积分: 87

大中小 1楼

2008-1-8 15:06 只看该作者

PostgreSQL High Availability

http://www.postgresql.org/docs/8.2/static/high-availability.html

客户可以提共SAN，所以我考虑采取“Shared Disk Failover“：

Shared disk failover avoids synchronization overhead by having only one copy of the database. It uses a single disk array that is shared by multiple servers. If the main database server fails, the standby server is able to mount and start the database as though it was recovering from a database crash. This allows rapid failover with no data loss.

Shared hardware functionality is common in network storage devices. Using a network file system is also possible, though care must be taken that the file system has full POSIX behavior. One significant limitation of this method is that if the shared disk array fails or becomes corrupt, the primary and standby servers are both nonfunctional. Another issue is that the standby server should never access the shared storage while the primary server is running.

但是我还要做Linux HA (heartbeat & ip takeover)，这样active node fail时passive node可以take over，那位给点建议？急用，谢谢了。