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 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/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-664c6c9407bd6183788569/] 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/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/performance-implications-of-running-databases-in-kubernetes/ https://www.percona.com/blog/performance-implications-of-running-databases-in-kubernetes/#respond Fri, 26 Apr 2024 12:46:44 +0000 https://www.percona.com/blog/?p=96016 Cloud-native databases are becoming the norm, and containerized databases are a common trend (see the report from Dynatrace and Figure 1). Kubernetes—the de facto standard for platform engineers—and operators simplify database deployment and management. But what are the performance implications of running databases in Kubernetes? To answer this question, we compared the performance of Percona Server for […]]]> https://www.percona.com/blog/performance-implications-of-running-databases-in-kubernetes/feed/ 0 96016 https://www.percona.com/blog/why-mariadb-is-better-than-mysql/ https://www.percona.com/blog/why-mariadb-is-better-than-mysql/#respond Tue, 23 Apr 2024 15:36:53 +0000 https://www.percona.com/blog/?p=95980 Apples or oranges?Tea or coffee?Books or eBooks?Each of these comparisons has very similar features and serves many of the same purposes, but in the end, they are different choices people make. Do you know what else belongs on this list?MariaDB or MySQL?It’s time we discuss the age-old debate of MariaDB versus MySQL and see if […]]]> https://www.percona.com/blog/why-mariadb-is-better-than-mysql/feed/ 0 95980 https://www.percona.com/blog/did-mydumper-like-triggers/ https://www.percona.com/blog/did-mydumper-like-triggers/#respond Fri, 19 Apr 2024 13:46:56 +0000 https://www.percona.com/blog/?p=95924 Yes, but now it likes them more, and here is why.IntroUsing the LIKE clause to filter triggers or views from a specific table is common. However, it can play a trick on you, especially if you don’t get to see the output (i.e., in a non-interactive session). Let’s take a look at a simple example […]]]> https://www.percona.com/blog/did-mydumper-like-triggers/feed/ 0 95924 https://www.percona.com/blog/should-you-deploy-your-databases-on-kubernetes-and-what-makes-statefulset-worthwhile/ https://www.percona.com/blog/should-you-deploy-your-databases-on-kubernetes-and-what-makes-statefulset-worthwhile/#respond Thu, 18 Apr 2024 15:21:54 +0000 https://www.percona.com/blog/?p=95948 Why do cloud-native databases matter?Kubernetes makes it easier to run applications. It’s like having a magic wand for managing everything from small tasks to significant operations. However, despite the popularity of Kubernetes, there are many cases when it might not be the best solution for your database needs.Kubernetes wasn’t built with the needs of databases […]]]> https://www.percona.com/blog/should-you-deploy-your-databases-on-kubernetes-and-what-makes-statefulset-worthwhile/feed/ 0 95948