Apache Ignite vs TBase

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.

TBase is Tencent-published, open-source database software for distributed hybrid transactional and analytical processing. It provides database and data warehouse services through one cluster and supports an extended subset of SQL, including transactions, foreign keys, user-defined types, and functions. A cluster uses Coordinator Nodes to plan queries, DataNodes to store user data, and a Global Transaction Manager. Tables can be distributed or replicated, with queries sent to DataNodes and results gathered. Deployment is self-hosted; setup guidance describes compiling from source and deploying across one or more hosts, including basic x86 servers. Administrators can use pgxc_ctl to configure and manage clusters. Table options include shard, partitioned shard, hot-and-cold partitioned shard, and replication tables. Shard-table distribution-key values, lengths, and types cannot be modified. Replication tables keep a full copy on every DataNode, and the guide cautions against using them for large tables. Monitoring includes session memory, DataNode operator details, and cluster-wide active sessions. TBase is listed as free under the BSD 3-Clause License.