Thu, 11 Apr 2024 22:41:58 +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-8-2-0-community-vs-enterprise-is-there-a-winner/ https://www.percona.com/blog/mysql-8-2-0-community-vs-enterprise-is-there-a-winner/#respond Tue, 06 Feb 2024 18:13:33 +0000 https://www.percona.com/blog/?p=94111 To be honest, the comparison between the two MySQL distributions is not something that excited me a lot. Mainly because from my MySQL memories, I knew that there is not a real difference between the two distributions when talking about the code base.To my knowledge the differences in the enterprise version are in the additional […]]]> https://www.percona.com/blog/mysql-8-2-0-community-vs-enterprise-is-there-a-winner/feed/ 0 94111 https://www.percona.com/blog/is-mysql-router-8-2-any-better/ https://www.percona.com/blog/is-mysql-router-8-2-any-better/#comments Thu, 11 Jan 2024 14:16:35 +0000 https://www.percona.com/blog/?p=93350 In my previous article, Comparisons of Proxies for MySQL, I showed how MySQL Router was the lesser performing Proxy in the comparison. From that time to now, we had several MySQL releases and, of course, also some new MySQL Router ones.Most importantly, we also had MySQL Router going back to being a level 7 proxy […]]]> https://www.percona.com/blog/is-mysql-router-8-2-any-better/feed/ 4 93350 https://www.percona.com/blog/poc-horizontal-write-scaling-for-mysql-with-kubernetes-operator/ https://www.percona.com/blog/poc-horizontal-write-scaling-for-mysql-with-kubernetes-operator/#comments Mon, 15 May 2023 11:12:34 +0000 https://www.percona.com/blog/?p=87689 Historically MySQL is great in horizontal READ scale. The scaling, in that case, is offered by the different number of Replica nodes, no matter if using standard asynchronous replication or synchronous replication.However, those solutions do not offer the same level of scaling for writes operation.Why? Because the solutions still rely on writing in one single […]]]> https://www.percona.com/blog/poc-horizontal-write-scaling-for-mysql-with-kubernetes-operator/feed/ 2 87689 https://www.percona.com/blog/comparisons-of-proxies-for-mysql/ https://www.percona.com/blog/comparisons-of-proxies-for-mysql/#respond Mon, 20 Mar 2023 15:05:21 +0000 https://www.percona.com/blog/?p=86204 With a special focus on Percona Operator for MySQLOverviewHAProxy, ProxySQL, MySQL Router (AKA MySQL Proxy); in the last few years, I had to answer multiple times on what proxy to use and in what scenario. When designing an architecture, many components need to be considered before deciding on the best solution.When deciding what to pick, […]]]> https://www.percona.com/blog/comparisons-of-proxies-for-mysql/feed/ 0 86204 https://www.percona.com/blog/out-of-disk-space-mysql/ https://www.percona.com/blog/out-of-disk-space-mysql/#respond Fri, 20 Jan 2023 13:17:43 +0000 https://www.percona.com/blog/?p=84742 How can we fix a nasty out-of-space issue leveraging the flexibility of Percona Operator for MySQL?When planning a database deployment, one of the most challenging factors to consider is the amount of space we need to dedicate to data on disk.This is even more cumbersome when working on bare metal, as it is more difficult […]]]> https://www.percona.com/blog/out-of-disk-space-mysql/feed/ 0 84742 https://www.percona.com/blog/mysql-dual-passwords-how-to-manage-them-programmatically/ https://www.percona.com/blog/mysql-dual-passwords-how-to-manage-them-programmatically/#respond Wed, 23 Nov 2022 13:02:35 +0000 https://www.percona.com/blog/?p=83684 What is dual password in MYSQL and how it works was already covered by my colleague Brian Sumpter in Using MySQL 8 Dual Passwords.However, let me do a brief recap here about it.Dual password is the MySQL mechanism that allows you to keep two passwords active at the same time. This feature is part of […]]]> https://www.percona.com/blog/mysql-dual-passwords-how-to-manage-them-programmatically/feed/ 0 83684 https://www.percona.com/blog/proxysql-support-for-mysql-caching_sha2_password/ https://www.percona.com/blog/proxysql-support-for-mysql-caching_sha2_password/#respond Thu, 10 Nov 2022 13:06:23 +0000 https://www.percona.com/blog/?p=83469 Every day we use dozens if not hundreds of applications connecting to some kind of data repository. This simple step is normally executed over the network and, given so, it is subject to possible sniffing with all the possible related consequences.Given that, it is normally better to protect your connection using data encryption like SSL, or […]]]> https://www.percona.com/blog/proxysql-support-for-mysql-caching_sha2_password/feed/ 0 83469 https://www.percona.com/blog/zero-impact-on-index-creation-with-amazon-aurora-3/ https://www.percona.com/blog/zero-impact-on-index-creation-with-amazon-aurora-3/#comments Fri, 22 Apr 2022 12:15:48 +0000 https://www.percona.com/blog/?p=80824 In the last quarter of 2021, AWS released Aurora version 3. This new version aligns Aurora with the latest MySQL 8 version, porting many of the advantages MySQL 8 has over previous versions.While this brings a lot of new interesting features for Aurora, what we are going to cover here is to see how DDLs […]]]> https://www.percona.com/blog/zero-impact-on-index-creation-with-amazon-aurora-3/feed/ 2 80824 https://www.percona.com/blog/face-to-face-with-semi-synchronous-replication/ https://www.percona.com/blog/face-to-face-with-semi-synchronous-replication/#comments Tue, 12 Apr 2022 12:22:38 +0000 https://www.percona.com/blog/?p=80649 Last month I performed a review of the Percona Operator for MySQL Server which is still Alpha.  That operator is based on Percona Server for MySQL and uses standard asynchronous replication, with the option to activate semi-synchronous replication to gain higher levels of data consistency between nodes. The whole solution is composed as:Additionally, Orchestrator (https://github.com/openark/orchestrator) is […]]]> https://www.percona.com/blog/face-to-face-with-semi-synchronous-replication/feed/ 2 80649 https://www.percona.com/blog/online-ddl-with-group-replication-in-mysql-8-0-27/ https://www.percona.com/blog/online-ddl-with-group-replication-in-mysql-8-0-27/#comments Tue, 11 Jan 2022 13:25:34 +0000 https://www.percona.com/blog/?p=79682 In April 2021, I wrote an article about Online DDL and Group Replication. At that time we were dealing with MySQL 8.0.23 and also opened a bug report which did not have the right answer to the case presented. Anyhow, in that article I have shown how an online DDL was de facto locking the whole […]]]> https://www.percona.com/blog/online-ddl-with-group-replication-in-mysql-8-0-27/feed/ 1 79682 https://www.percona.com/blog/percona-xtradb-cluster-non-blocking-operation-for-online-schema-upgrade/ https://www.percona.com/blog/percona-xtradb-cluster-non-blocking-operation-for-online-schema-upgrade/#comments Thu, 09 Dec 2021 14:32:19 +0000 https://www.percona.com/blog/?p=79231 Percona XtraDB Cluster 8.0.25 (PXC) has introduced a new option to perform online schema modifications: NBO (Non-Blocking Operation).When using PXC, the cluster relies on the wsrep_OSU_method parameter to define the Online Schema Upgrade (OSU) method the node uses to replicate DDL statements.  Until now, we normally have three options: Use Total Isolation Order (TOI, the […]]]> https://www.percona.com/blog/percona-xtradb-cluster-non-blocking-operation-for-online-schema-upgrade/feed/ 2 79231 https://www.percona.com/blog/what-if-mysqls-repeatable-reads-cause-you-to-lose-money/ https://www.percona.com/blog/what-if-mysqls-repeatable-reads-cause-you-to-lose-money/#comments Tue, 09 Nov 2021 14:23:11 +0000 https://www.percona.com/blog/?p=78887 Well, let me say if that happens it’s because there is a logic mistake in your application. But you need to know and understand what happens in MySQL to be able to avoid the problem. In short, the WHY of this article is to inform you about possible pitfalls and how to prevent them from causing […]]]> https://www.percona.com/blog/what-if-mysqls-repeatable-reads-cause-you-to-lose-money/feed/ 2 78887 https://www.percona.com/blog/boosting-percona-distribution-for-mysql-operator-efficiency/ https://www.percona.com/blog/boosting-percona-distribution-for-mysql-operator-efficiency/#respond Wed, 23 Jun 2021 15:25:54 +0000 https://www.percona.com/blog/?p=76888 Percona is well known for its offer of several outstanding fully open source, free-to-download software packages. And while Percona started as a MySQL-focused company, nowadays it covers different technologies such as MySQL, PostgreSQL, and MongoDB.In its constant effort to make life easier for our users, Percona had moved from providing single software packages to Percona […]]]> https://www.percona.com/blog/boosting-percona-distribution-for-mysql-operator-efficiency/feed/ 0 76888 https://www.percona.com/blog/mysql-static-and-dynamic-privileges-part-2/ https://www.percona.com/blog/mysql-static-and-dynamic-privileges-part-2/#respond Tue, 15 Jun 2021 15:59:04 +0000 https://www.percona.com/blog/?p=76698 When organizing things helps to simplify life.In the previous article, we start to explore dynamic privileges and the interaction with static ones. We also saw how to remove SUPER privilege from a DBA account. What we did was go by subtraction. But in real life, we should act differently. We should ADD only what is really […]]]> https://www.percona.com/blog/mysql-static-and-dynamic-privileges-part-2/feed/ 0 76698 https://www.percona.com/blog/mysql-static-and-dynamic-privileges-part-1/ https://www.percona.com/blog/mysql-static-and-dynamic-privileges-part-1/#comments Tue, 15 Jun 2021 14:00:06 +0000 https://www.percona.com/blog/?p=76691 When trying to make things better, make it very complicated.I was working on a Security Threat Tool script when I had to learn more about the interaction between static and dynamic privileges in MySQL 8.Dynamic privileges is a “new” thing added in MySQL 8 to easily extend the privileges definition, and at the same time […]]]> https://www.percona.com/blog/mysql-static-and-dynamic-privileges-part-1/feed/ 2 76691 https://www.percona.com/blog/inconsistent-voting-in-percona-xtradb-cluster/ Tue, 04 May 2021 18:36:33 +0000 https://www.percona.com/blog/?p=75880 AKA Cluster Error Voting…What is Cluster Error Voting (CEV)?“Cluster Error Voting is a new feature implemented by Alexey Yurchenko, and it is a protocol for nodes to decide how the cluster will react to problems in replication. When one or several nodes have an issue applying an incoming transaction(s) (e.g., suspected inconsistency), this new feature […]]]> 75880 https://www.percona.com/blog/online-ddl-with-group-replication-in-percona-server-for-mysql-8-0-22/ https://www.percona.com/blog/online-ddl-with-group-replication-in-percona-server-for-mysql-8-0-22/#comments Thu, 15 Apr 2021 16:06:20 +0000 https://www.percona.com/blog/?p=75486 While I was working on my grFailOver POC, I have also done some additional parallel testing. One of them was to see how online DDL is executed inside a Group Replication cluster.The online DDL feature provides support for instant and in-place table alterations and concurrent DML. Checking the Group Replication (GR) official documentation, I was […]]]> https://www.percona.com/blog/online-ddl-with-group-replication-in-percona-server-for-mysql-8-0-22/feed/ 7 75486 https://www.percona.com/blog/what-you-can-do-with-auto-failover-and-percona-distribution-for-mysql-8-0-x/ https://www.percona.com/blog/what-you-can-do-with-auto-failover-and-percona-distribution-for-mysql-8-0-x/#comments Wed, 14 Apr 2021 14:37:50 +0000 https://www.percona.com/blog/?p=75382 Where x is >= 22 😉The ProblemThere are few things your data does not like. One is water and another is fire. Well, guess what:If you think that everything will be fine after all, take a look: Given my ISP had part of its management infrastructure on OVH, they had been impacted by the incident.As […]]]> https://www.percona.com/blog/what-you-can-do-with-auto-failover-and-percona-distribution-for-mysql-8-0-x/feed/ 2 75382 https://www.percona.com/blog/percona-distribution-for-mysql-high-availability-with-group-replication-solution/ https://www.percona.com/blog/percona-distribution-for-mysql-high-availability-with-group-replication-solution/#comments Wed, 14 Apr 2021 13:06:21 +0000 https://www.percona.com/blog/?p=75363 This blog provides high availability (HA) guidelines using group replication architecture and deployment recommendations in MySQL, based on our best practices.Every architecture and deployment depends on the customer requirements and application demands for high availability and the estimated level of usage. For example, using high read or high write applications, or both, with a need […]]]> https://www.percona.com/blog/percona-distribution-for-mysql-high-availability-with-group-replication-solution/feed/ 6 75363 https://www.percona.com/blog/mysql-8-0-23-is-available-highlighting-some-important-points/ https://www.percona.com/blog/mysql-8-0-23-is-available-highlighting-some-important-points/#comments Wed, 20 Jan 2021 14:20:19 +0000 https://www.percona.com/blog/?p=73964 As many of you have seen already, MySQL 8.0.23 is available for download (release notes).Today our dear LeFred thanked all the numerous contributors to bug fixes.  About this: let me mention our two people involved in bug fixing, Venkatesh Prasad Venugopal and Kamil Hołubicki. Great work guys!On my side, I have reviewed the release note […]]]> https://www.percona.com/blog/mysql-8-0-23-is-available-highlighting-some-important-points/feed/ 5 73964