ProxySQL is the leader in proxy and load balancing solution for MySQL. It has great features like query caching, multiplexing, mirroring, read/write splitting, routing, etc… The latest enhancement in ProxySQL is the native support of MySQL Group Replication. No more…
As you know, MySQL Group Replication runs by default in single primary mode. mysql2 mysql> show global variables like ‘group_replication_single_primary_mode’; +—————————————+——-+ | Variable_name | Value | +—————————————+——-+ | group_replication_single_primary_mode | ON | +—————————————+——-+ But how can we easily find which…
Yesterday I was invited to speak at the “Jeudis du Libre” in Mons. The location was very special as it was in one auditorium of Polytech, the oldest university in the city of Mons. I presented in French two very…
We saw yesterday that the new MySQL Shell was out and how we could create a MySQL InnoDB Cluster manually using the Shell. Today, I would like to show you how easy it is to create recipes to automate all…
Earlier this week, MySQL Shell 1.08 has been released. This is the first Release Candidate of this major piece of MySQL InnoDB Cluster. Some commands have been changed and some new ones were added. For example the following useful commands…
The documentation states that “For a transaction to commit, the majority of the group have to agree on the order of a given transaction in the global sequence of transactions.” This means that as soon as the majority of nodes…
After some feedback we received from early adopters or discussions during events like FOSDEM, I realized that there is some misconception about the type of replication that MySQL Group Replication is using. And even experts can be confused as Vadim’s…
FOSDEM 2017 is over, I brought back home the flu…. but hopefully not only ! Indeed this 2017 edition was very rewarding. We started our FOSDEM with a “fringe” : pre-FOSDEM MySQL Day where we highlighted MySQL 8.0 new features…
Let’s finish these pre-FOSDEM MySQL Day Sessions reviews with Kenny Gryp‘s talk on MySQL Group Replication. Kenny is working at Percona as MySQL Practice Manager. Group Replication went Generally Available end of 2016, it introduces a (virtually) ‘synchronous’ active:active multi-master…
One of the talk will replaced in the schedule by a panel discussion moderated by Morgan Tocker on MySQL Group Replication & MySQL 8.0. The panel list will be composed of These experts will answer questions…
Let’s finish this pre-FOSDEM MySQL Day Sessions review week with Norvald Ryeng‘s talk on MySQL 8.0 and GIS. As you know pre-FOSDEM MySQL Day will take place on Friday February 3rd in Brussels. During this day dedicated to MySQL and…
Today I will present the unique ProxySQL session of the pre-FOSDEM MySQL Day. Alkin Tezuysal will share with the audience ProxySQL Use Case Scenarios Alkin is Senior Technical Manager at Percona and has extensive experience in enterprise relational databases working…