{"id":3070,"date":"2025-07-31T23:35:14","date_gmt":"2023-07-26T04:20:20","guid":{"rendered":""},"modified":"2025-02-02T00:46:19","modified_gmt":"2025-02-01T23:46:19","slug":"how-to-install-percona-xtradb-cluster-on-debian-11","status":"publish","type":"post","link":"https:\/\/netcloud24.com\/knowledgebase\/how-to-install-percona-xtradb-cluster-on-debian-11\/","title":{"rendered":"Linux VPS &#038; VPS Windows Setup Guide | NetCloud24 Percona XtraDB Cluster on Debian 11"},"content":{"rendered":"<p>\u00a0<\/p>\n<\/p>\n<header>\n<h1>\u00a0<\/h1>\n<\/header>\n<article>\n<section>\n<h2>Introduction<\/h2>\n<p>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 <a href=\"https:\/\/ie.netcloud24.com\">Windows VPS <\/a> for reliable performance and management.<\/p>\n<\/section>\n<section>\n<h2>Prerequisites<\/h2>\n<ul>\n<li>A Debian 11 server with root access<\/li>\n<li>Basic knowledge of Linux commands<\/li>\n<li>At least 2 servers for a proper cluster setup (one for testing)<\/li>\n<\/ul>\n<\/section>\n<section>\n<h2>Step 1: Update Your System<\/h2>\n<p>Begin by updating your package index and upgrading any existing packages:<\/p>\n<pre><code>sudo apt update &amp;&amp; sudo apt upgrade -y<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 2: Install Required Dependencies<\/h2>\n<p>Install necessary dependencies for Percona:<\/p>\n<pre><code>sudo apt install software-properties-common -y<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 3: Add the Percona Repository<\/h2>\n<p>Add the Percona repository to your system:<\/p>\n<pre><code>sudo wget https:\/\/repo.percona.com\/apt\/percona-release_latest.generic_all.deb\r\nsudo dpkg -i percona-release_latest.generic_all.deb\r\nsudo percona-release enable-ponce release<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 4: Install Percona XtraDB Cluster<\/h2>\n<p>Now, install Percona XtraDB Cluster using the following command:<\/p>\n<pre><code>sudo apt update\r\nsudo apt install percona-xtradb-cluster-8.0 -y<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 5: Configure Percona XtraDB Cluster<\/h2>\n<p>Edit the configuration file:<\/p>\n<pre><code>sudo nano \/etc\/mysql\/my.cnf<\/code><\/pre>\n<p>Make the following changes to set up the cluster:<\/p>\n<pre><code>[mysqld]\r\nbinlog_format=ROW\r\ndefault-storage-engine=InnoDB\r\ninnodb_flush_log_at_trx_commit=1\r\ninnodb_xa_support=ON\r\n\r\n# Galera settings\r\nwsrep_provider=\/usr\/lib\/galera\/libgalera_smm.so\r\nwsrep_cluster_name=my_cluster\r\nwsrep_cluster_address=gcomm:\/\/node1_ip,node2_ip,node3_ip\r\nwsrep_node_address=node1_ip\r\nwsrep_node_name=node1_name\r\nwsrep_sst_method=rsync<\/code><\/pre>\n<p>Replace <code>node1_ip<\/code>, <code>node2_ip<\/code>, and <code>node3_ip<\/code> with the IP addresses of your nodes, and adjust <code>node1_name<\/code> accordingly.<\/p>\n<\/section>\n<section>\n<h2>Step 6: Start the Cluster<\/h2>\n<p>To start the cluster, you need to first start one node with the following command:<\/p>\n<pre><code>sudo systemctl start mysql@bootstrap<\/code><\/pre>\n<p>For the rest of the nodes, start them normally:<\/p>\n<pre><code>sudo systemctl start mysql<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 7: Verify the Cluster Status<\/h2>\n<p>Log into the MySQL shell to check the cluster status:<\/p>\n<pre><code>mysql -u root -p<\/code><\/pre>\n<p>Run the following command to check the cluster nodes:<\/p>\n<pre><code>SHOW STATUS LIKE 'wsrep_cluster_size';<\/code><\/pre>\n<p>This should return the number of nodes in your cluster.<\/p>\n<\/section>\n<section>\n<h2>Step 8: Configure Firewall<\/h2>\n<p>Ensure that the necessary ports for the cluster are open:<\/p>\n<pre><code>sudo ufw allow 3306\/tcp\r\nsudo ufw allow 9200\/tcp\r\nsudo ufw allow 4567\/tcp\r\nsudo ufw allow 6443\/tcp\r\nsudo ufw reload<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 9: Conclusion<\/h2>\n<p>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 . For further options, explore various  solutions, including <a href=\"https:\/\/ie.netcloud24.com\">Windows VPSVirtual Private Server Hosting<\/a> and <a href=\"https:\/\/ie.netcloud24.com\">Windows VPS Hosting UK<\/a> for optimal performance.<\/p>\n<\/section>\n<\/article>\n<footer>\n<p>\u00a9 2024 Percona XtraDB Cluster Installation Tutorial. All rights reserved.<\/p>\n<\/footer>\n<div class=\"post-author-box\" style=\"border-top:1px solid #ddd;margin-top:20px;padding-top:15px;\">\n<p><strong>Author:<\/strong> \u0141ukasz Bodziony<\/p>\n<p><strong>Website:<\/strong> <a href=\"https:\/\/ca.netcloud24.com\" target=\"_blank\" rel=\"dofollow\">Windows VPS<\/a><\/p>\n<p><em>\u0141ukasz Bodziony is the CEO and founder of <a href=\"https:\/\/netcloud24.com\" target=\"_blank\" rel=\"dofollow\">NETCLOUD24<\/a>, a global VPS hosting brand proudly originating from Poland. With extensive experience in cloud computing, virtualization, and server management, he delivers high-performance <strong>Windows VPS<\/strong> and <strong>Remote Desktop Services (RDS)<\/strong> solutions to clients across Europe, North America, and beyond.<\/em><\/p>\n<p><em>His expertise covers a wide range of technologies, including <strong>Microsoft Azure<\/strong>, <strong>Proxmox VE<\/strong>, <strong>Amazon Web Services (AWS)<\/strong>, and numerous other virtualization and cloud platforms.<\/em><\/p>\n<p><em>Beyond running his hosting business, \u0141ukasz also provides <strong>professional paid server configuration and optimization services<\/strong> for companies and individuals. Outside of work, he is dedicated to caring for his children and building a secure future for them.<\/em><\/p>\n<p><em>If you are interested in working with him or need expert assistance with your hosting, cloud environment, or server setup, feel free to reach out via <a href=\"https:\/\/ca.netcloud24.com\" target=\"_blank\" rel=\"dofollow\">Windows VPS<\/a>.<\/em><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 \u00a0 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\u2026<\/p>\n","protected":false},"author":1,"featured_media":3421,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[],"tags":[14,12,11,23,20,21,22,17,7,8,6,10,18,19,15,24,16,5,13,9],"class_list":["post-3070","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","tag-cheapvps","tag-cloudvps","tag-hostingvps","tag-rds","tag-rdscal","tag-remotedesktop","tag-remotedesktopvps","tag-servervps","tag-ukvps","tag-virtualserver","tag-vpshosting","tag-vpsserver","tag-vpssolutions","tag-vpswindows","tag-vpswithwindows","tag-windowsrds","tag-windowsserver","tag-windowsvps","tag-windowsvpshosting","tag-windowsvpsuk"],"jetpack_publicize_connections":[],"_links":{"self":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/3070","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/comments?post=3070"}],"version-history":[{"count":0,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/3070\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/media\/3421"}],"wp:attachment":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/media?parent=3070"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/categories?post=3070"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/tags?post=3070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}