Author - Mike Benshoof

MySQL 101: How to Find and Tune a Slow SQL Query

tune a slow sql query

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 often than not caused by a bad query.  While everyone always hopes to recover through some quick config tuning, the real fix […]

Read more

What’s the Best Way to Enable (And Test) Encryption at Rest in RDS?

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 data is actually encrypted?”  We’ve all read whitepapers and […]

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

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

moving from on-premise to AWS 1

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 to the Cloud! Thoughts on Migrating Away from On-Premise I discussed […]

Read more