MariaDB is now available
The long awaited update makes it possible to create MariaDB databases. This applies to anyone with an SSD package, so if you don't have this available in your customer panel then an upgrade is worth considering.
MariaDB is the real open source database compared to MySQL. And was set up by the co-developers of MySQL after the acquisition of Oracle. If you want to read the full history behind this then you can do so through our earlier blog post:
In this blog post we will cover how to use the databases now and how you can benefit from them. It works easily and quickly and can actually be considered the same as MySQL. It can be connected through the database manager to perform various tasks.
MariaDB, what can you use it for?
MariaDB can be used for a lot of Content Management Systems and code languages. It can be used in ASP.NET with C#, within PHP for WordPress. And for many others. Websites created using MariaDB are faster than websites using MySQL for the same purpose. And are thus in combination with an SSD package lightning fast. MariaDB can be used to store your website data, such as configurations, your customer data and content. So you can use a MariaDB database for each website!
The connection string for MariaDB looks like this for C# in ASP.NET:
Driver={MariaDB ODBC 2.0 Driver};Server=mariadb001.myhostingpartner.co.uk;UID=odbc_user;PWD=odbc_pw;DB=odbc;Port=3306
In other words, just the MySQL connection string but with a slight modification in the MariaDB host.
The same can be applied in programming languages like PHP, here you can also use the same connectors like PDO to connect to MariaDB. So this makes it easy to switch to a fully open source database. And thus can be easily applied by anyone.
WordPress and MariaDB
WordPress and MariaDB are made to work together with a lot of different technologies. With some Content Management Systems there is no need to install anything extra for them. WordPress is one of them. Simply run a WordPress installation as normal, and enter the database data for MariaDB. This ensures that you have the WordPress database in MariaDB. And further you do not need to make any changes. The MariaDB database host can be entered as follows:
mariadb001.myhostingpartner.com
With the data that you have created for the database and user. After this the installation is completed and you can make optimal use of your WordPress website with MariaDB!
Benefits of MariaDB
The advantages of MariaDB are mainly 2. The first is that this is a true open source database, and you can easily use it for any project. As soon as you use WordPress and MariaDB, you will also notice that your website will load faster compared to MySQL. Several tests show that there is a noticeable difference. And so can be used to also apply the speed optimization for this.
Since it was a large part of the team behind MySQL, a few teething problems were also solved that could not easily be solved in an existing database platform. MariaDB was thus the chance to make it better than MySQL and pick it up again with a fresh start. So this makes it the logical choice for any new project that required a MySQL database.
MijnHostingPartner.nl is proud of the realization of MariaDB and hopes that we can continue to make such strides for customers. Using the latest software and technology is of course a big part of working on a website in your hosting. Therefore, after hard work, we are proud that MariaDB can now be used by anyone who has an SSD package!
