Introduction

Percona XtraDB Cluster is a high-availability and high-scalability solution for MySQL databases. It provides synchronous replication and automated failover. This guide will walk you through the installation of Percona XtraDB Cluster on Debian 11, which can be effectively utilized on a Windows VPS UK for reliable performance and management.

Prerequisites

• A Debian 11 server with root access
• Basic knowledge of Linux commands
• At least 2 servers for a proper cluster setup (one for testing)

Step 1: Update Your System

Begin by updating your package index and upgrading any existing packages:

sudo apt update && sudo apt upgrade -y

Step 2: Install Required Dependencies

Install necessary dependencies for Percona:

sudo apt install software-properties-common -y

Step 3: Add the Percona Repository

Add the Percona repository to your system:

sudo wget https://repo.percona.com/apt/percona-release_latest.generic_all.deb
sudo dpkg -i percona-release_latest.generic_all.deb
sudo percona-release enable-ponce release

Step 4: Install Percona XtraDB Cluster

Now, install Percona XtraDB Cluster using the following command:

sudo apt update
sudo apt install percona-xtradb-cluster-8.0 -y

Step 5: Configure Percona XtraDB Cluster

Edit the configuration file:

sudo nano /etc/mysql/my.cnf

Make the following changes to set up the cluster:

[mysqld]
binlog_format=ROW
default-storage-engine=InnoDB
innodb_flush_log_at_trx_commit=1
innodb_xa_support=ON

# Galera settings
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_name=my_cluster
wsrep_cluster_address=gcomm://node1_ip,node2_ip,node3_ip
wsrep_node_address=node1_ip
wsrep_node_name=node1_name
wsrep_sst_method=rsync

Replace node1_ip, node2_ip, and node3_ip with the IP addresses of your nodes, and adjust node1_name accordingly.

Step 6: Start the Cluster

To start the cluster, you need to first start one node with the following command:

sudo systemctl start mysql@bootstrap

For the rest of the nodes, start them normally:

sudo systemctl start mysql

Step 7: Verify the Cluster Status

Log into the MySQL shell to check the cluster status:

mysql -u root -p

Run the following command to check the cluster nodes:

SHOW STATUS LIKE 'wsrep_cluster_size';

This should return the number of nodes in your cluster.

Step 8: Configure Firewall

Ensure that the necessary ports for the cluster are open:

sudo ufw allow 3306/tcp
sudo ufw allow 9200/tcp
sudo ufw allow 4567/tcp
sudo ufw allow 6443/tcp
sudo ufw reload

Step 9: Conclusion

You have successfully installed Percona XtraDB Cluster on Debian 11, providing a robust solution for high availability and scalability. This setup is especially beneficial when utilizing a Windows VPS. For further options, explore various VPS UK Windows solutions, including Windows Virtual Private Server Hosting and Windows VPS Hosting UK for optimal performance.