Many web hosting provider are looking for HA solution for the database backend they deliver to their customers. Galera never became the perfect choice for these environment due to 2 factors: no DBA really manage the databases Galera runs database…
On February 3rd, just before Fosdem and the MySQL & Friends Devroom, MySQL’s Community Team is organizing the pre-Fosdem MySQL Day. Today’s highlighted sessions are the one of Øystein Grøvlen: MySQL 8.0: Common Table Expressions (CTEs) Using Optimizer Hints to…
As written yesterday, on February 3rd, just before Fosdem and the MySQL & Friends Devroom, MySQL’s Community Team is organizing the pre-Fosdem MySQL Day. The second talk of this series is the session of Bernt Marius Johnsen: MySQL 8.0 &…
Fossasia 2017 will take place 17th – 19th March 2017 in Singapore. Like previous edition, MySQL will sponsor this event. This year the organizers are looking for MySQL speakers. So if you are interested to speak about your favorite database…
On February 3rd, just before Fosdem and the MySQL & Friends Devroom, MySQL’s Community Team is organizing the pre-Fosdem MySQL Day. We increased the amount of seats, so there are still some tickets available, don’t hesitate to register, this will…
Hi ! I’m starting a small series of videocast related to MySQL Group Replication. As I blogged earlier this year about Single-Primary or Multi-Primary Group Replication cluster, one of the limitation of using a cluster in Multi-Primary mode is the…
Today’s blog post is related again to MySQL Group Replication. By default MySQL Group Replication runs in Single-Primary mode. And it’s the best option and the option you should use. But sometimes it might happen that in very specific cases…
This year, I’ve the honor to organize just before the FOSDEM MySQL & Friends Devroom an extra pre-FOSDEM MySQL Day. This MySQL Day will take place the Friday just before FOSDEM’s week-end. During that day, we will highlight MySQL 8.0…
Today in our series of articles related to MySQL Group Replication’s limitations, let’s have a quick look at Savepoints. The manual is clear about this: Transaction savepoints are not supported. The first thing to check then is if the application…
Today’s article is about the first two restrictions in the requirements page of the manual: InnoDB Storage Engine: data must be stored in the InnoDB transactional storage engine. Primary Keys: every table that is to be replicated by the group…
In this article, I will show you how it’s possible to perform an online migration from a 3 members Galera cluster setup (in this case I’m using PXC 5.7.14) to a 3 members MySQL Group Replication cluster setup (MySQL Community…
It’s a wonderful news, we have released MySQL 5.7.17 with Group Replication Plugin (GA quality). From the definition, Group Replication is a multi-master update everywhere replication plugin for MySQL with built-in conflict detection and resolution, automatic distributed recovery, and group…
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.