ActorDB vs Apache Ignite

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.

Apache Ignite is a free, open-source, memory-first distributed SQL database for high-velocity workloads. It keeps data primarily in memory, with persistence available through AIPERSIST, and supports ACID transactions across partitions using Raft consensus. MVCC snapshot isolation enables non-blocking reads. SQL access includes JDBC drivers, a Table API and native APIs, while catalog-driven schema management allows column and index changes without stopping the cluster. DataStreamer handles high-throughput writes with backpressure control. Native clients are listed for Java, .NET, C++ and Python, alongside AWS, Azure, GCE and Spring extensions. Built-in operational capabilities include authentication, SSL/TLS security, OpenTelemetry metrics, recovery snapshots and backups. Listed uses include event stream processing, microservices state management, session management and AI/ML feature stores. Ignite is self-hosted and available through binary, source, Docker and Maven/Gradle options. The project identifies Ignite 2 as a long-term-support release recommended for existing deployments.