Create a Distributed PostgreSQL Database with In-Memory Computing for Performance and Scalability
The GridGain® in-memory computing platform is deployed as a cluster of commodity servers between your PostgreSQL database and application layer. GridGain integrates seamlessly with your PostgreSQL databases and, through the GridGain Unified API, with your application. Your data is uploaded from your PostgreSQL databases into the memory in your GridGain cluster where processing is 1,000x faster than from disk. You can scale the capacity of your GridGain in-memory computing cluster by adding nodes to the cluster, enabling you to scale the size of your distributed PostgreSQL database without sharding.
GridGain is ANSI SQL-99 compliant and offers ACID transactions. Writes from your application layer are made to the data in your GridGain cluster and then written to your PostgreSQL database. You can benefit from the in-memory speed and massive scalability of in-memory computing while retaining PostgreSQL as your underlying database.
GridGain is built on the open source Apache® Ignite™ project. The GridGain Enterprise Edition is a supported version of Apache Ignite which includes all of the Ignite features plus enterprise-grade features for enhanced management, monitoring, and security. The GridGain Community Edition, built on Apache Ignite, includes patches and updates not yet released in Ignite with additional features and QA testing to provide the highest possible performance, reliability and managability possible in an open source in-memory computing platform. The GridGain Ultimate Edition includes backup and recovery features which are highly valuable when deploying GridGain as an in-memory database using the Persistent Store feature in production.
Learn about using the GridGain in-memory computing platform with open source databases by watching our webinar recordings including:
- Postgres with Apache Ignite: Faster Transactions and Analytics
- Accelerate MySQL® for Demanding OLAP and OLTP Use Cases with Apache® Ignite™
You can also read the "Accelerate MySQL® for Demanding OLAP and OLTP Use Cases with Apache® Ignite™" white paper.