Percona's MySQL & InnoDB performance and scalability blog
91k followers 6 artikelen/week
Valkey/Redis: Not-So-Good Practices

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 […]

Thu May 16, 2024 18:46
Choosing the Right Database: Comparing MariaDB vs. MySQL, PostgreSQL, and MongoDB

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....

Thu May 16, 2024 15:47
Valkey/Redis: Configuration Best Practices

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,...

Wed May 15, 2024 16:13
Valkey/Redis: The Hash Datatype

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. […]

Tue May 14, 2024 16:34
Valkey/Redis Replication and Auto-Failover With Sentinel Service

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-66436580d9f07598196095/] Now let’s prepare some basic...

Mon May 13, 2024 18:54
Seamless Table Modifications: Leveraging pt-online-schema-change for Online Alterations

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...

Mon May 13, 2024 16:27

Bouw uw eigen nieuws-stroom

Klaar om het te proberen?
Start een 14-daagse proef, geen credit card nodig.

Account aanmaken