GridGain Enterprise Edition 7.8 adds Support of In-Memory SQL Grid and Advanced GridGain Web Console Features

Introducing GridGain Enterprise Edition 7.8, available for download now (includes a free 30-day trial), featuring enterprise-level tools like the GridGain Web Console Management and Monitoring tool built atop of the Apache® Ignite™ Web Console. Features include high availability and fault tolerance with a GridGain Web Console deployment, queries monitoring and cancellation, usage tracing and more.

This latest edition's foundation was constructed around the recently launched GridGain Professional Edition 1.8 (based on Apache® Ignite™ of the same version). The great news for our Enterprise Edition users: you now benefit from an absolutely new GridGain In-Memory SQL Grid component and Data Modification Language (DML) support.

Let's make a brief overview of these major enhancements in version 7.8.

In-Memory SQL Grid with DML

The In-Memory SQL Grid adds in-memory distributed database capabilities to the GridGain platform, which dramatically speeds up and scales out SQL applications with minimal or no code changes. The In-Memory SQL Grid is horizontally scalable, fault tolerant and ANSI SQL-99 compliant. It fully supports SQL and DML commands including SELECT, UPDATE, INSERT, MERGE and DELETE queries.

GridGain Enterprise Edition 7.8 improves support for SQL Grid

The In-Memory SQL Grid allows users to interact with the GridGain platform using standard SQL commands through the JDBC or ODBC drivers without custom coding. In addition to natively supported Java,.NET, and C++ libraries, the JDBC and ODBC drivers' capabilities allow SQL-based cross-platform connectivity from languages such as Ruby, PHP, Python, and more.

To learn more about this unique distributed SQL engine, check out my In-Memory SQL Grid webinar from March 15. The related documentation has more examples is also available.

GridGain Web Console High Availability and Fault Tolerance

The GridGain Web Console is a light-weight web-based configuration wizard, management, and monitoring tool. The tool facilitates a preparation of your GridGain cluster configuration, simplifies a migration from a relational database-based architecture, allows monitoring a state of the cluster and executing SQL queries and more.

It's easy to start with the console by using a deployment hosted on a GridGain infrastructure. Just go to, sign up, connect to your cluster and give it a try using all of the capabilities available.

Eventually, when you choose to host an instance of GridGain Web Console on own infrastructure or on a preferable cloud environment, then HA and fault tolerance capabilities are something you'll need to consider. In a nutshell, it's easy to deploy multiple copies of the Web Console in your environment -- and in a situation in which a primary instance goes down, one of the copies will automatically take over, catching up and serving all the requests avoiding any downtime. Learn more details from the related documentation.

Query History, Monitoring, and Cancellation

You can immediately connect to a cluster from the GridGain Web Console and run, let's say, SQL queries from the console's interface. You can also analyze query execution plans and view in-memory schemas of distributed caches.

Starting from GridGain Enterprise Edition 7.8 it's feasible to go back and look into the query execution history that reports on a variety of metrics -- such as a query's total, average and maximum execution times, the last time the query was run against the cluster and more. Having this information at your fingertips enables you to root out long-running queries or simply spot and optimize them.


The new queries monitoring tab shows currently running queries and allows the stopping of any of them if you see that a query consumes a lot of resources or is inefficient.

By default, the query history and monitoring is disabled in a cache configuration. To activate the feature you need to set a non-zero value for the history size using the following configuration parameter:


The same can be accomplished with the GridGain Web Console configuration wizard by typing a value into "History Size" text box as it's shown on the picture below:


Usage Tracing With GridGain Web Console

Another GridGain Web Console-related feature that became available in the release of GridGain Enterprise Edition 7.8 is the usage tracking of your GridGain Web Console deployment. If you're an IT administrator you will be able to see how your colleagues interact with the cluster from the console side.


Wrap Up

Do any of the features covered in this blog post kindle your curiosity? Don't resist! Go to the GridGain site and download the latest GridGain Enterprise Edition 7.8 version and play around with GridGain Web Console deployment. Have any questions? Just ask below!