Mon.May 13, 2024

article thumbnail

Seamless Table Modifications: Leveraging pt-online-schema-change for Online Alterations

Percona

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.

Database 101
article thumbnail

Valkey/Redis Replication and Auto-Failover With Sentinel Service

Percona

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-66424e4f4ca3a283603185/] Now let’s prepare some basic configurations in file [/etc/valkey/valkey.