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.