Sat, 17 Feb 2024 01:14:50 +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-backup-and-recovery-best-practices/ https://www.percona.com/blog/mysql-backup-and-recovery-best-practices/#respond Wed, 01 Nov 2023 08:00:43 +0000 https://www.percona.com/blog/?p=73015 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 stands. […]]]> https://www.percona.com/blog/mysql-backup-and-recovery-best-practices/feed/ 0 73015 https://www.percona.com/blog/how-to-use-check-constraint-in-mysql-8/ Fri, 02 Oct 2020 18:23:09 +0000 https://www.percona.com/blog/?p=70993 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 any row […]]]> 70993 https://www.percona.com/blog/proxysql-2-0-9-introduces-firewall-whitelist-capabilities/ Thu, 02 Apr 2020 16:18:24 +0000 https://www.percona.com/blog/?p=66021 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.You […]]]> 66021 https://www.percona.com/blog/how-to-use-proxysql-2-on-percona-xtradb-for-failover/ https://www.percona.com/blog/how-to-use-proxysql-2-on-percona-xtradb-for-failover/#comments Fri, 10 Jan 2020 15:18:16 +0000 https://www.percona.com/blog/?p=63794 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 TestProxySQL 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: [crayon-664c9bb60cc81018610595/] My current WRITER node […]]]> https://www.percona.com/blog/how-to-use-proxysql-2-on-percona-xtradb-for-failover/feed/ 1 63794 https://www.percona.com/blog/running-percona-xtradb-cluster-on-raspberry-pi-3/ https://www.percona.com/blog/running-percona-xtradb-cluster-on-raspberry-pi-3/#comments Thu, 26 Sep 2019 17:38:10 +0000 https://www.percona.com/blog/?p=53262 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 use […]]]> https://www.percona.com/blog/running-percona-xtradb-cluster-on-raspberry-pi-3/feed/ 2 53262 https://www.percona.com/blog/how-to-manage-proxysql-cluster-with-core-and-satellite-nodes/ https://www.percona.com/blog/how-to-manage-proxysql-cluster-with-core-and-satellite-nodes/#comments Wed, 14 Aug 2019 14:45:36 +0000 https://www.percona.com/blog/?p=57889 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 recently […]]]> https://www.percona.com/blog/how-to-manage-proxysql-cluster-with-core-and-satellite-nodes/feed/ 2 57889 https://www.percona.com/blog/how-to-add-more-nodes-to-an-existing-proxysql-cluster/ Wed, 10 Apr 2019 11:52:16 +0000 https://www.percona.com/blog/?p=56096 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 […]]]> 56096 https://www.percona.com/blog/how-to-compile-percona-server-for-mysql-5-7-in-raspberry-pi-3/ https://www.percona.com/blog/how-to-compile-percona-server-for-mysql-5-7-in-raspberry-pi-3/#comments Wed, 22 Aug 2018 15:04:49 +0000 https://www.percona.com/blog/?p=50076 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 [crayon-664c9bb60f32f738782022/] […]]]> https://www.percona.com/blog/how-to-compile-percona-server-for-mysql-5-7-in-raspberry-pi-3/feed/ 1 50076 https://www.percona.com/blog/proxysql-experimental-feature-native-clustering/ https://www.percona.com/blog/proxysql-experimental-feature-native-clustering/#comments Mon, 11 Jun 2018 12:18:24 +0000 https://www.percona.com/blog/?p=50048 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 serverThis is the most common installation, […]]]> https://www.percona.com/blog/proxysql-experimental-feature-native-clustering/feed/ 3 50048