Database Comparison
LxRoot supports MySQL and MariaDB. It is possible to run different database kinds on each server in your LxRoot cluster.
Key differences:
| Feature | MySQL | MariaDB |
|---|---|---|
| JSON | Stores JSON reports as binary objects. | Stores JSON reports in strings. MariaDB’s JSON data type is an alias for LONGTEXT. |
| Oracle Compatibility | High compatibility, but does not support PL/SQL. | High compatibility and supports PL/SQL since version 10.3. |
| Performance | Reliable; slightly slower in specific replication/querying scenarios. | Optimized for speed in replication and complex querying. |
| Functionality | Supports super read-only function, dynamic columns, and data masking. | Supports invisible columns and temporary table space. |
| Authentication | Features the validate_password component. | Provides three password validator plugins. |
| Encryption | Uses InnoDB and AES to encrypt data at rest. | Supports temporary log encryption and binary log encryption. |
| Storage Engines | Fewer built-in storage engines than MariaDB. | Large variety of engines; can use multiple engines in a single table. |
| Thread Pooling | Included only in Enterprise Edition. | Native support for managing over 200,000 simultaneous connections. |