PostgreSQL with Replication
PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages).
This solution uses multiple VMs, 4 nodes by default, to provide a highly available and fault tolerant deployment. Data automatically replicates from the primary node to all other nodes.
Advantages of Using a Bitnami Solution:
- Up to date: We track every Postgres release and update our implementation promptly afterward.
- Secure: If serious security issues are discovered, we provide new versions the application as soon as possible, often within hours of the availability of a fix.
- Consistent: All apps and dev environments are packaged and configured consistently across operating systems.