https://www.percona.com/blog/ Mon, 20 May 2024 15:48:34 +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 https://www.percona.com/blog/ 32 32 76301791 https://www.percona.com/blog/new-valkey-packages-by-percona/ https://www.percona.com/blog/new-valkey-packages-by-percona/#respond Mon, 20 May 2024 15:48:34 +0000 https://www.percona.com/blog/?p=96358 Valkey 7.2.5 has been officially released as the first General Availability (GA) version, a significant milestone for the project. It is now available in multiple formats: as an official Docker container, through Fedora/EPEL yum repositories, and as binary tarballs for both Ubuntu Bionic and Ubuntu Focal. This availability ensures straightforward installation on rpm-based systems, though […]]]> https://www.percona.com/blog/new-valkey-packages-by-percona/feed/ 0 96358 https://www.percona.com/blog/can-we-set-up-a-replicate-filter-within-the-percona-xtradb-cluster/ https://www.percona.com/blog/can-we-set-up-a-replicate-filter-within-the-percona-xtradb-cluster/#respond Mon, 20 May 2024 13:06:30 +0000 https://www.percona.com/blog/?p=96350 If you were to ask me the question, “Would it be possible to set up a replicate filter within the Percona XtraDB Cluster?” my immediate response would be to question you right back. Why would you even want the cluster nodes to have different data when you’re using a synchronous replication cluster? That’s because, instinctively, […]]]> https://www.percona.com/blog/can-we-set-up-a-replicate-filter-within-the-percona-xtradb-cluster/feed/ 0 96350 https://www.percona.com/blog/valkey-redis-not-so-good-practices/ https://www.percona.com/blog/valkey-redis-not-so-good-practices/#respond Thu, 16 May 2024 15:26:13 +0000 https://www.percona.com/blog/?p=96325 As we’ve been introducing Valkey/Redis these past few weeks, let’s depart from the norm and talk about a few “things you should not do” in Valkey.No passwordBy default, Valkey/Redis uses no authentication. This means anyone can connect to your Valkey server and start writing and reading data. Worst yet, no password while binding to all […]]]> https://www.percona.com/blog/valkey-redis-not-so-good-practices/feed/ 0 96325 https://www.percona.com/blog/choosing-the-right-database-comparing-mariadb-vs-mysql-postgresql-and-mongodb/ https://www.percona.com/blog/choosing-the-right-database-comparing-mariadb-vs-mysql-postgresql-and-mongodb/#respond Thu, 16 May 2024 12:46:12 +0000 https://www.percona.com/blog/?p=96342 Selecting the appropriate database technology for your needs is crucial for ensuring compatibility with existing applications and infrastructure, optimizing application performance, and reducing costs. With so many different choices available, it can be difficult to make such a decision!This blog post provides a head-to-head comparison of MariaDB vs. PostgreSQL, MongoDB, and MySQL, highlighting their similarities […]]]> https://www.percona.com/blog/choosing-the-right-database-comparing-mariadb-vs-mysql-postgresql-and-mongodb/feed/ 0 96342 https://www.percona.com/blog/valkey-redis-configuration-best-practices/ https://www.percona.com/blog/valkey-redis-configuration-best-practices/#respond Wed, 15 May 2024 13:05:27 +0000 https://www.percona.com/blog/?p=96276 In a few of our previous blog posts, we’ve seen how to get started with Valkey/Redis by running a simple docker container and how to persist some configuration settings to disk. In this post, let’s take a step back and go over a few configuration best practices.ConnectionsThe Valkey/Redis config file is typically located at /etc/valkey/valkey.conf, but […]]]> https://www.percona.com/blog/valkey-redis-configuration-best-practices/feed/ 0 96276 https://www.percona.com/blog/valkey-redis-the-hash-datatype/ https://www.percona.com/blog/valkey-redis-the-hash-datatype/#respond Tue, 14 May 2024 13:21:54 +0000 https://www.percona.com/blog/?p=96278 In our previous blogs, we discussed the basic data types available in Valkey/Redis: Strings, Lists, Sets, and Sorted Sets. In this blog, we introduce a more complex data type, Hashes.You can think of these much like dictionaries from Python, associative arrays from PHP, etc. Normally in Valkey/Redis, you store one value associated with one key. […]]]> https://www.percona.com/blog/valkey-redis-the-hash-datatype/feed/ 0 96278 https://www.percona.com/blog/valkey-redis-replication-and-auto-failover-with-sentinel-service/ https://www.percona.com/blog/valkey-redis-replication-and-auto-failover-with-sentinel-service/#respond Mon, 13 May 2024 15:34:21 +0000 https://www.percona.com/blog/?p=96240 In this Valkey blog post, I will demonstrate how we can set up a simple replication process among the Valkey nodes and then finally use some auto-failover mechanism with the help of the Valkey-sentinel tool.Replication (Master-Slave)Basically, we have two setups with the information below. [crayon-664bad0f2c4fe789291333/] Now let’s prepare some basic configurations in file [/etc/valkey/valkey.conf] for […]]]> https://www.percona.com/blog/valkey-redis-replication-and-auto-failover-with-sentinel-service/feed/ 0 96240 https://www.percona.com/blog/seamless-table-modifications-leveraging-pt-online-schema-change-for-online-alterations/ https://www.percona.com/blog/seamless-table-modifications-leveraging-pt-online-schema-change-for-online-alterations/#respond Mon, 13 May 2024 13:19:30 +0000 https://www.percona.com/blog/?p=96293 Table modifications are a routine task for database administrators. The blog post Using Percona Toolkit to Alter Database Tables Online: A Controlled Approach provides insights into the process of altering tables online in a controlled manner, ensuring uninterrupted access for application users and preventing application downtime. We will focus here on utilizing the powerful “pt-online-schema-change” […]]]> https://www.percona.com/blog/seamless-table-modifications-leveraging-pt-online-schema-change-for-online-alterations/feed/ 0 96293 https://www.percona.com/blog/valkey-redis-sets-and-sorted-sets/ https://www.percona.com/blog/valkey-redis-sets-and-sorted-sets/#respond Thu, 09 May 2024 15:09:10 +0000 https://www.percona.com/blog/?p=96208 In our previous post, we welcomed Valkey (an open source fork of Redis) to the Percona family. We also learned how to get Valkey up and running using docker, along with understanding some of the basic data types, string and list. In this post, we will continue working with Valkey/Redis and learn about sets and […]]]> https://www.percona.com/blog/valkey-redis-sets-and-sorted-sets/feed/ 0 96208 https://www.percona.com/blog/mysql-database-security-best-practices/ https://www.percona.com/blog/mysql-database-security-best-practices/#respond Thu, 09 May 2024 13:02:54 +0000 https://www.percona.com/blog/?p=96285 Have you ever read a news story about a major company experiencing a data breach that exposed millions of customer records? These breaches can be devastating, causing significant financial losses, reputational damage, and even legal repercussions. Unfortunately, MySQL databases, one of the most popular relational database management systems, is at the heart of many critical […]]]> https://www.percona.com/blog/mysql-database-security-best-practices/feed/ 0 96285 https://www.percona.com/blog/troubleshooting-postgresql-on-kubernetes-with-coroot/ https://www.percona.com/blog/troubleshooting-postgresql-on-kubernetes-with-coroot/#respond Wed, 08 May 2024 18:11:31 +0000 https://www.percona.com/blog/?p=96112 Coroot, an open source observability tool powered by eBPF, went generally available with version 1.0 last week. As this tool is cloud-native, we were curious to know how it can help troubleshoot databases on Kubernetes.In this blog post, we will see how to quickly debug PostgreSQL with Coroot and Percona Operator for PostgreSQL.PrepareInstall CorootThe easiest […]]]> https://www.percona.com/blog/troubleshooting-postgresql-on-kubernetes-with-coroot/feed/ 0 96112 https://www.percona.com/blog/mastering-database-monitoring-running-pmm-in-high-availability-mode/ https://www.percona.com/blog/mastering-database-monitoring-running-pmm-in-high-availability-mode/#respond Wed, 08 May 2024 13:25:22 +0000 https://www.percona.com/blog/?p=92932 Percona Monitoring and Management (PMM) has become a valuable tool for database professionals, providing comprehensive insights into database health and performance. A recent update (version 2.41.0) introduced a significant enhancement: the ability to run PMM in high availability (HA) mode. This feature, currently in technical preview, offers exciting possibilities for ensuring the reliability and robustness […]]]> https://www.percona.com/blog/mastering-database-monitoring-running-pmm-in-high-availability-mode/feed/ 0 92932 https://www.percona.com/blog/speed-up-repetitive-postgresql-statements-with-gexec/ https://www.percona.com/blog/speed-up-repetitive-postgresql-statements-with-gexec/#respond Tue, 07 May 2024 16:15:05 +0000 https://www.percona.com/blog/?p=96166 Last week, we were assisting a client who needed to resolve an issue related to partitioned tables.Often, a table can include dozens or even hundreds of partitions. Unfortunately, some object-level parameters for tuning (like storage_parameter) cannot be modified from the parent table and must be manipulated directly through the child table. As a result, we […]]]> https://www.percona.com/blog/speed-up-repetitive-postgresql-statements-with-gexec/feed/ 0 96166 https://www.percona.com/blog/hello-valkey-lets-get-started/ https://www.percona.com/blog/hello-valkey-lets-get-started/#respond Tue, 07 May 2024 13:17:59 +0000 https://www.percona.com/blog/?p=96199 Welcome Valkey to the Percona family! We are excited to have you join our team of MySQL, PostgreSQL, and MongoDB database experts.Hang on. What is Valkey? In short, Valkey is a fork of Redis which maintains the original open source BSD license[1]. If you’re new to Redis/Valkey, then this ‘getting started’ post is just for […]]]> https://www.percona.com/blog/hello-valkey-lets-get-started/feed/ 0 96199 https://www.percona.com/blog/valkey-redis-configurations-and-persistent-setting-of-the-key-parameters/ https://www.percona.com/blog/valkey-redis-configurations-and-persistent-setting-of-the-key-parameters/#respond Mon, 06 May 2024 18:18:20 +0000 https://www.percona.com/blog/?p=96136 Since Valkey (a fork of Redis) is around the corner, I thought to write a short blog post about some of the configuration parts, mainly discussing how to dynamically change certain settings and persist those inside the configuration file.Disk persistenceLet me start with a very important setting, which is “SAVE,” that helps in performing a […]]]> https://www.percona.com/blog/valkey-redis-configurations-and-persistent-setting-of-the-key-parameters/feed/ 0 96136 https://www.percona.com/blog/securing-your-mongodb-database-essential-best-practices/ https://www.percona.com/blog/securing-your-mongodb-database-essential-best-practices/#respond Mon, 06 May 2024 13:17:22 +0000 https://www.percona.com/blog/?p=96153 MongoDB offers powerful features and scalability, but like any database system, it has security challenges that must be addressed to protect sensitive data as well as comply with regulatory standards like GDPR, HIPAA, PCI DSS, and AM/ATF. A single breach can significantly impact a business, and failure to establish sufficient security measures can result in […]]]> https://www.percona.com/blog/securing-your-mongodb-database-essential-best-practices/feed/ 0 96153 https://www.percona.com/blog/mysql-8-4-first-peek/ https://www.percona.com/blog/mysql-8-4-first-peek/#respond Wed, 01 May 2024 13:13:29 +0000 https://www.percona.com/blog/?p=96106 MySQL 8.4 has now been officially released, and this is a quick review of what is in the release notes. This is momentous as it is designated a Long-Term Support (LTS) release. Various 8.0 releases introduced material changes that impacted speed and stability, causing hair-pulling and swearing among those affected. Please note this is a […]]]> https://www.percona.com/blog/mysql-8-4-first-peek/feed/ 0 96106 https://www.percona.com/blog/ldap-authentication-in-pgbouncer-through-pam/ https://www.percona.com/blog/ldap-authentication-in-pgbouncer-through-pam/#respond Tue, 30 Apr 2024 14:46:30 +0000 https://www.percona.com/blog/?p=96054 There are many cases where external connection poolers like pgBouncer become unavoidable despite the costs and complexities associated with them. PgBouncer is one of the most popular external connection poolers for PostgreSQL. It is thin and lightweight, so it doesn’t have built-in authentication features like LDAP, which is essential for many enterprises. Luckily, pgBouncer has […]]]> https://www.percona.com/blog/ldap-authentication-in-pgbouncer-through-pam/feed/ 0 96054 https://www.percona.com/blog/redis-valkey-and-perconas-ongoing-support-of-open-source/ https://www.percona.com/blog/redis-valkey-and-perconas-ongoing-support-of-open-source/#comments Tue, 30 Apr 2024 13:29:31 +0000 https://www.percona.com/blog/?p=96087 For me, the Redis story starts with…  Memcached.   Back in the early 2000s, “Web 2.0” was being built following the aftermath of the dot-com crash.  The open source  LAMP (Linux-Apache-MySQL-PHP/Perl/Python) stack was all the rage.  We needed to scale fast but also very efficiently, and caching became one of the core technologies to achieve […]]]> https://www.percona.com/blog/redis-valkey-and-perconas-ongoing-support-of-open-source/feed/ 1 96087 https://www.percona.com/blog/trying-out-the-postgresql-pg_tde-tech-preview-release/ https://www.percona.com/blog/trying-out-the-postgresql-pg_tde-tech-preview-release/#respond Fri, 26 Apr 2024 15:54:53 +0000 https://www.percona.com/blog/?p=96020 The tech preview version of the pg_tde extension for PostgreSQL 16 was released on March 28th, with many improvements compared to our previous MVP release. In addition to lots of bug fixes, the new release supports multi-tenancy and key rotation with a simplified configuration mechanism. Note that the Tech Preview release is not recommended for […]]]> https://www.percona.com/blog/trying-out-the-postgresql-pg_tde-tech-preview-release/feed/ 0 96020