MariaDB

The MariaDB integration uses the CryptoHub Transparent Data Protection (TDP) service to encrypt the MariaDB datadir (data directory), which is the central repository for all the database system’s files, configurations, and actual data storage. TDP uses policies to protect your data and offers a user-friendly platform for effortless data security.

​

MariaDB

MariaDB is a popular, open-source relational database management system (RDBMS), renowned for its performance, scalability, and strong compatibility with MySQL. On Windows, you can install it by using an MSI package or a ZIP archive. MariaDB ensures transactional integrity through ACID compliance (primarily through the default InnoDB storage engine) and supports features like JSON, window functions, common table expressions (CTEs), and a wide array of storage engines (for example, InnoDB, ColumnStore, and Aria). MariaDB excels in various Windows environments, from development machines to production servers, often serving as the database backend for web applications (like WIMP stacks) or other software. Its pluggable storage engine architecture enables users to tailor storage to specific needs. MariaDB Foundation and MariaDB Corporation drive the MariaDB active development, providing regular updates and features compatible with Windows systems. The datadir (data directory) in a MariaDB installation on Windows is the central folder where the server stores its databases, status files, and certain logs. The location is typically set during installation or configured through the datadir option in the primary configuration file, which is usually named my.ini on Windows. Common default locations for the datadir on Windows might include:

• C:\Program Files\MariaDB <version>\data
• C:\ProgramData\MariaDB\MariaDB Server <version>\data (especially when installed as a service, as ProgramData is the standard location for application data)

Key components typically found within or associated with the data directory on Windows include:

• Database Directories: Each database resides in a subdirectory within the datadir directory. Inside these, table data and structures are stored as files (such as .frm files for structure, .ibd for InnoDB data/indexes, or .MYD/.MYI for MyISAM data/indexes).
• Configuration File: The main configuration file is typically my.ini. While crucial for the server, it’s often located outside the datadir, commonly in the MariaDB installation root (such as C:\Program Files\MariaDB <version>\) or in C:\ProgramData\MariaDB\MariaDB Server <version>\.
• Log Files: Includes binary logs (binlog.*) if enabled (for replication/recovery), the error log (location specified in my.ini, often defaults to the datadir), InnoDB redo logs (ib_logfile*, usually within datadir), and the slow query log if enabled.
• System Databases: Contains essential databases like mysql (for user accounts, privileges) and information_schema (for metadata access).
• Status and Control Files: Includes the process ID file (hostname.pid, usually in the datadir) and potentially files related to named pipe connections if configured (Windows uses TCP/IP or named pipes for local connections instead of Unix socket files).

As the core repository for your data on Windows, the MariaDB datadir and the associated my.ini configuration file must be properly secured (using Windows file permissions) and regularly backed up to prevent data loss and ensure reliable operation.