by Mike Benshoof | Apr 3, 2024 | Insight for DBAs, Monitoring, MySQL, Percona Software
This blog was originally published in June 2020 and was updated in April 2024.One of the most common support tickets we get at Percona is the infamous “database is running slower” ticket. While this can be caused by a multitude of factors, it is more... by Mike Benshoof | Apr 4, 2023 | Insight for DBAs, MySQL, ProxySQL
When talking about the benefits and use cases of ProxySQL with clients, one feature I generally reference is the query rewrite engine. This is a great feature that is often used for sharding (I’ve written about this in the past at Horizontal Scaling in MySQL... by Mike Benshoof | Sep 20, 2022 | Insight for DBAs, MySQL, Percona Software, Security
In a post written earlier this year – Percona Server for MySQL Encryption Options and Choices – I discussed some of the options around encryption in MySQL. Being such a complex topic, that post was meant to clarify and highlight various aspects... by Mike Benshoof | Mar 24, 2022 | Insight for DBAs, MySQL, PostgreSQL
DBAs can be set in their ways. Oftentimes, we start with a particular flavor and from that moment until the end of time, it will always be “the best”. In some cases, the debate is actually based on matching the use case to the proper tech (I’m... by Mike Benshoof | Jan 14, 2022 | Cloud, Database Trends, Percona Services, Percona Software
Install a database server. Give the application team an endpoint. Set up backups and monitor in perpetuity. This is a pattern I hear about regularly from DBAs with most of my enterprise clients. Rarely do they get to troubleshoot or work with application teams to tune... by Mike Benshoof | Jan 4, 2022 | MySQL, Percona Software, Security
Security will always be a main focal point of a company’s data. A common question I get from clients is, “how do I enable encryption?” Like every good consulting answer, it depends on what you are trying to encrypt. This post is a high-level summary... by Mike Benshoof | Sep 28, 2021 | Insight for DBAs, Insight for Developers, MySQL
In a previous post, A Horizontal Scalability Mindset for MySQL, I discussed the concerns around growing individual MySQL instances too large and some basic strategies: Optimizing/minimizing size with proper data types Removing unused/duplicate indexes Keeping your... by Mike Benshoof | Sep 27, 2021 | Insight for DBAs, MySQL, Percona Services, Percona Software
As a Technical Account Manager at Percona, I get to work with many of our largest clients. While the industry verticals vary, one main core challenge generally remains the same – what do I do with all this data? Dealing with massive data sets in MySQL... by Mike Benshoof | Jun 14, 2021 | MySQL, Percona Software
The practice of running databases in containers continues to grow in popularity. As a Technical Account Manager at Percona, I get asked regularly about our Percona Distribution for MySQL Operator. Additionally, I’m asked what I’m seeing in... by Mike Benshoof | Apr 6, 2021 | MySQL, Percona Software, Storage Engine
As database footprints continue to explode, many companies are looking for ways to deal with such rapid growth. One approach is to refactor traditional relational databases to fit into a NoSQL engine, where horizontal scalability is easier. However, in... by Mike Benshoof | Apr 2, 2021 | Insight for DBAs, MySQL, Percona Services
Nobody likes change, especially when that change may be challenging. When faced with a technical challenge, I try to remember this comment from Theodore Roosevelt: “Nothing in the world is worth having or worth doing unless it means effort, pain,... by Mike Benshoof | Apr 1, 2021 | MySQL, Percona Software, Storage Engine
Percona Technical Account Managers get the privilege of working with some of our largest enterprise clients day in and day out. As such, we get to really focus on how to best leverage our technology to generate measurable benefits for our users. While it... by Mike Benshoof | Apr 15, 2020 | Cloud, MySQL, Percona Services, Security
The other day on a call, a client asked me an interesting question. We were discussing some testing they were doing in Amazon Relational Database Service (RDS). The question came up “since RDS is managed, how can I prove to my security team that the... by Mike Benshoof | Apr 2, 2020 | Cloud, Database Trends, Percona Services
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... by Mike Benshoof | Mar 31, 2020 | Cloud, Database Trends, Percona Services
One of the most common questions I get as a Technical Account Manager (TAM) from clients considering a migration from their current on-premise data center to AWS is “what are the biggest differences I will need to address?” In an earlier post MySQL... by Mike Benshoof | Dec 23, 2019 | Cloud, MySQL
In an earlier post, I discussed the Shared Responsibility Model in the cloud and how it relates to databases. With either IaaS or DBaaS deployments, much of the operational and security burden is shifted away from the DBA to the cloud provider. I also... by Mike Benshoof | Dec 18, 2019 | Cloud, Database Trends, MySQL
When we think about the cloud, often we consider many of the benefits: scalability, elasticity, agility, and flexible pricing. As great as these features are, security also remains a business-critical concern. In an on-premise environment, every aspect of... by Mike Benshoof | Sep 23, 2019 | Insight for DBAs, MySQL
If you have been around MySQL for any length of time, you are probably aware that choosing the correct data types and optimizing your schema are actually important tasks. A few years back at Percona Live 2016, I gave an introductory talk on schema review and... by Mike Benshoof | Sep 16, 2019 | Percona Services
As a Technical Account Manager at Percona, I get the privilege of working with some of our largest clients. It is exciting to work where I get to see massive deployments that are pushing current utilization limits. In these environments, however, there are... by Mike Benshoof | Jul 2, 2019 | Insight for DBAs
I’m sure you’ve seen it – you kick off an ALTER and you get the dreaded “waiting on metadata lock”. In many cases, this is expected if you are actively working on the table. However, I recently had a case with a client where the...