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
0
votes
2 answers

Setup VoltDB Cluster IP

Trying with VoltDB cluster, created a cluster of 2 nodes with k=1 Cluster initialization was successful, both the nodes are up. Now, how do i connect to this cluster, i could not find any documentation to setup single IP for cluster. Will the client…
SamTech
  • 1,305
  • 2
  • 12
  • 22
0
votes
2 answers

Error while passing multiple parameters as array in voltdb Adhoc stored procedure

I have a scenario where I am getting a SQL query and SQL arguments (to avoid SQL injection) as input. And I am running that SQL using VoltDB's AdHoc stored procedure using below code. private static final String voltdbServer = "localhost"; private…
Naresh Joshi
  • 4,188
  • 35
  • 45
0
votes
1 answer

the time that now() function returns is different from system time

I get result as follow when I execute a sql which includes now()function in VoltDB select * from test2; C1 --------------------------- 2019-06-29 07:13:38.050000 But,I get another time when I execute a shell command…
Xu Zhenxue
  • 15
  • 4
0
votes
1 answer

Is Java 11 Really Supported in VoltDB 9.0?

I am currently having to cross compile only a couple JARs targeting Java 8 (in my Java 11 application) because VoltDB only supported loading Java 8 JARs during DDL up to volt 8.4.x. Ideally, I would like to only use Java 11 as Java 8 is no longer…
0
votes
1 answer

Cannot connect to VoltDB over network

I am getting started with VoltDB. Running VoltDB community on a server in LAN. Server initialization completed as reported after server start Build: 9.0 voltdb-9.0-0-g6aae38a-local Community Edition Loaded node-specific settings from…
SamTech
  • 1,305
  • 2
  • 12
  • 22
0
votes
1 answer

sqldeveloper + voltdb connection

I want to create a database connection for voltdb using sqldeveloper like mysql,db2.. but didnt do it. Because i can not see "database tab" on sqldeveloper as db2 or oracle or mysql.. My way ise tools > Preferences > Database > Third Party Drivers.…
HA and Perf
  • 67
  • 2
  • 4
0
votes
1 answer

NPE in org.voltdb.Distributer.getPartitionKeys

I signed up for the jira.. not sure how to report issues except for pull request. There's a bug here as the result of .get() can be null. Possibly there is better information available to hydrate an exception I think. In org.voltdb.Distributer …
Adrian Cole
  • 792
  • 4
  • 10
0
votes
1 answer

Getting existing rows to export using Kafka Export Connector in VoltDB

I am working on a solution to migrate from an older schema to a newer schema betwen two VoltDB instances. I was looking at The Kafka Export Connector and Kafka Import and the ability to write procedures to convert data from older schema to a new…
spakai
  • 303
  • 1
  • 2
  • 17
0
votes
0 answers

voltdb not fetching data from kafka topic

I am using Voltdb. And my use case is to import data from kafka to voltdb. I am using below command : Command: kafkaloader test --brokers <>:2181, --topic kafkavoltdb In deployment.xml file the configuration is:
0
votes
1 answer

VOLTDB ERROR: SQL ERROR More than 100 MB of temp table memory used while executing SQL

I'm getting this error while querying a 10,000,000 database in VoltDB. Any idea on how to get around it? VOLTDB ERROR: SQL ERROR More than 100 MB of temp table memory used while executing SQL.
Salo Charabati
  • 147
  • 1
  • 2
  • 12
0
votes
1 answer

Getting `Mispartitioned tuple in single-partition insert statement` while trying to insert data into a partitioned table using `TABLE_NAME.insert`

I am creating a VoltDB table with the given insert statement CREATE TABLE EMPLOYEE ( ID VARCHAR(4) NOT NULL, CODE VARCHAR(4) NOT NULL, FIRST_NAME VARCHAR(30) NOT NULL, LAST_NAME VARCHAR(30) NOT NULL, PRIMARY KEY (ID,…
Naresh Joshi
  • 4,188
  • 35
  • 45
0
votes
2 answers

Connection to voltdb within container fails with connection refused

According to the information on docker hub (https://hub.docker.com/r/voltdb/voltdb-community/) I was able to start the three nodes after adding the nodenames to my /etc/hosts file. Commands I executed: docker pull…
Tim Malich
  • 1,301
  • 14
  • 22
0
votes
1 answer

Voltdb alive nodes throw an exception when executing "sqlcmd" after a node of a 3 node cluster with Ksafe 1 is shut down

I have deployed a two site environment with a three node cluster of voltdb in each site with Ksafe=1. Clusters are configured with XCDR replication. I have performed a failover test, I have shut down the VM of one of the nodes of the cluster) and…
0
votes
2 answers

NewSQL for data warehouses and spatial queries

What NewSQL distributions are suited to dealing with data warehouses and spatial queries? (MemSQL, VoltDB, NuoDB, what? and why)
0
votes
0 answers

Low throughput using jdbc query on voltdb

Using jdbc query data, The throughput is about 10000+/s when the where condition contain partition column, No partition column that the throughput is only 300+/s. Could you give me advise,pls
Franco
  • 1