The importance of advanced database security cannot be underestimated. That’s why MariaDB Enterprise Server and SkySQL take a data security-first approach. In fact, MariaDB SkySQL achieved ISO 27001 certification for its Information Security Management System (ISMS) in 2021.
The firewall plugin uses rule-based configuration to intercept and block queries based on multiple parameters (e.g., user or syntax) to, for example, prevent malicious attacks like SQL injection from deleting all rows in a table or accessing restricted tables/columns. The data masking plugin can be configured to hide sensitive data (e.g., PII/SPI – credit cards, Social Security numbers).
The connections between clients, proxies and databases can be encrypted with Transport Layer Security (TLS) to protect data in motion while tables and binary logs can be encrypted with Advanced Encryption Standard (AES) algorithms to protect data at rest – and there are plugins for the AWS Key Management Service (KMS) and the eperi Gateway.
The auditing plugin can be configured to track all database events – connections, queries (DML/DDL/DCL) and tables accessed – logging the time, username and host, database and operation, and more. In addition to local files, remote files are supported via syslog and rsyslog – often to aggregate database events from multiple servers and/or restrict access.
The result limiting filter can be configured to block malicious queries intended to slow down the database by returning thousands if not millions of rows. In addition, to protect from denial of service (DoS) and distributed denial of service (DDoS) attacks, user resource limits can be set to restrict the frequency of connections, queries and more.
LDAP authentication with user and group mapping – SSH passwords, one-time passwords and two-factor authentication via Google Authenticator, too – is supported via the Pluggable Authentication Module (PAM) plugin while password validation plugins can be enabled to enforce strong passwords. In addition, administrators can configure role-based access control (RBAC).
Today, many companies have to comply with one or more security standards and regulations – PCI, HIPAA, SOX and GDPR, to name a few. MariaDB is engineered for security, whether it’s encryption and key management for PCI compliance or pseudonymization (i.e., data masking) for GDPR compliance.
MariaDB secures data at every layer – from encrypted communication and storage to pluggable authentication and role-based access control, plus an advanced database proxy with a built-in firewall to detect and prevent data breaches by blocking queries and masking sensitive data.Download now