lefred's blog


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

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


MySQL Day – Sessions review #7

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 in various sectors for large corporations. With more then 20 years of industry experience he has acquired skills for managing … Read More


MySQL Group Replication, the perfect HA database backend for web hosting

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 changes in Total Order Isolation What does that really mean ? In fact, when you are a website hosting provider, … Read More


How to migrate from Galera Cluster to MySQL Group Replication

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 5.7.17). Don’t forget that before adopting Group Replication as database backend, you should validate that your application do match GR … Read More


recent

Last Tweets Last Tweets

Locations of visitors to this page
categories