Anil Joshi, Author at Percona Database Performance Blog Mon, 13 May 2024 15:34:21 +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 Anil Joshi, Author at Percona Database Performance Blog 32 32 76301791 Valkey/Redis Replication and Auto-Failover With Sentinel Service 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-664c6e83e2b58225436228/] 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 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/ 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 Copying Alert Rules From One Percona Monitoring and Management Server to Another https://www.percona.com/blog/copying-alert-rules-from-one-percona-monitoring-and-management-server-to-another/ https://www.percona.com/blog/copying-alert-rules-from-one-percona-monitoring-and-management-server-to-another/#respond Tue, 26 Mar 2024 16:08:19 +0000 https://www.percona.com/blog/?p=95341 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 Postgres backend.Sometimes we need to migrate only alert rules from one PMM server to another for some […]]]> https://www.percona.com/blog/copying-alert-rules-from-one-percona-monitoring-and-management-server-to-another/feed/ 0 95341 Using Percona Backup for MongoDB in Replica Set and Sharding Environments: Part Two https://www.percona.com/blog/using-percona-backup-for-mongodb-in-replica-set-and-sharding-environment-part-two/ https://www.percona.com/blog/using-percona-backup-for-mongodb-in-replica-set-and-sharding-environment-part-two/#respond Wed, 13 Mar 2024 13:47:39 +0000 https://www.percona.com/blog/?p=95062 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 options available with PBM.Let’s discuss each one.Taking backups on remote storage (AWS S3/Google […]]]> https://www.percona.com/blog/using-percona-backup-for-mongodb-in-replica-set-and-sharding-environment-part-two/feed/ 0 95062 Using Percona Backup for MongoDB in Replica Set and Sharding Environments: Part One https://www.percona.com/blog/using-percona-backup-for-mongodb-in-replica-set-and-sharding-environment-part-one/ https://www.percona.com/blog/using-percona-backup-for-mongodb-in-replica-set-and-sharding-environment-part-one/#respond Wed, 21 Feb 2024 16:57:45 +0000 https://www.percona.com/blog/?p=94746 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 providing various layers of backups such as physical, logical, incremental, PITR, etc.In this blog […]]]> https://www.percona.com/blog/using-percona-backup-for-mongodb-in-replica-set-and-sharding-environment-part-one/feed/ 0 94746 Setting Up Percona Monitoring and Management Alerts for External Channels (Telegram, Slack, WebHook) https://www.percona.com/blog/setting-up-percona-monitoring-and-management-alerts-for-external-channels-telegram-slack-webhook/ https://www.percona.com/blog/setting-up-percona-monitoring-and-management-alerts-for-external-channels-telegram-slack-webhook/#respond Tue, 19 Dec 2023 14:20:22 +0000 https://www.percona.com/blog/?p=92538 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, and WebHook.Please note that I am not covering the basic alerting and configuration setup. For that, you […]]]> https://www.percona.com/blog/setting-up-percona-monitoring-and-management-alerts-for-external-channels-telegram-slack-webhook/feed/ 0 92538 How to Filter or Customize Alert Notifications in Percona Monitoring and Management (Subject and Body) https://www.percona.com/blog/how-to-filter-or-customize-alert-notifications-in-percona-monitoring-and-management-subject-and-body/ https://www.percona.com/blog/how-to-filter-or-customize-alert-notifications-in-percona-monitoring-and-management-subject-and-body/#respond Thu, 07 Dec 2023 15:31:19 +0000 https://www.percona.com/blog/?p=92233 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 “Subject” and “Body”, cluttering your inbox with information that may not be immediately relevant. The focus today is on tailoring […]]]> https://www.percona.com/blog/how-to-filter-or-customize-alert-notifications-in-percona-monitoring-and-management-subject-and-body/feed/ 0 92233 Failover and Recovery Scenarios in InnoDB Cluster and ClusterSet https://www.percona.com/blog/failover-and-recovery-scenarios-in-innodb-cluster-and-clusterset/ https://www.percona.com/blog/failover-and-recovery-scenarios-in-innodb-cluster-and-clusterset/#comments Fri, 25 Aug 2023 12:21:20 +0000 https://www.percona.com/blog/?p=90195 This blog post will focus on failover and recovery scenarios inside the InnoDB Cluster and ClusterSet environment. To know more about the deployments of these topologies, you can refer to the manuals – InnoDB Cluster and Innodb ClusterSet setup.In the below snippet, we have two clusters (cluster1 and cluster2), which are connected via an async […]]]> https://www.percona.com/blog/failover-and-recovery-scenarios-in-innodb-cluster-and-clusterset/feed/ 1 90195 InnoDB ClusterSet Deployment With MySQLRouter https://www.percona.com/blog/innodb-clusterset-deployment-with-mysqlrouter/ https://www.percona.com/blog/innodb-clusterset-deployment-with-mysqlrouter/#respond Thu, 17 Aug 2023 14:29:22 +0000 https://www.percona.com/blog/?p=89647 This blog post will cover the basic setup of the InnoDB ClusterSet environment, which provides disaster tolerance for InnoDB Cluster deployments by associating a primary InnoDB Cluster with one or more replicas in alternate locations/different data centers. InnoDB ClusterSet automatically manages replication from the primary cluster to the replica clusters via a specific ClusterSet Async replication […]]]> https://www.percona.com/blog/innodb-clusterset-deployment-with-mysqlrouter/feed/ 0 89647 How To Use pt-secure-collect for Capturing Data in a Secure Way From the OS and Database System https://www.percona.com/blog/how-to-use-pt-secure-collect-for-capturing-data-in-a-secure-way-from-the-os-and-database-system/ https://www.percona.com/blog/how-to-use-pt-secure-collect-for-capturing-data-in-a-secure-way-from-the-os-and-database-system/#respond Tue, 02 May 2023 13:36:46 +0000 https://www.percona.com/blog/?p=87471 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 third-party team troubleshoot database-related issues.In this context, pt-secure-collect is a very important utility from Percona, which helps capture the required […]]]> https://www.percona.com/blog/how-to-use-pt-secure-collect-for-capturing-data-in-a-secure-way-from-the-os-and-database-system/feed/ 0 87471 Using Liquibase as a Solution for Deploying and Tracking MySQL Schema Changes https://www.percona.com/blog/using-liquibase-as-a-solution-for-deploying-and-tracking-mysql-schema-changes/ https://www.percona.com/blog/using-liquibase-as-a-solution-for-deploying-and-tracking-mysql-schema-changes/#respond Fri, 02 Dec 2022 14:58:00 +0000 https://www.percona.com/blog/?p=83911 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 applied in the database domain as well, assuming SQL as a code to manage […]]]> https://www.percona.com/blog/using-liquibase-as-a-solution-for-deploying-and-tracking-mysql-schema-changes/feed/ 0 83911 Exploring Data Dump and Load Utility With MySQL Shell https://www.percona.com/blog/exploring-data-dump-and-load-utility-with-mysql-shell/ https://www.percona.com/blog/exploring-data-dump-and-load-utility-with-mysql-shell/#respond Fri, 25 Nov 2022 13:13:33 +0000 https://www.percona.com/blog/?p=83622 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 JavaScript and Python. It provides an AdminAPI to manage […]]]> https://www.percona.com/blog/exploring-data-dump-and-load-utility-with-mysql-shell/feed/ 0 83622