by Anil Joshi | May 13, 2024 | Insight for DBAs, Insight for Developers, Open Source
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... by Anil Joshi | May 6, 2024 | Database Trends, Hardware and Storage, Insight for DBAs, Insight for Developers
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 persistence Let me start... by Anil Joshi | Mar 26, 2024 | Cloud, Insight for DBAs, Monitoring, Percona Software
Since Percona Monitoring and Management (PMM) 2.40.0, Grafana uses PostgreSQL instead of SQLite database to store users, dashboards, and other persistent data. This aids in getting some useful information related to [configured alerts] directly via querying from the... by Anil Joshi | Mar 13, 2024 | Insight for DBAs, MongoDB, Percona Software
In Using Percona Backup for MongoDB in Replica Set and Sharding Environment: Part One, I demonstrated a basic Percona Backup for MongoDB (PBM) setup under the Replica Set and Sharding environment. Now, here we will see some advanced stuff and other backup/restore... by Anil Joshi | Feb 21, 2024 | Insight for DBAs, MongoDB, Percona Software
Backups are crucial for every database system, and having a reliable, fast, and hot backup is the demand for next-generation database systems. Percona Backup for MongoDB (PBM) is a backup management tool that enhances the existing backup capability of MongoDB by... by Anil Joshi | Dec 19, 2023 | Insight for DBAs, Monitoring, Percona Software
Setting up Percona Monitoring and Management (PMM) alerts for multiple channels can significantly enhance your monitoring strategy. In this blog post, we will talk about the steps to configure alerts for some well-known communication platforms like Telegram, Slack,... by Anil Joshi | Dec 7, 2023 | Insight for DBAs, Monitoring, Percona Software
In many scenarios, the standard alert notification template in Percona Monitoring and Management (PMM), while comprehensive, may not align perfectly with specific operational needs. This often leads to an excess of details in the notification’s... by Anil Joshi | May 2, 2023 | Insight for DBAs, MySQL, Percona Software, Security
Sometimes crucial data sharing is avoided because of compliance rules, organizational policies, or numerous security concerns. The common use cases involve sharing pt-mysql-summary, pt-stalk, and other OS-related details to assist Support Engineers or any other... by Anil Joshi | Dec 2, 2022 | Database Trends, Insight for Developers, MySQL, Open Source
Database-as-code service is a new concept and gaining some popularity in recent years. As we already know, we have deployment solutions for application code. Managing and tracking application changes are quite easy with tools like Git and Jenkins.Now this concept is... by Anil Joshi | Nov 25, 2022 | Cloud, Insight for DBAs, MySQL
In this blog post, I will try to cover a few dump and data-loading utilities offered by MySQL Shell. What is MySQL Shell? It is a robust client and code editor for MySQL. In addition to having APIs for dealing with MySQL, MySQL Shell offers scripting capabilities for...