Forum: VoltDB Architecture

Post: How to guarantee data consistency between VOLTDB and other DB ,eg:mysql

How to guarantee data consistency between VOLTDB and other DB ,eg:mysql
qianjian21cmj
Dec 23, 2015
hi everyone .
i want to save data to voltdb and mysql.
How to guarantee data consistency between VOLTDB and mysql.
voltdb don't not support JTA.
bballard
Dec 23, 2015
Most of our customers use VoltDB as a fast ingestion system of record, and then use Export (https://docs.voltdb.com/UsingVoltDB/ChapExport.php) to push records to downstream data systems, including Mysql using the JDBC export connector. Typically this is for event data that works well with the insert-only guaranteed at-least-once deliver aspects of Export. In some cases, such as for sessionization use cases, the events are processed in VoltDB and only upon certain events such as when a session is completed, a summary record is exported downstream.

What is your use case? Where does the data originate, and why would VoltDB and Mysql need to be kept in sync?