MariaDB Hosting: Compare Hosting
Oops! No Hosting Plans Match Your Search
You've selected a combination of features that none of the web hosts we profile offer. We suggest you remove your last filter or reset & start again.
Ask Our Experts
Need help with your hosting? Tell us exactly what you are looking for and we’ll do our very best to help. Please allow one working day for a response.
Please fill in all fields.
Thanks! Your request has been sent. We'll reply within 24 hours.
Recommended Host for MariaDB
What Is MariaDB?
MariaDB is a relational database management system (RDBMS) that is a drop-in replacement for MySQL. It offers all the features of MySQL, with the same interface and compatible libraries, along with additional features, improved performance, fewer bugs, and better licensing.
History of MySQL and MariaDB
MySQL was the first widely popular Open Source database. It was invented in the early 1990s by Michael Widenius, and was a great success.
In 2008, the company that had been the lead development team behind MySQL was purchases by Sun Microsystems. Sun was purchased a year later by Oracle.
MySQL continues to exist as Open Source software, but there is also now a closed source Enterprise edition available.
Unsatisfied with the direction of the software, many of the original development team, including the inventor, created a fork of the Open Source version of MySQL, and began enhancing it and adding new features. This version has been named MariaDB.
Similarities between MySQL and MariaDB
If you weren't looking closely, you would think they were the same software. In fact, they are mostly the same software. MariaDB was created by first taking a copy of MySQL. Beyond that, MariaDB has kept up with changes to MySQL to make sure they stay compatible.
MariaDB is fully compatible as a "drop-in" replacement. That means that you can change an application's database from MySQL to MariaDB without changing anything else, and it will still work. But once you change it, you can start taking advantage of the improvements.
The MariaDB development team wanted to improve as much about MySQL as possible without breaking drop-in compatibility. They've added features, sped things up, and even improved the licensing.
Easier to Use
A number of features were altered or added to make the software easier for developers to interact with. These improvements include:
- Use Statistics
- DB Admins can now query data about how tables and indexes are used, allowing for a better understanding of server activity.
- Progress Messages
- Some types of queries can take a very long time to complete. In MySQL, there was no feedback about progress, which can lead to impatience and hasty job cancellation. MariaDB has added feedback to several long-running commands.
- More Precise Time
- MySQL allows for DATETIME and related values to be specified to the second, while MariaDB can specify time value to the microsecond.
- NoSQL Features
- MariaDB allows developers to write directly to the underlying datastore, skipping the SQL layer. While not recommended for most use cases, this adds the ability to store non-relational data.
- MariaDB also has support for Dynamic Columns, which allows every row of a table to have a different set of virtual fields.
In a high-volume environment, every microsecond counts. MariaDB has made a number of improvements to speed and performance, including:
- The optimizer is a utility within an RDBMS system that translates Structured Query Language commands (SQL) into instructions for the underlying storage engine. (This is mildly analogous to a compiler or interpreter.) The MariaDB rewrote the entire Optimizer, making it run much faster, especially on complicated or demanding queries.
- Table Elimination
- Just because a Table is named in a query doesn't mean it will actually need to be accessed in order to provide the requested results. MariaDB analyses the query against what data is actually needed to complete the request, and doesn't include tables that are not needed.
Better Testing: Fewer Bugs and Fewer Warnings
Though not an enhancement that end-users can directly take advantage of, the MariaDB development team have greatly expanded and improved the test suite for MariaDB. This ensures that new features are more reliable and contain fewer bugs when they are released.
Also, while not "bugs" exactly, MySQL created a number of warnings at the compiler level. These didn't signal anything was actually going wrong with the execution of the software, but did cause a bit of annoyance for developers. MariaDB has treated compiler warnings as bugs and worked to eliminate them whenever possible.
MySQL is only mostly Open Source. The Enterprise edition contains a number of closed-source modules and enhancements. MariaDB is fully Open Source, and includes features which are closed in MySQL.
Further, libraries and other modules have been licensed in such a way that they can be used in conjunction with other closed-source software, eliminating some legal restrictions and allowing for complete flexibility in how the software is used.
Any web host that supports MySQL should be able to support MariaDB, but you should check with the web host directly if you are planning to make a switch on a live application.
MariaDB Hosting Frequently Asked Questions
What is MariaDB?
MariaDB is a drop-in replacement for MySQL, the worlds most popular open-source relational database management system. Compared to MySQL, MariaDB offers additional features, better licensing, and a completely open-source and community-driven development model.
Why was MariaDB created?
For years, MySQL has been the industry-standard open source database management system and has been installed on virtually all standard Linux systems. However, on January 27, 2010, the company that sponsored MySQL development was acquired by Oracle.
Fearing that Oracle's ownership of MySQL would produce negative results in the long run, Michael "Monty" Widenius, the original developer of MySQL, created a fork of MySQL in late 2009 and named it MariaDB. MariaDB was created to provide a new professional home for the core MySQL development team, to ensure that a free alternative to MySQL would always be available, and to ensure that MySQL development remained a community-driven process.
Is MariaDB compatible with MySQL?
Yes, MariaDB is a drop-in replacement for MySQL. Any MySQL database can be imported directly into MariaDB and it will run as expected.
Is MariaDB just a copy of MySQL?
No. Initially, MariaDB was forked as a copy of MySQL version 5.5. However, over time, many new features, performance enhancements, and bug fixes have been incorporates into MariaDB, all while maintaining complete compatibility with MySQL.
How are MariaDB and MySQL different?
While an MySQL database can be dropped into MariaDB and work just fine, there are actually quite a few differences between MySQL and MariaDB.
One of the most important differences is the number of storage engines, most notably Aria, that MariaDB supports in addition to the storage engines supported by MySQL. Another key difference is that temporal values in MariaDB can be recorded down to the microsecond while MySQL can only record seconds. MariaDB also supports a number of NoSQL commands.
In addition, development of MariaDB emphasizes a concerted effort to eliminate bugs, reduce warnings, and avoid introducing new warning and bugs.
Is MariaDB faster than MySQL?
In benchmarked tests, MariaDB consistently outperforms MySQL. However, the difference in performance between the two database management systems isn't that large. Both MySQL and MariaDB are extremely stable and efficient.
What is NoSQL?
NoSQL stands for "non SQL" or "not only SQL." It describes a database storage system that doesn't model the table-based storage system SQL developers will be very familiar with.
In the case of MariaDB, NoSQL stands for "not only SQL." It indicates that while MariaDB is primarily a relational database management system, it does support something called dynamic columns which allow for the storage of data in a decidedly non-relational structure.
I already have MySQL, can I use MariaDB?
If MySQL is installed on a server, then it is theoretically possible to also install MariaDB on the same server. The two database management systems can coexist side-by-side on a single server just fine.
However, you'll need root access to the server to install MariaDB. So, in practice, if you want to use MariaDB, you'll need to pick a host that already supports it, or select a hosting plan that includes root access to the server so that you can install it yourself.
How popular is MariaDB?
According to DB-Engines, as of early 2017, MariaDB is the 20th most popular database management system. This is in contrast to MySQL which comes in at second place behind it's parent company's flagship product, Oracle. MariaDB has a lot of ground to make up if it ever hopes to compete with MySQL. However, it is growing in popularity.
Who uses MariaDB?
MariaDB is offered by many performance-minded web hosts as an alternative to MySQL. In addition, MariaDB is used by some very high-profile customers such as Google, WordPress.com, the Wikimedia Foundation, and Mozilla.
Who owns MariaDB?
MariaDB is free and open-source. The copyright to the software is held by the MariaDB Foundation who offers the software under the GNU GPL license. The MariaDB Foundation is also charged with managing and coordinating ongoing development of MariaDB.
How do I get MariaDB?
MariaDB can be installed from the command line of most Linux operating systems. For example, to install MariaDB on a server running Ubuntu, just execute the following command:
apt-get install mariadb-server.
You can also download the MariaDB source code from the MariaDB Foundation website if you need MariaDB for a Windows system or if you wish to review the source code itself.
What's the difference between mariadb.org and mariadb.com?
The MariaDB Foundation website can be found at mariadb.org. The MariaDB Foundation is charged with overseeing ongoing development of MariaDB.
The MariaDB Corporation is a seperate organization, but one with very close ties to the MariaDB Foundation. The MariaDB Corporation website can be found at mariadb.com and the company is the primary sponsor of the MariaDB Foundation and the source of employment for core MariaDB developers.
Similarly to how Oracle approaches MySQL, the MariaDB Corporation offers a variety of commercial packages that add on premium features and technical support to the core MariaDB database system. Unlike Oracle, MariaDB Corporation does not own the database system it supports. Ongoing development of the software is therefore ensured to remain in the open-source space and to continue even if MariaDB Corporation is ever shuttered.