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

Why Enterprises are Moving to Containerization

enterprise moving to containers

As a Technical Account Manager, or TAM for short, I am fortunate to work with some large clients.  Most all of them are in some state of increasing their usage of containerization.  There are a number of reasons for this, but let’s explore a few of the biggest reasons.
Why Containers?
Almost everyone has deployed Virtual […]

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

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