Percona Database Performance Blog
3,932 FOLLOWERS
MySQL performance tips from Percona data performance experts. Learn to build and maintain high-performing MySQL, NoSQL, MongoDB, big data, cloud deployments.
Percona Database Performance Blog
13h ago
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 ..read more
Percona Database Performance Blog
13h ago
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 ..read more
Percona Database Performance Blog
13h ago
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 ..read more
Percona Database Performance Blog
3d ago
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 ..read more
Percona Database Performance Blog
3d ago
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 ..read more
Percona Database Performance Blog
4d ago
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 ..read more
Percona Database Performance Blog
4d ago
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 ..read more
Percona Database Performance Blog
1w ago
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 ..read more
Percona Database Performance Blog
1w ago
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 ..read more
Percona Database Performance Blog
1w ago
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 ..read more