MariaDB is a free, open source relational database management system (RDBMS). It was created by the original developers of MySQL amid concerns MySQL would be commercialized after Oracle acquired it in 2009.
MariaDB is written in C and C++ and supports multiple programming languages, including C, C#, Java, Python, PHP, and Perl. MariaDB also supports all the major operating systems, including Windows, Linux, and macOS.
Although it’s a relational database, MariaDB offers NoSQL-like features in version 10. The Connect engine allows for easy access to unstructured data from within MariaDB, while dynamic columns allow NoSQL-type storage of different types of objects in the same row.
MariaDB offers the same features as MySQL and can be used as a direct replacement for the MySQL database server (i.e., MySQL can be uninstalled and MariaDB installed with no other changes). Designed for speed, reliability, and ease of use, MariaDB can be used for both small and enterprise processing tasks.
MariaDB gets its name from one of the daughters of co-founder Michael “Monty” Widenius. MySQL, a name now trademarked by Oracle, is named after his daughter My. Following the same tradition, MariaDB is named after his younger daughter, Maria. The name MariaDB was originally used for a storage engine, which was renamed Aria.
MariaDB is an open source, relational database management system. An RDBMS is a common type of database that manages predefined relationships between data, in which data is organized as a set of tables, columns, and rows.
The columns in the table store data attributes, and each row is a record with values for each attribute. A unique ID or primary key makes it possible to create relationships between the data. The relational database model is widely used in organisations of all sizes.
MariaDB is well suited for enterprise transactional applications that require support for frequent queries, fast response times, and the ability to process small amounts of data. Its InnoDB storage engine supports ACID-compliant transactions and ensures that each transaction is treated as a single unit.
MariaDB works well with web applications and e-commerce platforms, and its multi-threading mechanisms allow it to handle higher loads than other database systems. Because of its multi-threaded model and high performance, MariaDB can scale out to allow your application or site to handle traffic spikes or rapid business growth.
MariaDB queries are similar to MySQL and look like standard SQL queries. Here are three examples of MariaDB queries:
Retrieving customer information from a table:
SELECT firstname, lastname, address, city, state, zip FROM customer;
Inserting rows:
INSERT INTO customer (firstname, lastname, address, city)
VALUES ('Andrew', 'Williams', ‘75 Rose View’, 'Miami', ‘FL’, 33126);
Updating customer information:
UPDATE customer SET address = “175 Ocean City” WHERE lastname = ‘Williams’;
MariaDB supports several SQL data types, including numeric, string, date, and time.
MariaDB comes with a native MySQL command-line client that supports interactive and non-interactive use. When used interactively, query results are displayed in an ASCII table format, and when used non-interactively (i.e., as a filter), results are presented in a tab-separated format. The output format can be changed using command options.
You can download the current stable version of MariaDB from the MariaDB website. If you’re looking for additional MariaDB products and tools for development and production, you can find them on the MariaDB Products & Tools page.
The source code for MariaDB can be downloaded from GitHub.
MariaDB Community Server is released under the GNU Public Licence v2 and is guaranteed to be free and open source forever. MariaDB Community Server features SQL on JSON support, compatibility with Oracle and MySQL, support for multiple storage engines, and real-time analytics.
MariaDB is also available in enterprise and cloud versions. MariaDB Enterprise includes MariaDB MaxScale, application and integration connectors, management tools, and technical support. You can purchase MariaDB Enterprise by requesting a customized quote.
SkySQL, the cloud version of MariaDB, provides the high availability, scalability, and security that comes with a cloud environment. It features support for multiple workloads, disaster recovery, and proactive monitoring. MariaDB SkySQL comes with a $500 credit and starts at $0.1702 per hour.
MariaDB was created by Michael “Monty” Widenius, the founder of MySQL AB (now MariaDB Corporation) and a founding member of the MariaDB Foundation. Some of the original developers of MySQL were also involved in the development of MariaDB. MySQL AB, founded in 1995, was bought by Sun Microsystems in 2008. Sun was acquired by Oracle in 2010.
MariaDB was kept up to date with the equivalent version of MySQL until version 5.5 and functioned as a “drop-in replacement” with minor limitations. MariaDB’s data files and client protocol are generally binary compatible with the MySQL equivalents.
Upgrading from MySQL to MariaDB is still a straightforward process. Most times, you can simply uninstall MySQL and install MariaDB without having to convert data files. MariaDB, however, has several new options, extensions, storage engines, and bug fixes that aren’t found in MySQL.
While MariaDB retains many of the features of MySQL, it has several powerful built-in features and performance improvements over MySQL, including:
Both MariaDB and MySQL are powerful, and both offer advantages to organisations. As a result, the best one for you is the one that meets your business needs. MySQL has been around for a long time and comes with more resources and the support of a large organisation behind it. This can result in faster bug fixes and releases of new features.
MariaDB, on the other hand, depends on community support but brings faster performance and more storage engines, which allow you to store different types of data. MariaDB is similar enough to MySQL to be used as a direct replacement, allowing you to benefit from its additional features.
MariaDB is an open source and forever-free MySQL alternative that offers greater efficiency, enhanced database performance, and support for various data types through multiple storage engines.
Pure Storage® offers several modern data storage solutions for your open source database workloads.
Keep data storage simple, seamless, and sustainable with the speed and performance of FlashBlade® all-flash storage arrays and Purity storage management software. Create a Modern Data Experience™ designed to meet the needs of today’s innovative business.
Join us at Pure//Accelerate® in Las Vegas, June 14-16, and double down on your data success.
Let’s talk. Book a 1:1 meeting with one of our experts to discuss your specific needs.
Have a question or comment about Pure products or certifications? We’re here to help.
Schedule a live demo and see for yourself how Pure can help transform your data into powerful outcomes.
Call Sales: 800-976-6494
Media: pr@purestorage.com
Pure Storage, Inc.
2555 Augustine Dr.
Santa Clara, CA 95054
800-379-7873 (general info)