lefred's blog


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

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


MySQL Datamasking using ProxySQL – part 2

First of all I want to say thanks to Thomas that sent me feedback on part1 (see his comment). And indeed all three cases were able to defeat the datamasking. I rewrote then the rules to also take those cases in consideration: ProxySQL> DELETE FROM mysql_query_rules where rule_id < 50; ProxySQL> INSERT INTO mysql_query_rules (rule_id,active,username,match_pattern,replace_pattern,apply) VALUES (1,1,’devel’,’`cc_num`’,”cc_num”,0); ProxySQL> INSERT INTO … Read More


recent

Last Tweets

Locations of visitors to this page
categories