- 14. Sep
MariaDB is an open source relational database management system (DBMS) that is a compatible drop-in replacement for the widely used MySQL database technology. It was created as a software fork of MySQL by developers who played key roles in building the original database; they devised MariaDB in 2009 in response to Oracle Corp.'s acquisition of MySQL.
MariaDB is based on SQL and supports ACID-style data processing with guaranteed atomicity, consistency, isolation and durability for transactions. Among other features, the database also supports JSON APIs, parallel data replication and multiple storage engines, including InnoDB, MyRocks, Spider, Aria, TokuDB, Cassandra and MariaDB ColumnStore.
Much of the development work on the open source database has focused on achieving feature parity between MariaDB and MySQL. MariaDB Corp., the driving force behind MariaDB, says that "for all practical purposes" the database is binary-compatible with MySQL. As a result, most users can switch between the two technologies simply by uninstalling MySQL and installing MariaDB in its place.
Nonetheless, there are some incompatibilities between corresponding versions of the databases. For example, in version 10.1 and above, MariaDB stores JSON data in a different format than MySQL 5.7 does. To compensate, users looking to replicate columns of JSON objects from MySQL to MariaDB need to either convert them to the format used by the latter or run statement-based replication jobs via SQL.
MariaDB Corp., based in Espoo, Finland, with U.S. headquarters in Menlo Park, Calif., offers a commercial version of MariaDB on a subscription basis, along with complementary products and a set of training, remote management, and migration services. However, the database's source code is maintained by the MariaDB Foundation, a group that was formed in 2012 to preserve the software's open source nature.
Enterprise Solutions Powered by MariaDB
MariaDB TX is an enterprise open source database solution that simplifies migration with Oracle compatibility, supports a variety of workloads with purpose-built storage engines and protects sensitive and/or personally identifiable information with an advanced database firewall. 3
MariaDB AX is an enterprise open source solution for modern data warehousing and analytics – SQL on top of distributed, columnar storage for scalable, high-performance analytics and data adapters (e.g., Spark and Kafka) for simplified and streamlined data imports (batch or streaming).
Enterprise Services Powered by Experience
Get help migrating legacy databases — the Migration Practice can perform assessments, create plans and execute implementations. LEARN MORE
Use a resident Enterprise Architect as a trusted advisor, to perform on-site reviews, create technical roadmaps and provide proactive guidance. LEARN MORE
Leverage a MariaDB consultant to assist with everything from architecture and design to performance tuning and security audits. LEARN MORE
Engage a Remote DBA to help manage, monitor, and optimize MariaDB infrastructure — health checks, status calls and upgrades too. LEARN MORE
Learn about database administration and application development from the experts, self-paced or instructor-led, online or on-site. LEARN MORE
Rely on MariaDB support engineers, former DBAs with decades of experience, to provide 24x7 support for mission-critical applications. LEARN MORE
MariaDB is an open source leader, collaborating with innovators like Alibaba, Google and Facebook to develop and incorporate new features and improvements for the whole community, while at the same time helping customers like DBS Bank standardize on MariaDB solutions – ensuring enterprise and architecture requirements are met, now and in the future.
MariaDB solutions are trusted, proven and reliable replacements for legacy databases.