The GridGain in-memory computing platform can significantly improve the performance and scalability of applications built on MySQL. GridGain is deployed as a cluster of commodity servers between your MySQL database and your application layer. GridGain integrates seamlessly with your MySQL database and, through the GridGain Unified API, with your application. The GridGain In-Memory SQL Grid allows you to communicate with the GridGain cluster using standard SQL through the ODBC/JDBC API.
Your data is uploaded from your MySQL database into the RAM in your GridGain cluster nodes. By holding data in memory and by distributing the compute load across the cluster via the GridGain In-Memory Compute Grid, processing speeds are improved 1,000x or more. You can scale the capacity of your GridGain in-memory cluster by adding nodes to your GridGain cluster where the automatic rebalancing system will redistribute data to the new node for optimal grid performance. This allows you to effectively scale out your MySQL database without manually sharding your database.
GridGain is ANSI SQL-99 compliant and offers ACID compliant transactions. Writes from your application layer are made to the data in your GridGain cluster and then written to your MySQL database. You can therefore benefit from the speed and scalability of in-memory computing while retaining MySQL as your underlying database.
GridGain is built on the open source Apache® Ignite™ project. The GridGain Professional Edition is a supported, production-ready version of Apache Ignite. 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 Ultimate Edition includes cluster snapshot backups which are highly valuable when deploying the GridGain Persistent Store feature in production.
Learn more about using the GridGain in-memory computing platform with MySQL by watching our joint webinar presented by Nikita Ivanov of GridGain Systems and Peter Zaitsev of Percona entitled "Accelerate MySQL® for Demanding OLAP and OLTP Use Cases with Apache® Ignite™" You can also read the white paper.