Differences between Percona MyRocks and Facebook MyRocks

The original MyRocks was developed by Facebook and works with their implementation of MySQL. Percona MyRocks is a branch of MyRocks for Percona Server and includes the following differences from the original implementation:

  • The behavior of the START TRANSACTION WITH CONSISTENT SNAPSHOT statement depends on the transaction isolation level.

    Storage Engine Transaction isolation level
    READ COMMITTED REPEATABLE READ
    InnoDB Success Success
    Facebook MyRocks Fail Success (MyRocks engine only; read-only, as all MyRocks engine snapshots)
    Percona MyRocks Fail with any DML which would violate the read-only snapshot constraint Success (read-only snapshots independent of the engines in use)
  • Percona MyRocks includes the lz4 and zstd statically linked libraries.