Which companies prefer MariaDB or MySQL

author

IT current: What is the roadmap for MariaDB? What can users expect in the near future?

Patrik Sallner:We want to be the best open source relational database for web scaling, cloud computing and SaaS. That is our mission. To do this, we continuously innovate in the areas of performance, scalability, usability and security. Our upcoming version MariaDB 10.1 will offer many enhancements such as Optimistic Parallel Replication, support for idle encryption at table level, binary integration of Galera Cluster and full GIS / OGC compliance.

In close collaboration with IBM, we recently ported and optimized MariaDB for the IBM Power 8 server platform. In view of these optimizations, the benchmarks show a 2.2-fold improvement in performance compared to the Intel Ivybridge X86 architecture.

During 2014 we introduced MariaDB corporate subscriptions that provide our customers with mature and certified binaries along with a range of support and advanced services. For example, we recently introduced the notification service within the MariaDB Enterprise (MDBE) offering. The notification service allows customers to profile their use of MariaDB so we can give them personalized instructions about which upgrades and patches they need. In addition, based on our team's many years of practical experience, we have provided a recommended my.cnf configuration. We will continue to offer these services created by MariaDB to improve the business experience.

MariaDB MaxScale was released as a GA version in mid-January 2015. MaxScale is an intelligent proxy that sits between your applications and the database infrastructure. Maxscale can be used to transform the communication between the application and the database, opening many new features, such as load balancing, query transformation, cluster monitoring, and query performance logging, without modifying your application. Beta customers have already discovered a wide range of new ideas and uses for Maxscale.

IT current: What new elements will we find - as distinguishing features from MySQL - in MariaDB?

Patrik Sallner:At MariaDB Enterprise, we recently launched our notification service, which is designed to provide guidance to our customers as to which patches and upgrades to implement. The service works by profiling the database and then using this profile to make automatic comparisons with change logs and to make recommendations.

Earlier this year we launched the MariaDB MaxScale proxy. MariaDB MaxScale is a flexible proxy that sits between an application and the database. This allows us to introduce a number of new services such as read / write splitting, protocol filtering and query transformation without having to change the application code.

We will also be launching MariaDB 10.1 in the first part of this year. This new version includes a number of new features and enhancements including:

  • Integration of Galera cluster capability for synchronous replication
  • Optimistic parallel replication
  • Database encryption - per table or complete database
  • numerous further developments for InnoDB and the optimizer to improve performance

IT current: MariaDB is included in all distributions. Why should companies choose MariaDB over MySQL?

Patrik Sallner:MariaDB has stood for innovation from the start, such as an enormously advanced optimizer, significant replication improvements, greater compatibility with other databases and the introduction of MaxScale. Internet leaders like Google use MariaDB and are doing their part by making sure we are always looking for improvements in achieving scalability and performance.

MariaDB has a long tradition of being open and community oriented. Many different developers, from individual contributors to companies like Google, are doing their part.

From a commercial point of view, the quality and the price-performance ratio of our support and technology are convincing. Gartner recently positioned us in the Leader's Quadrant for operational databases based on rich functionality, value for money and a strong third-party ecosystem.

IT current: MariaDB and MySQL are diverging faster. In which cases is Percona the better alternative?

Patrik Sallner:There are certainly areas where MariaDB and MySQL offer innovations in different directions. However, our goal is to maintain application-level compatibility with MySQL.

MariaDB was created as a synthesis of the very best - we will continue to incorporate the key features of MySQL in conjunction with selected features from other MySQL development branches such as WebscaleSQL and Percona Server along with all of the MariaDB-specific innovations from our community.

IT current: Precisely because MariaDB is very popular with distributions, there have been questions as to why MariaDB installs SystemV init scripts in its own packages and does not support systemd. Why is that?

Patrik Sallner: MariaDB has some catching up to do in terms of supporting systemd. This will be available in a later version.

IT current: Does MariaDB rely on certification for products such as B. hubris?

Patrik Sallner:ISV certification is an important element in driving a rollout. In the course of 2015 we would like to strive for ISV certification much more actively. The fact that MariaDB is now the default database for both Red Hat and SUSE Linux should pave the way for this effort. In addition, because MariaDB is application-level compatible with MySQL, it is very easy for an ISV to test and certify MariaDB.

IT current: What is the roadmap for MySQL replication? Will there be administration tools like mysql-utilities or mha for the GTID implementation of MariaDB?

Patrik Sallner: A major replication enhancement called Optimistic Parallel Replication will be available in MariaDB 10.1. In version 10.0 of the parallel replication, transactions used in parallel on the master could be executed in parallel in the replication. Now every transaction is considered to be running in parallel, which gives master-slave replication a further boost in performance.

Galera's synchronous replication will be included by default in MariaDB 10.1. A separate server version is no longer required. We are considering contributing MariaDB GTID support to MHA.

IT current: MariaDB has tons of amazing storage engines. While a program for binary online backups exists for InnoDB / XtraDB with innobackupex / xtrabackup, this is missing for other storage engines. So a logical backup z. B. especially from TokuDB, which wants to process very large amounts of data, impractical. Will there also be a binary online backup tool here or will one have to fall back on Tokutek's proprietary solution?

Patrik Sallner:The backup solutions used at TokuDB should either create LVM backups or hot backups. The latter is included in the Tokutek Enterprise subscription.

IT current: With MariaDB 10.1, Galera is no longer a separate package. Have you thought about merging the two GTID implementations (MariadB and Galera)?

Patrik Sallner:We have already made progress here. With MariaDB 10.1 we integrate Galera. This Galera integration already uses MariaDB GTID.

IT current: There was some confusion that the MariaDB trademark was sold to SkySQL (now MariaDB Corporation). Why was this necessary?

Patrik Sallner:SkySQL has made a significant investment in both the Monty Ab program and the future of MariaDB. We had an urgent need to grow and protect the MariaDB brand for the benefit of the wider community and to ensure increasing, continuous investment in the project. Our goal has always been and remains to use the trademark for the benefit of the wider community. We have also licensed major server brands back to the Foundation. Our success depends on the success of the community.

IT current: Will this bring more movement into the market - ultimately especially with regard to the service offerings?

Patrik Sallner:Our goal is always to use the trademark responsibly for the benefit of the MariaDB community and affiliated companies. Guidelines have been published so that it is clear and generally known what rights and responsibilities we and others have with respect to the trademarks.

This shouldn't be a real obstacle for market participants. In addition, the further acceptance that we are promoting with the community will encourage further participants. There is a growing ecosystem of companies developing solutions, tools and services for and with MariaDB.

IT current: Can we expect that we will soon see more corporate members?

Patrik Sallner:We encourage and look forward to more corporate members and sponsors. The most important thing is continuous growth in introductions and code contributions.

We're working with the Foundation and other community members to build a dynamic community of contributors and users. The Foundation is committed to keeping MariaDB fully open through a friendly participatory policy. Under the Foundation's leadership, we've seen continued growth in contributors from individuals to companies like Google.

IT current: Can you tell us a little more about the MariaDB Foundation and what it does?

Patrik Sallner:The Foundation's goal is to set the direction for MariaDB and to build a strong and open community around MariaDB. It is also her goal to ensure the continuous development of MariaDB beyond each individual company for many years. The Foundation recently launched the MariaDB Ambassador Program to further increase community acceptance of MariaDB and promote development contributions.

The MariaDB Ambassador Program was established to identify and support seasoned contributors to the MariaDB and MySQL ecosystem who are responsible for representing the use of MariaDB and its ideals to the broad open source community and the general public to promote and expand. The Community Ambassadors will promote grassroots acceptance in their respective regions. The Platform Ambassadors will make their virtual contribution by creating codes, patches and functions. It is they who do the technical work for MariaDB in their respective organizations.

IT current: Where should MariaDB be in 5 years? What is your vision?

Patrik Sallner: For the past two years, MariaDB has taken MySQL's place in most Linux editions, making MariaDB the "M" in the "LAMP" stack. Our goal is to become the most widely used database for cloud stacks and SaaS deployments by 2020.

IT current: Mr. Sallner, thank you very much for the interview.

Andrea Held asked the questions.