> For the complete documentation index, see [llms.txt](https://functional.gitbook.io/database_comparison_report/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://functional.gitbook.io/database_comparison_report/maria-db/pros-of-maria-db.md).

# Pros of Maria DB

**Encryption.** For MariaDB, open source doesn’t mean insecure. In addition to internal security and password check, MariaDB provides such features as PAM and LDAP authentication, Kerberos, and user roles. In combination with encrypted tablespaces, tables, and logs, it creates a robust protective layer for data. Above that, MariaDB publishes the related releases on each security update, keeping the security patches totally transparent.

**Broad functionality.** MariaDB has introduced a lot of new features in the last few years. For instance, GIS support suggests smooth coordinate storage and location data queries. Dynamic columns allow a single DBMS to provide both SQL and NoSQL data handling for different needs. You also can extend its functionality with plugins that are available at MySQL via 3rd parties only. MariaDB is shipped with storage engines for the NoSQL backend, legacy databases migration tools, sharding options, and many more.

**High performance.** Although MariaDB originates from the MySQL engine, it got very far in terms of performance. Extensive optimization features improve thread pool management and data processing. Thus, when rows from the table are deleted, the operating system immediately accesses the free space, eliminating gaps in the tablespace. On top of that, the database management system suggests engine-independent table statistics. This feature enhances the optimizer’s performance, accelerates query processing, and helps customize data analysis.