Database Comparison
Enhance supports both MySQL and MariaDB, allowing different database types to run on each server in your Enhance cluster. Below are the key differences between MySQL and MariaDB:
| Feature | MySQL | MariaDB |
|---|---|---|
| JSON | Stores JSON as binary objects. | Stores JSON as strings; JSON is an alias for LONGTEXT. |
| Oracle Database Compatibility | High compatibility but no PL/SQL support. | High compatibility with PL/SQL support since version 10.3. |
| Speed and Performance | Slightly slower in replication and querying. | Faster in replication and querying. |
| Functionality | Supports super read-only, dynamic columns, and data masking. | Supports invisible columns and temporary table space. |
| Authentication | Includes the validate_password component. | Includes three password validator plugins. |
| Encryption | Uses InnoDB and AES for data encryption. | Supports temporary log and binary log encryption. |
| Storage Engines | Fewer storage engines. | More storage engines and support for multiple engines in a single table. |
| Thread Pooling | Available only in the Enterprise Edition. | Can manage over 200,000 connections at once, more than MySQL. |
