ActorDB vs OceanBase Database

ActorDB is an open-source distributed relational SQL database from Biokoda that organizes data into independent actors. SQLite handles SQL queries and LMDB provides storage. Applications connect through the MySQL protocol or Thrift, and the FAQ recommends Thrift; default MySQL drivers also work. ActorDB uses Raft for distributed consensus and write replication, and describes itself as strongly consistent. Transactions can span multiple actors and are described as ACID compliant. It can also provide a sharded key-value store with structured values, multiple columns, and foreign tables. The maker says horizontal scaling can reach hundreds of nodes and petabytes when data is spread across actors. If a server fails, a follower can lead an actor while a cluster majority remains online. Recommended cluster sizes are 1, 3, or 5 nodes. Supported downloads include Windows, Mac OS X, CentOS, and Ubuntu, with version 0.10.29 dated 1 October 2019 shown as the latest stable release.

OceanBase Database is a distributed database for transactional, analytical, and AI workloads in one system. Built-in compatibility with Oracle and MySQL is intended to simplify migration. Deployment choices include the open-source Community Edition, self-hosted Enterprise, and fully managed OceanBase Cloud across cloud providers. Documentation describes high availability and disaster recovery at node, data-center, and region levels. Linux installation packages are listed for Alibaba Cloud Linux, CentOS, Red Hat, Ubuntu, Debian, and Anolis OS. Docker deployment can be used on Windows and macOS, though the documentation cautions that this method has not been validated at scale. A standalone instance can be used for learning; production environments require at least three servers. Community Edition is free and includes full kernel capabilities. Enterprise pricing is available on request. Security features include role and permission management, network whitelists, encrypted communication, transparent data encryption, and SQL auditing, but Community Edition does not support security audit.