by Marco Tusa | Jan 11, 2021 | Cloud, MySQL, Percona Software, ProxySQL
The aim of Percona Operator for MySQL based on Percona XtraDB Cluster is to be a special type of controller introduced to simplify complex deployments. The Operator extends the Kubernetes API with custom resources. The Operator solution is using Percona XtraDB Cluster... by Marco Tusa | Jan 11, 2021 | Cloud, MySQL, Percona Software, ProxySQL
Percona Operator for MySQL based on Percona XtraDB Cluster comes with two different proxies, HAProxy and ProxySQL. While the initial version was based on ProxySQL, in time, Percona opted to set HAProxy as the default Proxy for the operator, without removing... by Marco Tusa | Nov 30, 2020 | MySQL, Open Source, Percona Software, ProxySQL
How scheduler and script stand in supporting failover (Percona and Marco example) In part one of this series, I had illustrated how simple scenarios may fail or have problems when using Galera native support inside ProxySQL. In this post, I will repeat the... by Marco Tusa | Nov 30, 2020 | MySQL, Open Source, Percona Software, ProxySQL
How native ProxySQL stands in failover support (both v2.0.15 and v2.1.0)In recent times I have been designing several solutions focused on High Availability and Disaster Recovery. Some of them using Percona Server for MySQL with group replication, some using Percona... by Marco Tusa | Oct 9, 2020 | Benchmarks, Cloud, MySQL, ProxySQL
For what reason should I use a real multi-primary setup?To be clear, not a multi-writer solution where any node can become the active writer in case of needs, as for Percona XtraDB Cluster (PXC) or Percona Server for MySQL using Group_replication. No, we are talking... by Marco Tusa | Aug 3, 2020 | Insight for DBAs, Insight for Developers, MySQL
A small thing that provides a huge help.The other day I was writing some code to process a very large amount of items coming from a social media API. My items were ending in a queue in MySQL and then needed to be processed and eventually moved.The task was not so... by Marco Tusa | Jul 7, 2020 | Insight for DBAs, MySQL
Why another article on this, Marco? MySQL deadlocks is a topic covered many times, including here at Percona. I suggest you review the reference section at the end of this post for articles on how to identify deadlocks and from where they are generated.So why another... by Marco Tusa | Jul 1, 2020 | MySQL, Percona Software, ProxySQL
In real life, there are frequent cases where getting a running application to work correctly is strongly dependent on consistent write/read operations. This is no issue when using a single data node as a provider, but it becomes more concerning and challenging when... by Marco Tusa | May 18, 2020 | MySQL, Percona Software
Percona has enforced stronger security in Percona XtraDB Cluster (PXC) 8, but this requires some attention during the rollout of the new server version, so let see the why and what.In PXC there are two different kinds of traffic: client-server exchange (ie:... by Marco Tusa | Mar 26, 2020 | Benchmarks, MySQL, Open Source
What You May Not Know About Random Number Generation in Sysbench Sysbench is a well known and largely used tool to perform benchmarking. Originally written by Peter Zaitsev in early 2000, it has become a de facto standard when performing testing and benchmarking.... by Marco Tusa | Jan 10, 2020 | MySQL, Percona Software
In the many years we have used MySQL, we got accustomed to the fact that upgrades from MySQL 5.7.11 to 5.7.12 was a minor event. This meant that if something was going wrong, we could roll back the binaries and be happy again. From MySQL 8, this is no longer... by Marco Tusa | Aug 13, 2019 | Insight for DBAs, MySQL
by Marco Tusa | Feb 20, 2019 | MySQL, Percona Software, ProxySQL
ProxySQL in its versions up to 1.x did not natively support Percona XtraDB Cluster (PXC). Instead, it relied on the flexibility offered by the scheduler. This approach allowed users to implement their own preferred way to manage the ProxySQL behaviour in relation to... by Marco Tusa | Dec 7, 2018 | Insight for DBAs, MySQL
by Marco Tusa | Nov 15, 2018 | Insight for DBAs, MySQL
Let’s talk about MySQL high availability (HA) and synchronous replication once more.It’s part of a longer series on some high availability reference architecture solutions over geographically distributed areas.Part 1: Reference Architecture(s) for... by Marco Tusa | Nov 15, 2018 | Insight for DBAs, MySQL
In this article, we’ll look at an example of an on-premises, geographically distributed MySQL high availability solution. It’s part of a longer series on some high availability reference architecture solutions over geographically distributed... by Marco Tusa | Nov 15, 2018 | Insight for DBAs, MySQL, PostgreSQL
In this series of blog posts, I’m going to look at some high availability reference architecture solutions over geographically distributed areas. The Problem Nowadays, when businesses plan a new service or application, it is very common for them to worry about... by Marco Tusa | Aug 27, 2018 | Insight for DBAs, MySQL
MySQL Resource Groups, introduced in MySQL 8, provide the ability to manipulate the assignment of running threads to specific resources, thereby allowing the DBA to manage application priorities. Essentially, you can assign a thread to a specific virtual CPU. In this... by Marco Tusa | Jun 12, 2018 | MySQL, Percona Software, Security
Let them stay together.In the last YEARS, I have seen quite often that users, when installing a product such as PXC, instead of spending five minutes to understand what to do just run iptables -F and save.In short, they remove any rules for their firewall.With... by Marco Tusa | Apr 3, 2018 | Cloud, MySQL, ProxySQL
In this blog post, I’ll look at how you can use ProxySQL with AWS Aurora to further leverage database performance. My previous article described how easy is to replace the native Aurora connector with ProxySQL. In this article, you will see WHY you should...