Enterprise reliability with open source innovation.
MariaDB TX, proven in production and driven by the community, is a complete database solution for any and every enterprise — a modern database for modern applications.
MariaDB TX Components
A modern general-purpose database built with an extensible architecture to support community contributions
Active/active, multi-master clusters with synchronous replication and globally-ordered transactions
A powerful database proxy with plugins for increased high availability, scalability, security and integration
Lightweight, non-blocking clients for Java (JDBC), ODBC (Windows and Linux), C and more
Full-featured management and monitoring interfaces; tools for backup and restore, rollback and replication
Remote database administration (Remote DBA), database architecture and design, database migration
What’s New in MariaDB TX 2.0
Completeness and compatibility
- Common Table Expressions
- Window functions
- JSON & GeoJSON functions
- EXECUTE IMMEDIATE
- CHECK (constraints)
- DEFAULT (BLOB/TEXT)
- DECIMAL (38 places)
- and more…
Performance and scalability
- MyRocks storage engine (preview)
- InnoDB enhancements
- Binary Log read throttling
- Binary Log compression
- Virtual Column indexes
- Query cache
- Streaming inserts
- and more…
Security and recovery
- Per user resource limits
- Enforced TLS connections
- Data masking
- Prepared Statement filtering
- Result Set limiting
- Delayed replication
- Binary Log based rollback
- and more..
MariaDB TX provides high availability for mission-critical applications using replication (master/slave or multi-master; synchronous, semi-synchronous or asynchronous) and automatic failover.
MariaDB TX includes multiple disaster recovery tools to perform everything from full physical backups and incremental logical backups to point-in-time recovery and Binary Log based rollback.
MariaDB TX secures access to sensitive data at every layer – client, network, server and storage – via authentication, encryption, auditing and an advanced firewall with query filtering and data masking.
MariaDB TX supports on-demand scaling using table/row sharding, clustering with automatic node detection and/or replication with dynamic configuration – and scales up, taking advantage of multi-core processors.
MariaDB TX meets high performance requirements using a multi-threaded architecture with multiple subquery optimizations, advanced join algorithms, index condition pushdown, and table statistics.
MariaDB follows an open and transparent development process, ensuring everyone has access to everything from tests cases and security bugs to source code and roadmaps.
MariaDB TX implements an extensible architecture with public APIs, enabling the community, customers and partners to create plugins for extending storage, security, replication and more.
MariaDB has one of the largest communities in the world, welcoming contributions from and collaborating with companies like Alibaba, Facebook and Google to incorporate new features and improvements.
MariaDB TX streams inserts, updates and deletes in real time using a change-data-capture protocol, converting them to AVRO objects or JSON documents for clients – and includes an Apache Kafka producer.
Flexible Data Model
MariaDB TX supports flexible data models with the use of dynamic columns to support different rows with different columns and JSON functions to support columns with semistructured data.