MariaDB (MySQL): open-source SQL Database
MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License.
MariaDB intended to maintain high compatibility with MySQL, ensuring a drop-in replacement capability with library binary parity and exact matching with MySQL APIs and commands. However, new features diverge more (ex: XtraDB replaces InnoDB).
MariaDB server can be integrated with Galera Cluster that extends it with the feature of acting as a synchronous multi-master cluster.
- MariaDB runs on a number of operating systems and supports a wide variety of programming languages.
- It includes new storage engines like Aria, ColumnStore, and MyRocks.
- MariaDB includes a wide selection of storage engines, including high-performance storage engines, for working with other RDBMS data sources.
- It uses a standard and popular querying language.
Project Design and Security
- MariaDB also offers many operations and commands unavailable in MySQL.
- It eliminates / replaces features impacting performance negatively from MySQL.
## Sample Configuration for MariaDB @ /etc/my.cnf
# This will be passed to all MariaDB clients
# The MariaDB server
# To listen to all IPv4 network addresses, use "bind-address = 0.0.0.0"
# Directory where you want to put your data
# This is the prefix name to be used for all log, error and replication files