lefred's blog


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

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


MySQL datamasking using ProxySQL

Percona Live Amsterdam is just finished… there was an entire room full day about MySQL 8.0 which is wonderful but there was also another product that everybody was talking about: ProxySQL (great job René). Ronald Bradford and the MySQL engineering team were discussing about what tool was missing in the MySQL ecosystem and Mark Leith highlighted that a datamasking utility … Read More


recent

Last Tweets Last Tweets

Locations of visitors to this page
categories