ActorDB vs MySQL
ActorDB
actordb.com
MySQL
mysql.comSide by side
| Figure | ActorDB | MySQL |
|---|---|---|
| Price from | — | Free |
| Free plan | — | Yes |
| Free trial | — | Yes |
| Open source | — | — |
| Windows | Yes | Yes |
| macOS | Yes | Yes |
| Linux | Yes | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 0 | 18 |
| Spec score · Distributed SQL Databases | 7.8 (#13) | 9.1 (#2) |
| Transactions | Transactions affect only the actors that participate in them, and the product supports ACID transactions across multiple actors. | MySQL is transaction-safe and ACID compliant with commit, rollback, crash recovery and row-level locking. |
Plans
MySQL
- Community EditionPrice not published
- Community EditionPriced on request
- Standard EditionPriced on request
- Standard EditionPrice not published
- Enterprise EditionPriced on request
- Enterprise EditionPrice not published
- Cluster Carrier Grade EditionPriced on request
- Cluster Carrier Grade EditionPrice not published
- MySQL Cluster Carrier Grade EditionPriced on request
- MySQL Enterprise EditionPriced on request
In their own words
ActorDB
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.