Skip to content

As alway with new technology there is always different approaches regarding the adoption.
You can try to use the bleeding edge features or start with a very standard configuration.
My personal advise to new users is to start with the most basic configuration.

This allow you to get familiar with the fundamentals :
- how to install
- how to operate
- how to monitor

For MariaDB Galera Cluster he most basic configuration is a 3 nodes cluster. You can chose to use it :
as an HA solution
Galera Cluster is currently the easiest way to solve the HA problem.
when you think HA think Galera Cluster it is so much simpler. Failover is totally transparent and you have nothing to do like you would have with standard replication. if you have a lodbalancer in front you just have to push out from the configuration THE FAILED NODE and that is done.

as a scale out solution
A usual MySQL scale out architecture is based on master/slaves architecture. This solution incurs to the application the choice of where to send the read (Master or most up to date slave…). Scale out of read with Galera cluster synchronous replication is much simpler. Nothing need to be done at the application layer.
You have a synchronous data up to data available on all nodes . You do not have the risk to read stale data when the replication lags. Nothing need to be done at the application level like taking care of reading were you write to have correct data.

Contrary to usual HA solutions or compare to MySQL cluster Galera Cluster is very simple to setup and operate.
Getting Started with MariaDB Galera Cluster

Then of course next step is to push Galera usage a little bit further. One main area is of course write scalability.
A few benchmark have been produced but we do not have yet much experience and  you have to be more careful. With write/write configurations you have to be careful about hot spots in the database. This can lead to deadlock and the behavior has to be correctly understood.

A good distribution for download to do your testing is : MariaDB Galera Cluster 5.5.29 Stable

Some useful pointers to understand various behaviours of Galera Cluster.

 

------- upcoming events :

Tomorrow Seppo Jaakola, Codership, will present Galera Cluster for MySQL & MariaDB at the Meetup SkySQL & MariaDB - Paris

Henrik Ingo, Max Mether and Colin Charles will present "MariaDB Galera Cluster Overview" at the free MySQL & Cloud Solutions Day taking place in Santa Clara the 26th of April. You can register for free.

 

Oracle will be at Percona Live. This is a great news. Oracle was totally absent at last year edition. Not taking part to business event organized by competitors is a frequent Oracle Corporation behavior. Percona Live is a business event own by Percona (one of Oracle competitor) and some other Oracle competitors like SkySQL/MariaDB will also take part to the event. This is really nice that Oracle make this exception this year. MySQL is an open source ecosystem and having everyone at a common even is a very positive thing (even if the event is own by one of the parties and not yet a truly community even).

Gathering so many MySQL talents at the same place is exceptional. After FOSDEM 2013 event where all components of MySQL were gathered in the same room I realized how great it was to have MariaDB / Percona / Oracle peoples at the same Place. This triggers nice discussions as we all know each others for a long time and we share some common interests.

Last year Oracle was totally absent of Percona live. Oracle preferred to send all their new announcement during the conference through blogging. The community was expecting the same process this year 😉 Pushing key technical informations without interacting directly with the community was not what an open source community expect. This is great to have people live to interact with the MySQL community. MySQL is a turbulent community were discussion is a fundamental process to move things in the right direction. We are all fans of technology and having everyone at the same place will for sure trigger nice discussions.

Oracle is sending very nice ambassadors :

Tomas Ullin managing MySQL engineering at Oracle has successfully be turning MySQL into an "Enterprise Class Database". This is great and we can definitely thank him for that. I personally was not expecting that Oracle would push MySQL in area like scalability on 64 cores, crash safe replication, enhanced security features … which turn MySQL into a product that in many cases competes very efficiently against Oracle flagship product Oracle 11g (with a much lower cost of ownership 🙂 ). Oracle has not yet acknowledge this fact and its marketing still position MySQL as the database for the web. For many users MySQL now is definitely much more. Most of the new support paying customers are in the enterprise market. This is a fantastic achievement.

Dimitry Kravtchuk whose benchmarking expertise has given many people an invaluable insight into the MySQL Server behavior. I consider him as the Sherlock Holmes of MySQL with all the astounding investigation he conducted on the server behavior. Most of these investigations have shed light on very peculiar behaviors and lead to the correct interpretation and trigger big progress in the code.

Luis Soares takes care of MySQL replication. Replication is with is with scalability the second most important area of MySQL. This is an area of great innovation.

All these people have a long history of commitment with MySQL as an open source product before it belonged to SUN or Oracle. They really know what an open source ecosystem is. We will have here a real opportunity to talk technical subjects and confront approach to various problems.

But beside being a product where technical excellence matter MySQL is an ecosystem with a lively community. For me leading the community does not just mean leading by having technical excellence. This is necessary but far from enough. In an open source community there are fundamental questions that cannot be avoided. Beside being a product where technical excellence matter governance and fairness is key. We all know that open source is build on values and principles based on sharing and fairness.  Like most of you I prefer technology to politics but sometime politics is essential no to be lead by small nice steps to a place where you were not initially planing to go.

Thank to Oracle for the technical excellence and the investment made and to come.

But I think of a few non technical questions that really matter for the MySQL community (Support providers, Storage engine developers, OEM customers …) and that need to be raised. These questions are fundamental for many peoples to have a clear idea of what kind of governance Oracle envision for MySQL future.

Do Oracle believe that the current MySQL development process is adapted to an open source product with a vibrant community and many active contributors ?
Oracle approach is based on no communication / no sharing with the community except the end result. This give the community no insight on the design choices which are not open to discussion. This can have a very negative impact on the ability of the MySQL community to improve the product and keep up with the code. In the past most of the key improvements, innovations, ideas have come from community members (individual, big users like Google, Facebook, Twitter …). MariaDB in this respect has kept the principle of 100% transparency. This event will be a good opportunity for the MariaDB team to show the long term benefit you get from this 100% transparent / 100% open source / open to fair competition approach.

What is the official process to guaranty that in the future the code will be released on launchpad in a timely and fair way ?
There has been multiple issues in the past regarding releasing the code late or regarding the revision history. Stewart smith(Percona) has been a good advocate on this subject. Percona depend heavily on the good will of Oracle to be able to produce their own version of the server. Any problem can greatly impact them and many others. MariaDB that fully own its own codebase as of MariaDB 10 is more immune to these issues. But MariaDB also depend on Oracle to back port features and guaranty that the MariaDB product is truly a MySQL dropin.

Do you plan to go further into providing new features as closed source extensions. Does the community has any guaranty that MySQL will under Oracle governance remain an open source product in the long term ?
The first closed source extension for MySQL(Thread pool, authentication plugin) appeared under Oracle governance in 2011. MySQL 5.6 has brought a new closed source features with the audit plugin. Adding closed source features lead to lock-in situation. Most of the closed source feature have been redeveloped by MariaDB as open source features. Redeveloping these features is an unnecessary burden for the community. Some people even consider that in this respect you do not comply with the promise made to the European commission to keep MySQL open source.

Do you plan to have a process to keep the bugs database open and to release test cases ?
There has been recently a lots of complains by the community regarding this subject. Keeping an open bug database  is vital to guaranty that third party or linux distribution can validate non regression of their version. Valeri Kravtchuk (Perconna) has with a deep knowledge of the bug process put some light on all these issues. Do we have statistics on the amount of bug entered in the public database that are turn into private ? It seems that the proportion is increasing over time. It would be great to clarify on this point and to have public numbers and justifications. Closing the bug database even partially is a long term threat to the MySQL product. I am not speaking of the second bug database used by paying customer. I imagine that in the end both the community and people running the Enterprise should hit the same bug that should end up in both bug databases. I am of course not speaking neither of bugs related to closed source features which are the sole responsibility of Oracle and where the community cannot help 😉

Will oracle extend the period regarding the commitments they made to European Commission regarding MySQL to get clearance when buying SUN ( MySQL included ) ?
In my personal opinion this is necessary to keep MySQL community trust in Oracle governance of MySQL. Oracle commitment made to EC for 5 years will reach an end at the end of 2014 and this is raising worries for many members of the MySQL community (customers, OEM vendors, third parties developing storage engines…). To be honest rereading these commitment and putting a negative operator in front of each of them is totally and absolutely frightening for MySQL future :
http://www.oracle.com/us/corporate/press/042364
Oracle should give guaranties to the community. They have a big responsibility in this respect.

So having Oracle at Percona Live is a really nice great news. Oracle people will be really welcome by the MySQL community. This will be a good opportunity to talk about technology and confront our vision of the future.
But it would also be nice if Oracle could bring some answers regarding their fair governance of MySQL.
Oracle has a huge responsibility in this respect and the MySQL community is very attentive on this subject.
Technical excellence of one of the actor of the MySQL ecosystem is one element among others regarding the successful future of MySQL as an open source product.

---------------------

Based on Matt Keep valuable twit on : "For those who engage in swearing & general profanity at work, a handy guide of suggested alternative phrases" I have tried to expunge my initial prose from any bad words. 🙂

MySQL has a long history since its birth 18 years ago when Monty Widenius and David Axmark started it.
Planet MySQL started in 2004 and all its history is archived.  Let us dig in it.
It is always good to look back at the past to get some lessons for the future. Here are the 20 most positively voted blog posts since Planet MySQL birth. By positive blog post I mean the one with the biggest positive number of votes versus negative ones. So inside this chart you have false positive which are also very controversial subject ( lots of + and lots of  - with a majority of +).

Planet MySQL is like military archives that you can open after some time when passions have cooled down  (it might not be true for everyone or for every subject ;-))

First column is the excess of plus vote versus negative ones.
61     / 2009-12-21      What do MySQL staff think of the acquisition?    - Ronald Bradford
38     / 2011-03-08      The MySQL Council addresses the public bug database issue   - Giuseppe Maxia
30     / 2009-12-30      Save MySQL save the world   - Mark Callaghan
27     / 2010-10-12      Welcome SkySQL!   - Gary Pendergast
25     / 2009-12-29      Save MySQL by letting Oracle keep it GPL   - Sheeri K. Cabral
24     / 2011-08-09      Santa Clara MySQL Conference 2012: Unity or division?   - Kaj Arno
22     / 2011-08-10      Call for disclosure on MySQL Conference 2012   - Giuseppe Maxia
22     / 2010-10-19      Using MySQL as a NoSQL - A story for exceeding 750000 qps on a commodity server   - Yoshinori Matsunobu
20     / 2011-01-13      Temporary files binlog_cache_size and row-based binary logging  - Chris Calender
19     / 2010-01-03     Tales of the Trade #2: The Oracle-Sun deal   - Shlomi Noach
18     / 2010-12-15      MySQL 5.5 is GA!   - Oracle MySQL Group
17     / 2011-02-21      Where have the bugs gone?   - Mark Callaghan
17     / 2010-09-29      The MySQL swap insanity problem and the effects of the NUMA architecture   - Jeremy Cole
16     / 2009-08-04      XtraDB has been commited to MariaDB   - MySQL Performance Blog
16     / 2010-07-09      Using EXPLAIN EXTENDED / SHOW WARNINGS to Help Troubleshoot Inefficient Queries   - Chris Calender
16     / 2010-09-28      I need a new keyboard   - Domas Mituzas
16     / 2011-08-10      What is happening with the MySQL conference?   - Michael
16     / 2012-08-17      (less) open source   - Mark Callaghan
16     / 2010-08-28      MySQL 5.1 Plugins Development Published   - Andrew Hutchings
15     / 2011-02-22      Oracle introduces new levels of sucking to new versions of old software   - Monty Taylor

First kudos to Shlomi who wrote 2009-12-21 : "Ronald: you will remain #1 of all times for long time to come!" This was a good prediction as this blog post is still number one. I love  Tales of the Trade #2: The Oracle-Sun deal where this prediction happened.

Second lesson learned is not to trust the internet. For example  MySQL 5.1 Plugins Development Published  does not point any more to where it should. This is unfortunate that  there is nothing like  UUID  URI. Internet memories are not garantied : all MySQL DBA knows that : do backups 🙂 And  "MySQL 5.1 Plugins Development" remains an excellent book even if the pointer is gone.

This also illustrates the ability of a crowd to make important  choices  : "I need a new keyboard"  got a very good ranking. I really hope Domas that you got your new keyboard. Is it wireless ?

Some question should be hard as it seem they remain unanswered :  Where have the bugs gone? was raised  2011-02-21.

Some titles can be misinterpreted : Oracle introduces new levels of sucking to new versions of old software . That is a good lesson if you make book reviews. You should not just read the title . What sucked for Monty Taylor at that time is not what sucks for us now.

Some question do have an answer : What is happening with the MySQL conference? Well, It is taking place in April in Santa Clara but it is now called "Percona Live". It could have had a different answer and in the future it might have another different one. Who knows ? Shlomi you who made a good prediction  : Do you have any prediction, hint, advices ?

Enjoy 🙂