We are excited to announce that MemSQL 2.5 is now available for download.  Of the many new features and performance improvements, one of the most exciting is support for JSON analytics. With native support for the JSON datatype, MemSQL delivers a consolidated view across structured and semi-structured data in real-time.

Using MemSQL 2.5, developers can use SQL to easily analyze JSON objects while quickly ingesting JSON data feeds. In addition, MemSQL 2.5 ships with support for ONLINE ALTER TABLE, which means that you can make changes to your production schemas without any downtime. MemSQL 2.5 enables rapid application prototyping,  updating data models on the fly, and otherwise eliminates downtime.

The list of upgrades in MemSQL 2.5 includes:

JSON Data Type

MemSQL 2.5 supports JSON as a column type, which enables developers to store and query structured and semi-structured data together in one database. MemSQL JSON integration provides the following features:

  • Use standard SQL functions with JSON, including built-ins, GROUP BY, JOINs, and more.

  • Create JSON indexes online.

  • Client drivers require no changes to support JSON.

  • JSON properties are updatable.

  • JSON columns can contain ‘null’, ‘true’, ‘false’, double-precision floating-point values, quoted strings, heterogeneous arrays, and/or nested JSON objects.

Improved Index and Scan Performance

MemSQL 2.5 performs 3x faster over large datasets, enabling scans of over 30 million rows per second per core.

Online “ALTER TABLE”

MemSQL 2.5 supports online “ALTER TABLE” operations (“ADD [COLUMN]”, “DROP [COLUMN]”, and “ADD {INDEX|KEY}”) on distributed tables. The table is available for reads and writes while “ALTER TABLE” executes. The memory overhead of online ALTER TABLE is only a few megabytes, regardless of the table size.

Online Backup and Restore

MemSQL 2.5 offers single commands to backup and restore a cluster. “BACKUP DATABASE” takes a point-in-time snapshot of data across the cluster while your read and write workloads continue to run. “RESTORE DATABASE” restores an entire distributed database. The new cluster can have a different number of nodes or different redundancy level from the original.

SQL Support

MemSQL 2.5 supports the following operations on both standalone and distributed tables:

  • Scalar subselects, subselects with EXISTS and IN

  • Constants are parameterized in projections, as well as ORDER BY and GROUP BY clauses

  • UNION ALL, GROUP_CONCAT, various built-in functions, and expression performance improvements

  • Persisted computed columns on arbitrary SQL expressions

Please visit www.memsql.com to learn more about MemSQL 2.5 and to download a free trial.