VoltDB v3.2 has been released

VoltDB v3.2 has been  released and can be downloaded here: http://voltdb.com/community/downloads.php

Changes include:

  • Enhanced Support for Live Schema Updates
  • Improved Performance and Resilience of Catalog Updates
  • New Return Status for Snapshot Restore
  • hange to the Default Heartbeat Timeout


The following issues have been fixed:

  • Automated snapshots and node failure

    It was possible for automated snapshots to silently stop occurring after a node failed and rejoined the cluster. This did not happen all the time, but could not be corrected without restarting the cluster. This issue has been corrected.

  • The sqlcmd command and stored procedure names

    Previously, the sqlcmd command line tool could not invoke a stored procedure if the procedure name started with a SQL statement keyword, such as “select” or “delete”. This issue has been corrected.

  • Enterprise Manager fails to recognize cluster changes

    In recent versions of VoltDB, it was possible for the Enterprise Manager to start a database cluster but not recognize when the database completed startup. Similarly, if a node failed to rejoin or a recover operation did not complete the Enterprise Manager might not recognize these conditions. The symptom in all cases was that the database or server icon would not stop “spinning” in the Enterprise Manager control panel. These issues are now fixed.

Nine Databases in 45 Minutes

From http://www.datanami.com/datanami/2012-12-04/nine_databases_in_45_minutes.html


The following video provides a crash course in nine key databases:  Postgres, CouchDB, MarkLogic, Riak, VoltDB, MongoDB, Neo4j, HBase and Redis. All in just 45 minutes.

Miles Pomeroy, Chad Maughan, and Jonathan Geddes run through each database in five minutes each, thus the title, “9 Databases in 45 minutes.” The video proceeds in efficient and occasionally amusing fashion, where a countdown clock and a gong keep the presentations terse.

Announcing VoltDB v3.0

Few days after official release 2.8.2, VoltDB is already  annoucing its next major release: VoltDB v3.0


What is VoltDB v3.0?

The VoltDB v3.0 release includes a set of user-visible features, including new SQL (specifically column functions), ad hoc SQL execution performance, Export enhancements, online schema changes, and a more streamlined application development process.  Under the covers, however, VoltDB v3.0 includes a new transaction coordination architecture that reduces latency and improves transaction throughput.

We’ve worked hard over the past 6 months to reduce overhead within the VoltDB cluster by streamlining transaction and query processing.   As part of this release, we’ve significantly reduced intra-node communication and also eliminated our dependency on synchronized clocks (via NTP) between cluster nodes for user transaction processing.

As a result, VoltDB v3.0 offers significantly higher throughput and lower latency, as well as offering easier installation and configuration, particularly in the cloud.

Immediate benefits of VoltDB v3.0 include the following:

  • Lower overall latency
  • Higher throughput
  • Scale-out improvements – clusters with larger numbers of nodes
  • Scale-up improvements – nodes with 10gE and more CPUs
  • Low latency synchronous Client API
  • Client affinity (for writes)
  • Elimination of dependency on NTP

How Can You Get the VoltDB v3.0 Technical Preview?

The VoltDB v3.0 Technical Preview is available on a per-request basis immediately.  To request a copy, please email us atbetasupport@voltdb.com.  Note that this is a preview release and should only be used for evaluation purposes – it should not be put into production.

We are planning an open beta in November on a functionally complete code base, with plans to release VoltDB v3.0 at the end of this year.

The VoltDB v3.0 Technical Preview supports all current v2.8 functionality, including full durability with snapshots and command logging and ad hoc query throughput performance.   It’s nearly a fully functional VoltDB database with the exception that the following functionality is not yet supported:

  • Partition Detection
  • Live Node Rejoin
  • Database Replication

Partition detection and live node rejoin will be available in our open Beta in November.
Under The Covers of the VoltDB v3.0 Architecture

VoltDB v3.0 comprises an architectural change to the transaction serialization implementation within a VoltDB cluster. Specifically, the VoltDB transaction coordination strategy has been re-architected and significantly improved.  In VoltDB versions 1.x and 2.x, transactions were globally ordered and ordered according to time. Each node on the cluster communicated with every other node to agree upon transaction ordering.  Maintaining a global agreement based on time caused VoltDB to incur additional latency – intra-node communication agreement involving all nodes. This architecture required users to synchronize cluster node clocks using NTP, because any time drift between nodes would introduce artificial, unneeded latency to the system.  This overhead, and the strict need to maintain clock synchronization has been eliminated from the VoltDB v3.0 code base.

For a deeper dive into the technology that makes VoltDB v3.0 tick, please see the following blog posts:

What to Expect from the VoltDB Technical Preview

Interacting with VoltDB v3.0 should feel similar, on the surface, to VoltDB v2.x.  Simply install the preview kit, rebuild your application catalog, and run your VoltDB application.

Should you find any unexpected behavior, please let us know via the VoltDB forums, or by dropping us an email atbetasupport@voltdb.com.  We’d love to hear our feedback – thanks for your interest in VoltDB.

VoltDB 2.8.2 has been released

VoltDB 2.8.2 is out and can be downloaded here


Changes for 2.8.2 version:

Enabling Security Moved from the Project to the Deployment File
The configuration option that turns security on and off for a database has been moved from the project definition file to the deployment file. In other words, you now choose whether to enable security when you start VoltDB, rather than when you compile the schema.


This is a change to the application catalog. When starting a database from an older catalog, the security setting in the catalog will be ignored. All database applications that utilize VoltDB security features are strongly encouraged to make appropriate changes and recompile their catalog.

1.2. New String Functions Supported
VoltDB now supports several additional string functions in SQL queries, including CONCAT(), LEFT(), RIGHT(), REPEAT(), and SPACE(). See the appendix on SQL functions in theUsing VoltDB manual for details.
1.3. New Statistics Available
New statistics are available from the @Statistics system procedure by using the keyword “PLANNER”. Significant improvements have been made to the performance of ad hoc queries over the past few releases. Some improvements come from intelligent detection and routing of single-partition queries; other improvements come from caching ad hoc query plans to avoid re-planning recurring or similar queries. The PLANNER statistics provide information about the size and usage of the ad hoc planner cache. See the description of @Statisticsin the Using VoltDB manual for details.
1.4. Stricter Parsing of Export Tables in the Schema
Since export tables are for write only and are not materialized in the database, indexes have no effect. However, in previous versions VoltDB silently ignored indexes and primary keys defined on export tables. Starting with this release, the VoltDB compiler rejects such indexes. This change may result in schemas that previously compiled being rejected. The solution is to remove the offending indexes or primary keys from export tables.
1.5. Setting Additional Java Properties in VoltDB Enterprise Manager
The Enterprise Manager provides an interface for configuring many of the options related to the VoltDB processes that the management console starts. However, previously it was not possible to set arbitrary Java properties for these processes. It is now possible to pass the Enterprise Manager a string of Java options, as the environment variable VOLTDB_OPTS, that will be used when the Enterprise Manager starts server processes. See the appendix on Server Configuration Options in the VoltDB Management Guide for details.

VoltDB 2.7.2 has been released

VoltDB 2.7.2 has been released and is available for community download.


Users of previous versions of VoltDB should take note of the following changes that might impact their existing applications.

1.1. Ability to Batch Multiple Ad Hoc Queries
The @AdHoc system procedure now allows you to submit multiple individual queries — separated by semicolons — in a single procedure call. The queries are performed as a single transaction; that is the queries all succeed as a group, or all queries are rolled back if any one of them fails.
1.2. Additional Capabilities for the LIKE Function
The LIKE function now supports arbitrary pattern matching. Previously, LIKE only supported matching prefixes; that is, patterns that consist of a text prefix followed by the percent sign wildcard. LIKE now supports wildcards anywhere in the pattern, including both the percent sign (for zero or more characters) and underscore (for a single character).
1.3. New SUBSTRING Function
The SUBSTRING function is now available in SQL queries. The syntax of the SUBSTRING function is the following:

SUBSTRING({string-expression} FROM {position} [FOR {length}] )

Where position specifies the starting position of the substring (starting at position 1) and length specifies the maximum length of the substring.

1.4. New Utility for Loading CSV Data
There is a new shell command, csvloader, for loading data from a CSV file into a VoltDB table. For example, the following command loads data from a CSV table, contestants.csv, into the CONTESTANTS table from the voter sample application.

$ csvloader CONTESTANTS -f contestants.csv

See the Appendix on CLI Commands in the Using VoltDB manual for details.


VoltDB 2.5 has been released

VoltDB 2.5 has been released, its a major milestone introducing big changes regarding database replication, performance, Node.js and even more:


  • Database Replication.  Version 2.5 introduces a new feature called Database Replication that allows VoltDB databases to be automatically replicated within and across data centers.  Available in the VoltDB Enterprise Edition, Database Replication ensures that every database transaction applied to a VoltDB database is asynchronously applied to a defined replica database.  Following a catastrophic crash, a systems administrator can immediately promote the database replica to master status and redirect all traffic to that cluster.  Once the original master has been recovered, the process can be quickly and easily reversed.

    In addition to serving disaster recovery needs, Database Replication can also be used for workload optimization.  Write traffic can be directed to the master VoltDB database, and read traffic can be directed to the replica.  This usage pattern provides optimal performance for both write and read workloads.

  • Performance improvements.  Version 2.5 includes performance improvements to the VoltDB SQL planner, which benefit all VoltDB products.  In addition, the VoltOne product has been optimized to significantly reduce transaction latencies.
  • Functional enhancements.  Version 2.5 includes expanded support for SQL syntax and semantics, and extends VoltDB’s support for distributed database joins.  Based on customer input, version 2.5 also adds new administrative options for managing database snapshots and controlling the behavior of command logging activities.
  • Updated Node.js support.  VoltDB version 2.5 includes a client driver for the Node.js programming framework.  This driver, which was originally created by a VoltDB open source community member, provides access to VoltDB-managed data for Node.js applications.  The updated Node.js driver includes performance optimizations, bug fixes and modifications that align the driver with Node.js coding standards.

“Our customers rely on VoltDB to support their high velocity transactional applications, perform realtime analytics and data operations with blazingly fast performance” said VoltDB CEO Bruce Reading.  “VoltDB 2.5 allows for enhanced durability of customer applications, even in the presence of catastrophic systems failures, and introduces enhanced developer features for Node.js applications.”  Added Reading, “Organizations utilize VoltDB for applications that require blazing throughput, linear scale, enterprise grade durability as well as complete fault tolerance.  With the introduction of VoltDB 2.5, we have set the new standard for high velocity database management.”

Product Availability
VoltDB 2.5 is available immediately.  VoltDB Enterprise Edition includes Database Replication and other features needed to deploy and manage enterprise-class database applications.  VoltDB Community Edition, which contains all features needed to develop VoltDB applications, is available for free under the GNU General Public License (version 3).  All VoltDB software products, client libraries and documentation are available for download from the Company’s website atwww.voltdb.com.

The Company will be hosting a live webinar to introduce the VoltDB 2.5 feature set on April 17, 2012, at 2:00pm EDT.  Details and registration information are available at https://www3.gotomeeting.com/register/918142014.

VoltDB 2.0 introducing command logging

VoltDB 2.0 will introduce a new feature named “Command Logging” , briefly, Command logging incorporates and extends VoltDB’s Snapshots feature to provide 100% durability and availability for VoltDB databases. Command logging keeps a record of every transaction (that is, stored procedure) as it is executed. Then, if the servers fail for any reason, the database can restore the last snapshot and “replay” the subsequent logs to re-establish the database contents in their entirety.


VoltDB 2.0 Beta program is now open to all developers: http://voltdb.com/get-voltdb-20-beta





VoltDB 1.3.4 has been released

VoltDB, had recently announced the release of VoltDB Integration for Hadoop.  The new product functionality, available in VoltDB Enterprise Edition, allows organizations to selectively stream high velocity data from a VoltDB cluster into Hadoop’s native HDFS file system by leveraging Cloudera’s Distribution Including Apache Hadoop (CDH), which has SQL-to-Hadoop integration technology, Apache Sqoop, built in.

The version 1.3.4 has just been release and is available as an enterprise edition (hadoop integration) as weel as community edtion:


Webinars developing .NET and C# applications for VoltDB

VoltDB’s rich .NET C# client library provides high-performance, and native support for Windows-based clients. After a primer on the basics of building C# WinForm applications and services backed by a VoltDB database cluster, the presentation dives into specific topics such as advanced UI integration and DataBinding. As a practical example, we unveil a new “mini-SQL Management Studio” for VoltDB built entirely in C# and leveraging the VoltDB .NET client library.


Access VoltDB webinars  on Developing .NET and C# applications for VoltDB


VoltDB Studio

VoltDB Studio is very cool Windows tool for VoltDB developers,its available for  download right there.