Support for SSL encryption on external ports
VoltDB now supports Secure Socket Layer (SSL) encryption for all externally accessible ports, not just the HTTP port. With SSL enabled, data passing through both the client and admin ports is encrypted. See the section on using SSL encryption in the VoltDB Administrator’s Guide for details on setting up SSL for a VoltDB cluster.
Ability to retrieve the schema, procedures, and configuration from a database
Three new VoltDB commands have been added that allow you to extract the schema, stored procedures, and configuration from the local database root directory. These commands can be used whether the database is running or not. The new commands are:
voltdb get schema
voltdb get classes
voltdb get deployment
New statistics provide performance details about individual statements within a procedure
A new selector, PROCEDUREDETAIL, for the @Statistics system procedure provides detailed performance information about the execution of individual statements within stored procedures. See the description of the @Statistics system procedure in the Using VoltDB manual for details.
New system procedure lets you swap two tables
A new system procedure, @SwapTables, lets you swap the contents of two tables. The two tables must have the identical schema (that is, the same column names, datatypes, and constraints) and cannot have views defined. See the description of the @SwapTables system procedure in the Using VoltDB manual for details.
Ability to restart a partial cluster
It is now possible to restart a K-safe cluster with fewer than the original number of nodes. For example, if one server fails on a five-node cluster and you want to restart the cluster but the failed server is not ready, you can start the cluster with the remaining four nodes by using the –missingargument on the voltdb start command, like so:
$ voltdb start –count=5 –missing=1
Note that the partial cluster is not fully K-safe to its specified K-safety value until the full complement of nodes rejoin the cluster. See the description of the voltdb command in the Using VoltDB manual for details.
New SQL functions for handling internet addresses
There are four new SQL functions to convert internet addresses from text strings to binary and back again. Two functions (INET_ATON and INET_NTOA) convert IPv4 addresses and two (INET6_ATON and INET6_NTOA) convert IPv6 addresses. See the Appendix of SQL Functions in the Using VoltDB manual for details.
SNMP traps now report database replication (DR) events
VoltDB can send SNMP traps for selected database events, such as node failures or when resource limits are reached. Starting with V7.1, it also reports database replication (DR) events when DR is enabled.