Announcement

Collapse
No announcement yet.

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

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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.

  • #2
    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?

    Comment

    Working...
    X