Mon, 01 Apr 2024 17:11:40 +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/caching_sha2_password-support-for-proxysql-is-finally-available/ https://www.percona.com/blog/caching_sha2_password-support-for-proxysql-is-finally-available/#respond Mon, 01 Apr 2024 17:11:40 +0000 https://www.percona.com/blog/?p=95205 ProxySQL recently released version 2.6.0, and going through the release notes, I focused on the following:Added support for caching_sha2_password!This is great news for the community! The caching_sha2_password authentication method for frontend connections is now available. This has been a long-awaited feature …Why?Because in MySQL 8, caching_sha2_password has been the default authentication method. Starting from MySQL […]]]> https://www.percona.com/blog/caching_sha2_password-support-for-proxysql-is-finally-available/feed/ 0 95205 https://www.percona.com/blog/using-jobs-to-perform-schema-changes-against-mysql-databases-on-k8s/ https://www.percona.com/blog/using-jobs-to-perform-schema-changes-against-mysql-databases-on-k8s/#respond Tue, 10 Oct 2023 12:02:54 +0000 https://www.percona.com/blog/?p=89761 Performing an operation is always challenging when dealing with K8s.When on-prem or DBaaS like RDS or Cloud SQL, it is relatively straightforward to apply a change. You can perform a DIRECT ALTER, use a tool such as pt-osc, or even, for certain cases where async replication is in use, perform changes on replicas and failover.In […]]]> https://www.percona.com/blog/using-jobs-to-perform-schema-changes-against-mysql-databases-on-k8s/feed/ 0 89761 https://www.percona.com/blog/when-should-i-use-amazon-aurora-and-when-should-i-use-rds-mysql/ https://www.percona.com/blog/when-should-i-use-amazon-aurora-and-when-should-i-use-rds-mysql/#comments Sat, 01 Jul 2023 13:46:47 +0000 https://www.percona.com/blog/?p=51069 This post was originally published in July 2018 and was updated in July 2023.Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL?  What are the differences between Aurora and RDS? How […]]]> https://www.percona.com/blog/when-should-i-use-amazon-aurora-and-when-should-i-use-rds-mysql/feed/ 15 51069 https://www.percona.com/blog/which-cloud-provider-performs-better-for-my-mysql-workload/ Mon, 30 Mar 2020 15:48:00 +0000 https://www.percona.com/blog/?p=65934 More and more people are nowadays thinking of cloud migration. The question of “Which cloud provider performs better for my MySQL workload?” is really common but cannot always be easily answered. However, there are ways to come up with an answer. This question also applies when thinking of moving to any provider, not necessarily a […]]]> 65934 https://www.percona.com/blog/how-securing-mysql-with-tcp-wrappers-can-cause-an-outage/ https://www.percona.com/blog/how-securing-mysql-with-tcp-wrappers-can-cause-an-outage/#comments Tue, 07 Jan 2020 17:05:08 +0000 https://www.percona.com/blog/?p=63980 The CaseSecuring MySQL is always a challenge. There are general best practices that can be followed for securing your installation, but the more complex setup you have the more likely you are to face some issues which can be difficult to troubleshoot.We’ve recently been working on a case (thanks Alok Pathak and Janos Ruszo for […]]]> https://www.percona.com/blog/how-securing-mysql-with-tcp-wrappers-can-cause-an-outage/feed/ 4 63980 https://www.percona.com/blog/the-multi-source-gtid-replication-maze/ Tue, 13 Mar 2018 17:56:23 +0000 https://www.percona.com/blog/?p=47749 In this blog post, we’ll look at how to navigate some of the complexities of multi-source GTID replication.GTID replication is often a real challenge for DBAs, especially if this has to do with multi-source GTID replication. A while back, I came across a really interesting customer environment with shards where multi-master, multi-source, multi-threaded MySQL 5.6 MIXED […]]]> 47749 https://www.percona.com/blog/proxysql-query-cache/ https://www.percona.com/blog/proxysql-query-cache/#comments Wed, 07 Feb 2018 18:40:05 +0000 https://www.percona.com/blog/?p=47075 In this blog post, I’ll present the ProxySQL query cache functionality. This is a query caching mechanism on top of ProxySQL. As there are already many how-tos regarding the ProxySQL prerequisites and installation process, we are going to skip these steps. For those who are already familiar with ProxySQL query cache configuration, let’s go directly […]]]> https://www.percona.com/blog/proxysql-query-cache/feed/ 11 47075