Wed, 17 Apr 2024 18:26:28 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/mysql-101-how-to-find-and-tune-a-slow-sql-query/ https://www.percona.com/blog/mysql-101-how-to-find-and-tune-a-slow-sql-query/#respond Wed, 03 Apr 2024 12:02:51 +0000 https://www.percona.com/blog/?p=69394 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 often than not caused by a bad or slow MySQL […]]]> https://www.percona.com/blog/mysql-101-how-to-find-and-tune-a-slow-sql-query/feed/ 0 69394 https://www.percona.com/blog/proxysql-for-short-term-application-fixes/ https://www.percona.com/blog/proxysql-for-short-term-application-fixes/#comments Tue, 04 Apr 2023 13:25:24 +0000 https://www.percona.com/blog/?p=86733 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 – Sharding Followup). Another use case I reference is “temporary […]]]> https://www.percona.com/blog/proxysql-for-short-term-application-fixes/feed/ 1 86733 https://www.percona.com/blog/column-level-encryption-in-mysql/ https://www.percona.com/blog/column-level-encryption-in-mysql/#respond Tue, 20 Sep 2022 12:01:35 +0000 https://www.percona.com/blog/?p=82731 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 of “encryption” at different levels.  I recently had this topic come up again, […]]]> https://www.percona.com/blog/column-level-encryption-in-mysql/feed/ 0 82731 https://www.percona.com/blog/postgresql-from-the-perspective-of-a-mysql-dba/ https://www.percona.com/blog/postgresql-from-the-perspective-of-a-mysql-dba/#respond Thu, 24 Mar 2022 13:26:06 +0000 https://www.percona.com/blog/?p=80450 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 looking at you SQL vs NoSQL). Lately, I’m […]]]> https://www.percona.com/blog/postgresql-from-the-perspective-of-a-mysql-dba/feed/ 0 80450 https://www.percona.com/blog/dbaas-and-the-enterprise/ https://www.percona.com/blog/dbaas-and-the-enterprise/#respond Fri, 14 Jan 2022 14:20:16 +0000 https://www.percona.com/blog/?p=79799 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 queries or design schemas. This is what triggers the […]]]> https://www.percona.com/blog/dbaas-and-the-enterprise/feed/ 0 79799 https://www.percona.com/blog/percona-server-for-mysql-encryption-options-and-choices/ https://www.percona.com/blog/percona-server-for-mysql-encryption-options-and-choices/#comments Tue, 04 Jan 2022 15:03:36 +0000 https://www.percona.com/blog/?p=79604 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 of the different options available for encryption in Percona Server […]]]> https://www.percona.com/blog/percona-server-for-mysql-encryption-options-and-choices/feed/ 1 79604 https://www.percona.com/blog/horizontal-scaling-in-mysql-sharding-followup/ https://www.percona.com/blog/horizontal-scaling-in-mysql-sharding-followup/#comments Tue, 28 Sep 2021 13:51:58 +0000 https://www.percona.com/blog/?p=78204 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 Primary Keys small Pruning data Finally, if those methods have been exhausted, I touched on horizontal sharding as the […]]]> https://www.percona.com/blog/horizontal-scaling-in-mysql-sharding-followup/feed/ 3 78204 https://www.percona.com/blog/horizontal-scalability-for-mysql/ https://www.percona.com/blog/horizontal-scalability-for-mysql/#respond Mon, 27 Sep 2021 14:40:47 +0000 https://www.percona.com/blog/?p=78112 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 isn’t a new challenge, but the best approach still […]]]> https://www.percona.com/blog/horizontal-scalability-for-mysql/feed/ 0 78112 https://www.percona.com/blog/migrating-into-kubernetes-running-the-percona-distribution-for-mysql-operator/ https://www.percona.com/blog/migrating-into-kubernetes-running-the-percona-distribution-for-mysql-operator/#respond Mon, 14 Jun 2021 13:43:41 +0000 https://www.percona.com/blog/?p=76660 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 the industry in terms of adoption.  In most cases, the questions stem around new deployments.  Our DBaaS tool (currently […]]]> https://www.percona.com/blog/migrating-into-kubernetes-running-the-percona-distribution-for-mysql-operator/feed/ 0 76660 https://www.percona.com/blog/which-version-of-mysql-should-i-use-for-myrocks/ Tue, 06 Apr 2021 05:08:42 +0000 https://www.percona.com/blog/?p=75080 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 many cases, this is in no way a trivial undertaking.Another approach that has been gaining interest […]]]> 75080 https://www.percona.com/blog/upgrading-to-mysql-8/ https://www.percona.com/blog/upgrading-to-mysql-8/#comments Fri, 02 Apr 2021 13:11:20 +0000 https://www.percona.com/blog/?p=75138 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, difficulty.”  While this is a bit of an exaggeration, in this case, the main concept […]]]> https://www.percona.com/blog/upgrading-to-mysql-8/feed/ 2 75138 https://www.percona.com/blog/working-to-validate-myrocks-in-the-enterprise-with-dropbox/ https://www.percona.com/blog/working-to-validate-myrocks-in-the-enterprise-with-dropbox/#comments Thu, 01 Apr 2021 18:21:22 +0000 https://www.percona.com/blog/?p=74812 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 is fun to “nerd out” and always strive to use the […]]]> https://www.percona.com/blog/working-to-validate-myrocks-in-the-enterprise-with-dropbox/feed/ 5 74812 https://www.percona.com/blog/whats-the-best-way-to-enable-and-test-encryption-at-rest-in-rds/ Wed, 15 Apr 2020 17:30:20 +0000 https://www.percona.com/blog/?p=66640 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 blogs […]]]> 66640 https://www.percona.com/blog/top-considerations-when-moving-from-on-premise-to-aws-part-two/ Thu, 02 Apr 2020 14:02:10 +0000 https://www.percona.com/blog/?p=66249 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 DifferencesOne of the most common issues I see revolves around […]]]> 66249 https://www.percona.com/blog/considerations-when-moving-from-on-premise-to-aws-part-one/ Tue, 31 Mar 2020 14:20:25 +0000 https://www.percona.com/blog/?p=66246 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 some […]]]> 66246 https://www.percona.com/blog/shared-responsibility-model-in-the-cloud-part-2/ https://www.percona.com/blog/shared-responsibility-model-in-the-cloud-part-2/#comments Mon, 23 Dec 2019 14:57:25 +0000 https://www.percona.com/blog/?p=64079 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 noted that regardless of the deployment method, there is always a […]]]> https://www.percona.com/blog/shared-responsibility-model-in-the-cloud-part-2/feed/ 1 64079 https://www.percona.com/blog/shared-responsibility-model-of-security-in-the-cloud/ Wed, 18 Dec 2019 14:35:02 +0000 https://www.percona.com/blog/?p=63935 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 security is owned by you.  Looking at the database layer specifically, these include (but are not limited […]]]> 63935 https://www.percona.com/blog/why-schema-optimization-matters/ Mon, 23 Sep 2019 17:20:19 +0000 https://www.percona.com/blog/?p=62004 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 optimization. Here’s the video: I was thinking about that talk […]]]> 62004 https://www.percona.com/blog/through-the-eyes-of-a-tam-at-percona/ Mon, 16 Sep 2019 17:24:49 +0000 https://www.percona.com/blog/?p=62124 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 different sorts of challenges that the database teams often face: Automation in […]]]> 62124 https://www.percona.com/blog/alters-foreign-keys-and-metadata-locks-oh-my/ Tue, 02 Jul 2019 13:23:36 +0000 https://www.percona.com/blog/?p=57411 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 table being altered was rarely updated and very small (<100 […]]]> 57411