How to install and enable the Database Cluster Recovery add-on?

AccuWeb.Cloud provides a robust and reliable environment for hosting databases and supporting MySQL-based databases (MySQL/MariaDB/Percona) and PostgreSQL and Redis. To enhance the resilience of your database infrastructure, AccuWeb.Cloud provides a robust solution with its Database Cluster Recovery add-on and offering users the ability to safeguard their data and quickly recover from potential disruptions. In this article, we’ll walk you through the process of installing and enabling the Database Cluster Recovery add-on AccuWeb.Cloud.

This add on proves invaluable in ensuring the health and stability of your databases. Presently, the Database Cluster Recovery add-on extends its support to the following database clusters:

• Primary Secondary Cluster (MySQL/MariaDB/Percona): This cluster configuration ensures a primary secondary relationship and enhancing high availability and fault tolerance.
• Primary Cluster (MySQL/MariaDB/Percona): For those seeking load balancing and redundancy, the primary primary cluster configuration is a go-to solution.
• Galera Cluster (MariaDB): MariaDB stack and the Galera Cluster offers synchronous multi master replication and real time data consistency.
• XtraDB Cluster (Percona): Percona stack and the XtraDB Cluster provide a high performance solution with enhanced data integrity.
• Add On Specifics: Database Cluster Recovery Diagnostic and Recovery Modes

The Database Cluster Recovery add-on offers two modes of operation: diagnostic and recovery. Each mode serves a specific purpose in ensuring the health and stability of your database clusters.

Diagnostic Mode

In the diagnostic mode and the ad, it conducts a comprehensive scan of the database and aims to identify any potential issues that may impact its performance. The primary goal is to gather information about the state of the database for further analysis. The following checks are performed during the diagnostic phase:

• Replication Check: For Primary Secondary and Primary Primary topologies the add-on examines the replication status to ensure data consistency and integrity.
• Cluster Size Check: In the case of Galera and XtraDB clusters verifies the size of the cluster to maintain optimal performance.
• Clusters Status Check: The health and status of Galera and XtraDB clusters are assessed to identify any potential issues.
• Cluster Services Status: The diagnostic process includes checking the status of cluster services and ensuring that they are operational and functioning correctly.

Recovery Mode

Upon completion of the diagnostic phase the add-on and in recovery mode and takes proactive steps to resolve identified issues and restore the database to a stable state. The recovery operations involve the following adjustments to the database cluster:

Replica User Addition

A dedicated replica user is added to the cluster during installation. This user plays a crucial role in the validation of the clusters and is utilized in the configuration of ProxySQL. Open Variables of SQL database to check Replica User and password.

Credentials for Replica User

REPLICA_USER: repl xxxxxx

REPLICA_PSWD: xxxxxxxxxxxx

SSH Access Configuration

To facilitate data copying during the restoration procedure SSH access is configured between the database nodes. This involves a dedicated set of SSH keys and ensuring secure and efficient data transfer using rsync.

Database Cluster Recovery Add-On Installation Steps

You have two convenient options – through the platform Marketplace or by importing the package directly from GitHub. Follow these steps for a seamless installation process:

Database Cluster Recovery Add On Installation via Platform Marketplace:

Step 1. Log in to your AccuWeb.Cloud account and navigate to the platform Marketplace.

Step 2. Locate the Database Cluster Recovery add-on.

Step 3. Click on the install button under add-on to initiate the installation.

Step 4. In the confirmation window provide the necessary data:

• User and Password: Your database admin user credentials.
• Environment name: Select the environment with the desired database cluster from the available list.
• Nodes: Choose a layer containing the database cluster.

Step 5. Click “Install” and patiently wait for a few minutes as the add-on is being installed.

Step 6. Once installed you can find the Database Cluster Recovery add-on in the list of add-ons associated with the relevant layer.

Database Cluster Recovery Add-On Installation steps via GitHub

Step 1. Log in to the AccuWeb.Cloud Dashboard and click on “Import.”

Step 2. Import the Database Cluster Recovery package from GitHub by adding this URL.

https://github.com/jelastic-jps/mysql-cluster/blob/master/addons/recovery/manifest.yml

Step 3. Follow the same confirmation window steps as mentioned above.

Steps to utilize the add-on’s functionalities

Database Cluster Recovery adds it is a straightforward process and offers two essential actions that can be executed effortlessly through the platform interface.

1. Cluster Diagnostic

This action serves as a health check for your database cluster. Click the “Cluster Diagnostic” button to initiate the diagnostic process. The add on will scan if nodes are accessible and check for consistency within databases. The result of the diagnostic action will be reflected in one of two possible dashboard notifications:

“Cluster is OK” or “Errors discovered.”

2. Cluster Recovery

If issues are detected during the diagnostic the Cluster Recovery action becomes crucial. Click the “Cluster Recovery” button to attempt automatic resolution of common problems. The action is designed to restore full operability to the database cluster.

For a more in-depth understanding of the installation process click the “Show Logs” button. This will open the /var/log/db_recovery.log file and provide detailed logs.

Conclusion

Following these steps, you can seamlessly integrate the Database Cluster Recovery add-on into your database management routine. Whether ensuring the health of your cluster through diagnostics or swiftly addressing issues with the recovery action the add provides valuable tools for maintaining the stability and performance of your database environment.