Which companies use MariaDB over MySQL

How you can save license costs for databases: MySQL and MariaDB

Have you ever thought about how to reduce database licensing costs? There are free alternatives such as MySQL, MariaDB and PostgreSQL. Often, however, 24/7 support is also required.

MariaDB, for example, offers this: The support "follows the sun". The free database system is a fork of MySQL that was developed by the MySQL "inventor" Michael Widenius.

MariaDB is compatible with MySQL and also offers the security that the database will remain permanently free - and that it will not go to a large company in the software industry. A foundation takes care of that: The MariaDB Foundation. It was founded by former MySQL founders Michael "Monty" Widenius, David Axmark and Allan Larsson and is independent. The purpose of the foundation is to protect the interests of the users and developers of MariaDB and, in particular, to ensure that the free database remains free. What few people know: There is also MariaDB Corporation - a company that offers MySQL and MariaDB support.

The MariaDBFoundation thus ensures that the free database really remains free. And the MariaDBCorporationoffers professional and guaranteed first-class support and, if necessary, MySQL and MariaDB consulting. The mixture is ideal for many companies.

From MySQL to MariaDB

There are different migration scenarios: On the one hand the change from MySQL to MariaDB, on the other hand also from a completely different database system such as Oracle or SQL Server. You have to take a closer look here, because the differences are sometimes considerable. Details can be found below.

Switching from MySQL to MariaDB is easy. Basically you just swap the sources. The rest works almost by itself and hardly leads to problems. Just try it out in your environment. Basically, the following steps are required:

  1. Update your software repositories with the MariaDB repos
  2. Update your Linux Package Manager with the latest repos
  3. Stop MySQL
  4. Install MariaDB using your package manager
  5. Start the database with MariaDB

That's it. You should of course make a current backup beforehand. There is one requirement: MariaDB should be used on the same or a higher version than your MySQL installation. The MySQL major releases are:

  • MySQL 5.0
  • MySQL 5.1
  • MySQL 5.5
  • MySQL 5.6.

MariaDB versions are:

  • MariaDB 5.1
  • MariaDB 5.2
  • MariaDB 5.3
  • MariaDB 5.5
  • MariaDB 10.x

Up to version 5.5, MySQL and MariaDB are compatible in both directions. That means you could switch to MariaDB first, but then back to MySQL again. Starting with MariaDB 10.x, this is no longer possible without further ado: MariaDB offers options that MySQL does not have. An export and import would then be required here.

By the way, the nice folks at MariaDB have created a copy-and-paste installation guide for the major Linux distributions. Further details can be found on the MariaDB website.

Migration of a heterogeneous database to MariaDB

But what about a change from another database system to MariaDB? What about Oracle or SQL Server? Are there any obstacles? What problems are to be expected? And does the effort pay off?

Switching from other database systems to MariaDB can be easy, but it doesn't have to be. An important point: Has business logic with proprietary languages ​​been stored in the database? Does the application use PL / SQL or T-SQL? Then you have to check more closely whether a change makes sense. However, if the database only contains data that is queried via an access layer, a change can be easy.

But does the architecture of a free database even fit? Can scalability, security and high availability be guaranteed to the required extent? You have to examine this more closely and it is not always easy to answer.

Here, for example, the workshop day MariaDB in depth is recommended. The trainer Colin Charles originally comes from MySQL. He has been Chief Evangelist for MariaDB since 2009. He has worked with MySQL for more than 15 years and with MariaDB since the Fork was founded. Colin Charles is also actively involved in the open source projects Fedora and OpenOffice.org. The workshop takes place in the run-up to the comprehensive developer and admin conference IT-Tage 2016 in Frankfurt am Main. It can also be booked individually.

The workshop is worthwhile for administrators and developers of other database systems who want to get into MariaDB really deep and compact. Details about the workshop day with Colin Charles can be found here: Workshop MariaDB in depth

MySQL and MariaDB: high availability and scalability

In the afternoon the workshop on MySQL and MariaDB high availability follows. Options like MySQL replication, MHA, DRBD, Tungsten, Galera Cluster are shown here. Pacemaker, Heartbeat and Percona Replication Manager are further topics. NDB clusters can distribute the workload. Geo-redundancy is also possible with a cloud. Tools for MySQL and MariaDB such as Orchestrator, Consul, MariaDB MaxScale & MySQL Router are also examined in detail. The evangelist Colin Charles speaks here too. Further information on the training is available here: MySQL and MariaDB high availability workshop

If you want to participate, you should hurry up with the registration: The number of participants is limited. Details can be found here: Registration for the MySQL / MariaDB workshop

Both workshops are in the program of the IT days - the annual conference of the IT news - embedded. They take place the day before the conference in Frankfurt am Main, in the Maritim Hotel at the Frankfurt Trade Fair. Participation is worthwhile. The trainer is a MySQL and MariaDB expert. He brings in-depth know-how and can confidently answer all the questions that are burning under your nails.

AH

In the future, you would like to receive the IT news be informed? Here you can sign up.