Installation

  1. Download comunity edition and install deb file
  2. Start Server
voltdb create
  1. Execute voltdb cli
sqlcmd
  1. Create Table
Create table test_table ( column1 varchar(10));
  1. Inser new row
insert into test_table values('test data');
  1. Query Table
select * from test_table;

Data Storage

After restart voltdb server, all saved data will be clear.

Reserved TCP Ports

Default Port Description
21212 Client Port
21211 Admin Port
8080 Web Interface Port (httpd)
3021 Internal Server Port
4560 Log Port
9090 JMX Port
5555 Replication Port
7181 Zookeeper port

Refrence

EBook Fast Data

VoltDB Documentation

Share:
Reading time: 1 min
Name DB2 MySQL Oracle Percona Server VoltDB
Description Common in IBM host environments, 2 different versions for host and Windows/Linux Widely used open source RDBMS Widely used RDBMS Enhanced drop-in replacement for MySQL based on XtraDB storage engine with improved performance and additional diagnostic and management features. Distributed In-Memory NewSQL RDBMS
Database model Relational DBMS Relational DBMS Relational DBMS Relational DBMS Relational DBMS
License commercial, free version is available Open Source, GPL version 2. Commercial licenses with extended functionallity are available commercial, restricted free version is available Open Source, GPL version 2 Open Source, GPL version 3 for Community Edition, commercial license for Enterprise Edition
Implementation language C and C++ C and C++ C and C++ C and C++ Java
Server operating systems Linux,Unix,Windows,z/OS FreeBSD,Linux,OS X,Solaris,Windows AIX,HP-UX,Linux,OS X,Solaris,Windows,z/OS Linux Linux,OS X
Data scheme yes yes yes yes yes
Typing yes yes yes yes yes
Secondary indexes yes yes yes yes yes
SQL yes yes yes yes yes
APIs and other access methods JSON style queries,XQuery,ADO.NET,JDBC,ODBC ADO.NET,JDBC,ODBC ODP.NET,Oracle Call Interface (OCI),JDBC,ODBC ADO.NET,JDBC,ODBC,Java,API RESTful HTTP/JSON API,JDBC
Supported programming languages C,C#,C++,Cobol,Fortran,Java,Perl,PHP,Python,Ruby,Visual Basic Ada,C,C#,C++,D,Eiffel,Erlang,Haskell,Java,Objective-C,OCaml,Perl,PHP,Python,Ruby,Scheme,Tcl C,C#,C++,Clojure,Cobol,Eiffel,Erlang,Fortran,Groovy,Haskell,Java,JavaScript,Lisp,Objective C,OCaml,Perl,PHP,Python,R,Ruby,Scala,Tcl,Visual Basic Ada,C,C#,C++,D,Eiffel,Erlang,Haskell,Java,Objective-C,OCaml,Perl,,PHP,Python,Ruby,Scheme,Tcl C#,C++,Erlang,Java,JavaScript,PHP,Python,Ruby
Server-side scripts yes yes PL/SQL yes Java
Triggers yes yes yes yes no
Partitioning methods Sharding horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric horizontal partitioning Sharding
Replication methods yes Master-master replication, Master-slave replication Master-master replication, Master-slave replication Master-master replication, Master-slave replication,XtraDB Cluster Master-slave replication
MapReduce no no no no no
Consistency concepts Immediate Consistency Immediate Consistency
Foreign keys yes yes yes yes
Transaction concepts ACID ACID ACID ACID ACID
Concurrency yes yes yes yes yes
In-memory capabilities yes yes
Durability yes yes yes yes yes => Snapshots and command logging
Horizontal scalable no yes yes yes yes
Value size max. 10 B 4 B 2 EB
Memory minimum 256 MB 11 MB 512 MB ? 4 GB
Data Storage File System, Volatile memory File System, Volatile memory ASM, File System File System Volatile memory, File System,Data Persisted to Disk
Share:
Reading time: 2 min