lefred's blog


There Are 10 Types of People in the World....

MySQL Group Replication: read your own write across the group

Today is my last day in Asia (China and Taiwan), and between the sessions I had the time to code a small proof-of-concept for people that are asking how they could read their writes on all nodes and ensure the read consistency with their last write ? The usual (and easier) answer to this particular question is to read on … Read More


ProxySQL and MySQL 8.0.2 (la suite)

Recently I wrote a blog post on how to use ProxySQL with 8.0.2 dmr This blog post was related to the change we implemented in the Group Replication’s monitoring (performance_schema tables) and how sys schema should be changed to modify the view used by ProxySQL according. However, I used my labs machines that I was using for different purposes too … Read More


MySQL 8.0.2 is out, some change is required to still use ProxySQL with GR

As you may know by now, MySQL 8.0.2 DMR is out ! \o/ Many features have been added (see Geir Høydalsvik‘s announcement) and of course the replication also brought new features and improvements (see this post from Luís Soares). But some improvements in the monitoring broke the added sys view used by ProxySQL to monitor the state of a member … Read More


MySQL Group Replication: native support in ProxySQL

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 need to use an external script within the scheduler like I explained in this previous post. This implementation supports Groups … Read More


FOSDEM 2017 is over… this was again a great MySQL event !

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 and hosted some talks from MySQL friends. This first edition of the pre-FOSDEM MySQL Day was a great success. We … Read More


recent

Last Tweets Last Tweets

Locations of visitors to this page
categories