Nov 01, 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 information, robust backup and recovery strategies are the pillars on which the stability of applications […]
Oct 02, 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 of a search condition is FALSE for […]
Apr 02, 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 “ProxySQL Firewalling” using the mysql_query_rules table. […]
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 the following list of hostnames and IPs for references:
|
+-----------+----------------+ | node_name | ip | +-----------+----------------+ | pxc1 | 192.168.88.134 | | pxc2 | 192.168.88.125 | | pxc3 | 192.168.88.132 | +-----------+----------------+ |
My current […]
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 SSD drive to compile and […]
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 to all nodes, and this can make it difficult to find the most […]
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 more, then this post is for you. If this […]
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 default Raspbian OS includes very few versions of MySQL to install […]
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, let’s review two common methods to installing ProxySQL. ProxySQL as a centralized server This is the […]