Abstract: At present, three centers geographically dispersed in two locations have become the main mode for the construction of large enterprise data centers, providing enterprises with a more secure, stable, and efficient information platform, ensuring the safe and efficient operation of enterprise information systems, and meeting the requirements for business continuity in different fault and disaster scenarios. Based on the open-source relational database management system PostgreSQL and the open-source distributed coordination service ZooKeeper, this article proposes a design of the architecture of highly available databases for three centers geographically dispersed in two locations, which can achieve distributed transaction consistency and high availability of the database in fault scenarios. Test cases of common fault scenarios are conducted to verify the design and it is shown that the databases for three centers geographically dispersed in two locations deployed according to this architecture can automatically perform fault isolation with zero data loss when common faults occur, and can provide continuous and stable data access services without affecting upper level business. The database architecture design is cost-saving in software , transparent, reliable, and highly secure, and can be customized according to actual needs. In addition, the use of server local disks instead of centralized storage as data storage media is beneficial for reducing database construction and operation costs.