ProxySQL 2.0.9 Introduces Firewall Whitelist Capabilities

ProxySQL Firewall Whitelist

In this blog, we will test a new security feature added in ProxySQL 2.0.9. Since a time ago, we have had the ability to block queries using mysql_query_rules table matching a group of queries using reg exp like a blacklist. Check out a previous blog for how to config “ProxySQL Firewalling” using the mysql_query_rules […]

Read more

Top Considerations When Moving from On-Premise to AWS (Part Two)

moving from on-premise to AWS 2

As discussed in part one, this series is meant to go over some of the biggest differences you will likely encounter when moving from on-premise to the cloud.  In this portion, I’ll look at the architectural and operational differences that are commonly seen.
Operational and Architectural Differences
One of the most common issues I see revolves […]

Read more

Introducing Metabase, a Simple and Powerful Analytics Tool

metabase

Recently I was looking for some simple way to analyze and create graphs from data stored in MySQL tables. I know Grafana can also plot graphs from MySQL tables, but somehow it felt like overkill and you are not using the traditional SQL syntax there. So I was searching for another solution, and it […]

Read more

Tips for MySQL 5.7 Database Tuning and Performance

MySQL 5.7 Database Tuning

While there is no magic bullet for MySQL 5.7 database tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. While much information has been published on this topic over the years, I wanted to break down some of the more critical […]

Read more

#PerconaChat — 5 Essential Practices for Remote Working

perconachat

Percona recently hosted a #PerconaChat to discuss and share some of the things we find most essential to be successful while working remotely. Even before the viral outbreak, Percona was an almost 100% remote company, so it was great to be able to impart some of our learnings.
David Busby — Information Security Analyst, Percona, […]

Read more