Forum: Other

Post: Migrating from MySQL to VoltDB

Migrating from MySQL to VoltDB
tommyready
Mar 23, 2012
Is there a simple solution in migrating from mySQL to VoltDB? Do I just dump .sql files and import in?
MySQL to VoltDB
jpiekos
Mar 23, 2012
Migrating from MySQL to VoltDB requires a little bit of re-thinking of your application, particularly with dealing with large data and at Scale processing.

Some things to consider:
- How do I partition my data? You want even distribution of data across your cluster.
- VoltDB's primary interaction model is Java Stored Procedures, so for optimal performance, you will need to convert most of your MySQL SQL into Java Stored Procedures.
- For optimal performance and throughput, make sure your queries operate on data within a single partition, in other words, strive for making a majority of your procedures single-partition stored procedures.
- VoltDB supports an OLTP-focused subset of SQL-99, so your SQL may require some re-work.

We've got a couple of resources to help you get going quickly with this:

The VoltDB Getting Started Guide, here: http://community.voltdb.com/docs/GettingStarted/index
The VoltDB for SQL Developers webinar, here: http://voltdb.com/resources

If you need help with specific portions of your application, feel free to post them in this forum.

Thanks,

John
Adrian
Feb 9, 2017
Hey John,
Does VoltDB support SQL-99 now, or still just a subset of SQL-99
jpiekos
Feb 10, 2017
We now support quite a bit of SQL now (5 years since I last responded!), see: https://docs.voltdb.com/UsingVoltDB/AppxSQL.php
Any specific SQL constructs you are interested in?

John