MySQL

Category to track posts in PlanetMySQL

18 Things You Can Do to Remove MySQL Bottlenecks Caused by High Traffic (Part One)

remove MySQL traffic bottlenecks

This is a three-part blog series. Be on the lookout for parts two and three in the coming days.
There was no reason to plan for it, but the load on your system increased 100%, 300%, 500%, and your MySQL database has to support it. This is a reality many online systems have to deal […]

Read more

Percona DBaaS CLI to Simplify Deployment in Kubernetes

Percona DBaaS CLI Kubernetes

We recently released an experimental version of percona-dbaas command-line tool with the goal of significantly simplifying the deployment of database instances in Kubernetes.
We have Kubernetes Operators for Percona XtraDB Cluster and Percona Server for MongoDB, which provide great flexibility, but they also come with the complexity of managing configuration and deployment files, so we […]

Read more

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

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