Questions tagged [voltdb]

VoltDB is an in-memory database designed by several well-known database system researchers, including Michael Stonebraker. It is an ACID-compliant RDBMS which uses a shared nothing architecture. It includes both enterprise and community editions. VoltDB implements the design of the academic H-Store project.

VoltDB is a NewSQL relational database that supports SQL access from within pre-compiled Java stored procedures. The unit of transaction is the stored procedure, which is Java interspersed with SQL. VoltDB relies on horizontal partitioning down to the individual hardware thread to scale, k-safety (synchronous replication) to provide high availability, and a combination of continuous snapshots and command logging for durability (crash recovery).

VoltDB is designed to take full advantage of the modern computing environment:

  • VoltDB uses in-memory storage to maximize throughput, avoiding costly disk access.
  • Further performance gains are achieved by serializing all data access, avoiding many of the time- consuming functions of traditional databases such as locking, latching, and maintaining transaction logs.
  • Scalability, reliability, and high availability are achieved through clustering and replication across multiple servers and server farms.
156 questions
1
vote
1 answer

Can you browse a running VoltDB database?

I have been using MySQL for years and have decided that for a new project I'd like to use something newer liker Volt DB. I have read all the documentation on the Volt DB website and although it mentions a web client for viewing the structure it…
JonathanBristow
  • 1,066
  • 2
  • 13
  • 36
1
vote
2 answers

Voltdb Partitioning

Lets say I have a table id col1 col2 col3 1 ABC DEF XYZ 2 XXX YYY ZZZ Most frequent queries is going to be SELECT * from XYZ where col1='abc' and col2='def' SELECT * from XYZ where col1='abc' and…
Jack Daniel's
  • 2,583
  • 22
  • 28
1
vote
1 answer

VoltDB JDBC Driver always crashes due to OutOfMemory error

I was trying to connect to voltdb via JDBC API, but always get OutOfMemoryError. I know, i can get rid of it by increasing heap size, but i want to know, why it require large heap size? I already have 1028M set as Heap size. Exception in thread…
RickDavis
  • 2,276
  • 6
  • 25
  • 31
1
vote
2 answers

Voltdb + gwan with c++

I have decided use GWAN like my application server and I wish use voltdb for storage the data. Anybody has employed both together?. I will develop it in C++.
1
vote
2 answers

YCSB for VoltDB

Does anyone know is there any implementation of YCSB client/driver available for benchmarking VoltDB? Or even any reference publications/blog/article/research project? Can we use TPC workloads for VoltDB benchmarking? Thanks a lot everyone.
Joarder Kamal
  • 1,387
  • 1
  • 20
  • 28
1
vote
2 answers

Does VoltDB fully support ACID on multi-partition (or global) transactions?

My current experience with databases is mainly with MS SQL, MySQL and oracle. I've been looking around at some of the more scalable alternatives (many NoSQL solutions) when I stumbled upon VoltDB. It looks quite interesting since it maintains the…
James k
  • 242
  • 2
  • 8
0
votes
3 answers

Do database stored procedures suffer from poor performance when returning large volumes of data?

Under VoltDB Don'ts http://community.voltdb.com/DosAndDonts They state Don't create queries that return large volumes of data (such as SELECT * FROM FOO with no constraints) especially for multi-partition transactions. Be conservative in the…
deltanovember
  • 42,611
  • 64
  • 162
  • 244
0
votes
0 answers

How to install voltdb in ubuntu

I want to install voltdb but its showing python3 not installed after installing python its showing start but not start with localhost.so what to do whereis python3 python3: /usr/lib/python3 /etc/python3 /usr/share/python3…
ashima
  • 1
0
votes
0 answers

get affected rows count in voltdb node client results?

I have written a stored procedure and called it from the voltdb node client. I am getting following…
V0idHat
  • 36
  • 2
0
votes
1 answer

How to drop existing constrain on colum in Voltdb with LiquideBase

I'm working with Vold DB and Liquid base. I have one existing table with all column having nullable=false constrain LiquidBase Code
0
votes
1 answer

Kinds of multi-partitioned stored procedures and will they still lock the entire cluster in VoltDB 9?

I try to understand the impact of multi-partitioned transactions in VoltDB 9.x. I know it is designed for single-partioned transactions, but I want to know what it will cost me if I can't avoid it. In summary, my question is whether it is still the…
0
votes
0 answers

GRPC server does not release DB connection

I am working on a Go project which use gRPC as server and Voltdb as DB. I have an issue when sending many DB read/write requests to gRPC server. Request has been handled but it does not release DB connection after finishing operator. So when…
Vuong
  • 37
  • 6
0
votes
1 answer

setting TopologyChangeAware on jdbc voltdb client

I am making a jdbc connection to voltdb, how to make this connection TopologyChangeAware. over here i am using Hikari.
recursion
  • 354
  • 6
  • 11
0
votes
1 answer

How to get result of query in VoltDB

I have a VoltDB database with a table. I want get the result of my VoltDB stored procedure. This is the code import org.voltdb.*; public class isola extends VoltProcedure { public final SQLStmt getLeast = new SQLStmt(" SELECT codice FROM prova…
andrea5
  • 77
  • 2
  • 11
0
votes
1 answer

Voltdb stored procedures with array parameters

I have a VoltDB stored procedure that takes a string array String[] and it's loaded successfully but I cannot seem to execute the stored procedure using the VoltDB SQL query interface with exec. Cannot also execute it in sqlcmd interface. I get…
Tega
  • 47
  • 6