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

Is it possible to make asynchronous stored procedure calls to VoltDB using the Python client

Is it possible to make asynchronous calls to a stored procedure in VoltDB (an insert in a custom Java Stored procedure) using the Python client? It looks like it isn't supported but is there a way to not wait for the response, or will I have to move…
StevieB
  • 3
  • 1
0
votes
1 answer

how to install voltDB on virtual 3 nodes cluster

I'm currently trying to learn about voltDB so i'm trying to install the community version mon a virtual 3 nodes (matser, node1, node2) cluster using ubuntu 16.04 as OS on Oracle VirtualBox. But when i tried to start voltDB, here what i got as error…
Abir
  • 3
  • 1
0
votes
1 answer

How to run two service with different node with voltdb

I have a three node cluster configured for voltdb. Currently 2 applications are running and all the traffic is going to only single node. ( Only one server) As we have 3 cluster ( 3 nodes) and data is replicated around all the nodes. Can i run one…
0
votes
1 answer

Does VoltDB's Connector Sink support Avro messages?

Does VoltDB's Kafka connector support reading avro messages Below is my attempt to configure the connector ? { "name":"KafkaSinkConnector", "config":{ "connector.class":"org.voltdb.connect.kafka.KafkaSinkConnector", …
ypanag
  • 287
  • 5
  • 22
0
votes
0 answers

VoltDB Cluster PAUSED when 2 node reaches to 80% memory out of 9 nodes

I am importing data from Kafka server using VoltDB Kafka Importer, my current setup is in AWS and all the 9 nodes has following config 8 vCPUs 200 GB HDD 8 GB RAM The import rate is 10,000 recs per second. My problem is the cluster enters into in…
Arjun
  • 41
  • 4
0
votes
1 answer

How to increase query specific timeout in VoltDB

In VoltDB Community edition When I am uploading a CSV file (size: 550Mb)for more than 7 times and then performing basic aggregation operations, it’s showing query timeout. But then I tried to increase the query timeout through the web interface and…
0
votes
1 answer

How to declare variables in voltDB stored procedure

How to declare variable in stored procedure. I tried with the following code as in MS Sql Server. CREATE PROCEDURE TN AS BEGIN DECLARE kkk INTEGER; SET KKK=5; IF(kkk<10) SELECT * FROM XXXX; ELSE …
Cenoy
  • 21
  • 1
0
votes
1 answer

How to scale VoltDB on 3 machines

I am new to VoltDB and working on a college research project. For that I need to run VoltDB on multiple nodes. Currently, I have 3 Ubuntu 16.04 VMs on Azure cloud. Each with 8 vCPUs, 200GB storage, 32 GB ram. All of them has VoltDB 8.1.1 community…
Arjun
  • 41
  • 4
0
votes
2 answers

Any Editor for VoltDB

Like SQL Server Management Studio in SQL Server, is there any editor available for VoltDB so that I can create or edit scripts? I tried in DBeaver, but I'm unable to see stored procedure script, after creation.
Cenoy
  • 21
  • 1
0
votes
1 answer

voltdb-client-nodeJS doesn't work about @AdHoc proceduer

I followed the voltdb-client-nodeJS, and implement the @AdHoc query function, but the "read" function didn't callbacked, so that can't get any queried results, can't determine if the connection is successful, too. [callProcedure code] var query =…
Ckll
  • 17
  • 4
0
votes
1 answer

Start action "StartAction" is not supported in the community edition of VoltDB

I want to add a node to voltdb cluster, use command voltdb start --add --host=s7biapp26 but, encountered a error about: ERROR: Start action "StartAction" is not supported in the community edition of VoltDB. FATAL: This process will exit. Please run…
Ckll
  • 17
  • 4
0
votes
0 answers

PHP VoltDB Client Library installation

I'm trying to use PHP and VoltDB together using these instructions. However, "make" gives me this error, and the compile process fails: root@london:/home/root/voltdb-client-php-extension-5.2/voltdb-client-php# make /bin/bash…
Fuiba
  • 44
  • 6
0
votes
1 answer

VoltDB Stored Procedures history

I have many stored procedures running in Volt and it seems like 1 of them is causing spikes in CPU every now and then but I don't know which one. Is there somewhere I can see the history of all the stored procedures that ran so that I could pinpoint…
sid802
  • 315
  • 2
  • 18
0
votes
0 answers

How to find out what's wrong with kafka exporter for voltdb?

I want to export data from voltdb to kafka , but can't found any updating data for the corresponding Kafka topic. voltdb deployment.xml:
Ckll
  • 17
  • 4
0
votes
0 answers

VoltDB - Renaming a segment?

Are you able to rename a segment in VoltDB? I have come across a recent issue where a segment has disappeared and below it, it looks like a command to rename the segment, I am very new to voltdb and would like to know if this command is legal?
Vikana
  • 1