by Walter Garcia | Nov 1, 2023 | Insight for DBAs, MySQL, Open Source, Percona Software
This blog was originally published in January 2021 and updated in November of 2023.As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. In this age of digital... by Walter Garcia | Oct 2, 2020 | Insight for DBAs, Insight for Developers, MySQL
Hello everyone, in this little post we will review a new feature in MySQL 8. What is “CHECK Constraint”? This is a new feature to specify a condition to check the value before INSERT or UPDATE into a row. The constraint could return an error if the result... by Walter Garcia | Apr 2, 2020 | MySQL, ProxySQL, Security
In this blog, we will test a new security feature added in ProxySQL 2.0.9. Since a time ago, we have had the ability to block queries using mysql_query_rules table matching a group of queries using reg exp like a blacklist. Check out a previous blog for how to config... by Walter Garcia | Jan 10, 2020 | MySQL, Percona Software, ProxySQL
If you are thinking of using ProxySQL in our Percona XtraDB Cluster environment, I’ll explain how to use ProxySQL 2 for failover tasks. How to Test ProxySQL uses the “weight” column to define who is the WRITER node. For this example, I’ll use... by Walter Garcia | Sep 26, 2019 | Insight for DBAs, MySQL, Percona Software
In a previous post, I showed you how to compile Percona Mysql 5.7 on Raspberry PI 3. Now, I’ll show you how to compile and run the latest version of Percona XtraDB Cluster 5.7.26.We will need at least 3 RaspberryPi 3 boards, and I recommend you use an external... by Walter Garcia | Aug 14, 2019 | ProxySQL
In this post, we will manage ProxySQL Cluster with “core” and “satellite” nodes. What does that mean? Well, in hundreds of nodes, only one change in one of those nodes will replicate to the entire cluster.Any mistake or changes will replicate... by Walter Garcia | Apr 10, 2019 | MySQL, ProxySQL
In my previous post, some time ago, I wrote about the new cluster feature of ProxySQL. For that post, we were working with three nodes, now we’ll work with even more! If you’ve installed one ProxySQL per application instance and would like to work up to... by Walter Garcia | Aug 22, 2018 | MySQL, Percona Software
In this post I’ll give to you the steps to compile Percona Server for MySQL 5.7.22 in Raspberry Pi 3. Why? Well because in general this little computer is cheap, has low power consumption, and is great to use as a test machine for developers.By... by Walter Garcia | Jun 11, 2018 | MySQL, ProxySQL
ProxySQL 1.4.2 introduced native clustering, allowing several ProxySQL instances to communicate with and share configuration updates with each other. In this blog post, I’ll review this new feature and how we can start working with 3 nodes.Before I continue,...