Restoring a Backup Stored in S3 to an EC2 Instance Using XtraBackup

Restoring backups is a critical task for database administrators to ensure data consistency and disaster recovery. This guide provides a step-by-step process to restore a database backup stored in an Amazon S3 bucket to a new EC2 instance using Percona XtraBackup. Continue reading “Restoring a Backup Stored in S3 to an EC2 Instance Using XtraBackup”

Setup Percona Postgresql Through the Awsesome(OSM) Ansible Role

Percona is known for its software solutions for most Databases. It gives a single solution with the best and most critical enterprise components from the open-source community.

In terms of monitoring, it provides Percona Monitoring and Management (PMM) tool which is a best-of-breed monitoring solution. It helps you reduce complexity, optimise performance, and improve the security of your business-critical database environments.

Percona is a well-known solution for MySQL databases, including monitoring and performance tools that help manage and gain insight into open source database environments. It also provides an XtraBackup tool for MySQL which ease the problem of incremental backup of DB efficiently.

Continue reading “Setup Percona Postgresql Through the Awsesome(OSM) Ansible Role”