{"id":397,"date":"2015-02-17T07:14:00","date_gmt":"2015-02-17T07:14:00","guid":{"rendered":"https:\/\/opstree.com\/blog\/\/2015\/02\/17\/getting-started-with-percona-xtradb-cluster\/"},"modified":"2019-09-18T14:23:25","modified_gmt":"2019-09-18T08:53:25","slug":"getting-started-with-percona-xtradb-cluster","status":"publish","type":"post","link":"https:\/\/opstree.com\/blog\/2015\/02\/17\/getting-started-with-percona-xtradb-cluster\/","title":{"rendered":"Getting Started with Percona XtraDB Cluster"},"content":{"rendered":"
\n
\n
\n
\n
\n

Percona XtraDB Cluster<\/span><\/h2>\n
As a DevOps activist I am exploring Percona XtraDB. In a series of blogs I will share my learnings. This blog intends to capture step by step details of installation of Percona XtraDB in Cluster mode.\u00a0<\/div>\n
\u00a0<\/div>\n

Why Cluster Mode Introduction:<\/span><\/p>\n

Percona XtraDB cluster is High Availability and Scalability solution for MySQL users which provides
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Synchronous replication : Transaction either committed on all nodes \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 or none.
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Multi-master replication : You can write to any node.
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Parallel applying events on slave : parallel event application on all slave \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 nodes
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Automatic node provisioning
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Data consistency
Straight into the Act:<\/span>Installing Percona XtraDB Cluster <\/span><\/p>\n

Pre-requisites\/Assumptions<\/div>\n
\n
    \n
  1. OS – Ububtu<\/li>\n
  2. 3 Ubuntu nodes are available<\/li>\n<\/ol>\n
    For the sake of this discussion lets name the nodes as<\/div>\n<\/div>\n
    node 1<\/span>
    hostname:<\/span> percona_xtradb_cluster1
    IP:<\/span> 192.168<\/span>.1<\/span>.2<\/span>

    node 2<\/span>
    hostname:<\/span> percona_xtradb_cluster2
    IP:<\/span> 192.168<\/span>.1<\/span>.3<\/span>

    node 3<\/span>
    hostname:<\/span> percona_xtradb_cluster3
    IP:<\/span> 192.168<\/span>.1<\/span>.4<\/span><\/code><\/pre>\n
    Repeat the below steps on all nodes<\/p>\n
    STEP 1 :<\/b> Add the Percona repository<\/p>\n
    $ echo \"deb http:\/\/repo.percona.com\/apt precise main\" >> \/etc\/apt\/sources.list.d\/percona.list
    $ echo \"deb-src http:\/\/repo.percona.com\/apt precise main\" >> \/etc\/apt\/sources.list.d\/percona.list
    $ apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
    <\/code><\/pre>\n<\/div>\n
    STEP 2 :<\/b> After adding percona repository, Update apt cache so that new packages can be included in our apt-cache.<\/pre>\n
    $ apt-get update
    <\/code><\/pre>\n
    STEP 3 :<\/b> Install Percona XtraDB Cluster :<\/p>\n
    $ apt-get install -y percona-xtradb-cluster-56 qpress xtrabackup<\/code><\/code><\/pre>\n
    STEP 4 :<\/b> Install\u00a0additional package for editing files, downloading etc\u00a0:<\/code><\/p>\n
    <\/code>$ apt-get install -y python-software-properties vim wget curl netcat<\/code><\/pre>\n
    With the above steps we have, installed Percona XtraDB Cluster on every node. Now we’ll configure each node, so that a cluster of three nodes can be formed.<\/span><\/p>\n
    Node Configuration:<\/span><\/span><\/p>\n
    Add\/Modify file \/etc\/mysql\/my.cnf on first node : <\/b><\/p>\n
    [MYSQLD] #This section is for mysql configuration
    user = mysql                                                   
    default_storage_engine = InnoDB                  
    basedir = \/usr
    datadir = \/var\/lib\/mysql
    socket = \/var\/run\/mysqld\/mysqld.sock
    port = 3306
    innodb_autoinc_lock_mode = 2
    log_queries_not_using_indexes = 1
    max_allowed_packet = 128M
    binlog_format = ROW
    wsrep_provider = \/usr\/lib\/libgalera_smm.so
    wsrep_node_address = 192.168.1.2
    wsrep_cluster_name=\"newcluster\"
    wsrep_cluster_address = gcomm:\/\/192.168.1.2,192.168.1.3,192.168.1.4
    wsrep_node_name = cluster1
    wsrep_slave_threads = 4
    wsrep_sst_method = xtrabackup-v2
    wsrep_sst_auth = sst:secret

    [sst] #This section is for sst(state snapshot transfer) configuration 
    streamfmt = xbstream

    [xtrabackup] #This section is defines tuning configuration for xtrabackup
    compress
    compact
    parallel = 2
    compress_threads = 2
    rebuild_threads = 2
    <\/code><\/pre>\n
    Note :<\/b>
    \u00a0 \u00a0 \u00a0 \u00a0 \u00a0wsrep_node_address = {IP of current node}
    \u00a0 \u00a0 \u00a0 \u00a0 \u00a0wsrep_cluster_name= {Name of cluster}
    \u00a0 \u00a0 \u00a0 \u00a0 \u00a0wsrep_cluster_address = gcomm:\/\/{Comma separated IP address\u2019s which are in cluster}
    \u00a0 \u00a0 \u00a0 \u00a0 \u00a0wsrep_node_name = {This is name of current node which is used to identify it in cluster}<\/p>\n
    Now as we have done node configuration. Now start first node services:
    Start the node :<\/p>\n
    <\/code>$ service mysql bootstrap-pxc<\/code>
    <\/code><\/pre>\n
    Make sst user<\/code> for authentication of cluster nodes :<\/p>\n
    $ mysql -e<\/span> \"GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'sst'<\/span>@'localhost'<\/span> IDENTIFIED BY 'secret'<\/span>;\"<\/code>
    <\/code><\/code><\/code><\/pre>\n
    Check cluster status :<\/p>\n
    $ mysql -e \"show global status like 'wsrep%';\"
    <\/code><\/pre>\n
    Configuration file for second node:<\/b><\/p>\n<\/div>\n
    [MYSQLD]
    user = mysql
    default_storage_engine = InnoDB
    basedir = \/usr
    datadir = \/var\/lib\/mysql
    socket = \/var\/run\/mysqld\/mysqld.sock
    port = 3306
    innodb_autoinc_lock_mode = 2
    log_queries_not_using_indexes = 1
    max_allowed_packet = 128M
    binlog_format = ROW
    wsrep_provider = \/usr\/lib\/libgalera_smm.so
    wsrep_node_address = 192.168.1.3
    wsrep_cluster_name=\"newcluster\"
    wsrep_cluster_address = gcomm:\/\/192.168.1.2,192.168.1.3,192.168.1.4
    wsrep_node_name = cluster2
    wsrep_slave_threads = 4
    wsrep_sst_method = xtrabackup-v2
    wsrep_sst_auth = sst:secret

    [sst]
    streamfmt = xbstream

    [xtrabackup]
    compress
    compact
    parallel = 2
    <\/code><\/pre>\n
    After doing configuration, start services of node 2.
    Start node 2 :<\/p>\n
    $ service mysql start
    <\/code><\/pre>\n
    Check cluster status :<\/p>\n
    $ mysql -e \"show global status like 'wsrep%';\"
    <\/code><\/pre>\n
    Now similarly you have to configure node 3<\/b>. Changes are listed below.<\/p>\n<\/div>\n
    Changes in configuration for node 3 :
          wsrep_node_address = 192.168<\/span>.1.4<\/span><\/span><\/span>
          wsrep_node_name = cluster3<\/span><\/span><\/code><\/pre>\n
    Start node 3 :<\/p>\n
    $ service mysql start<\/code><\/code><\/pre>\n
    Test percona XtraDb cluster:<\/span><\/h1>\n
    Log-in by mysql client in any node:<\/p>\n
    <code prettyprint=\"\" style=\"color: black; word-wrap: no<\/pre>\n
    mysql>create<\/span> database<\/span> opstree;<\/span>
    mysql>use opstree;
    mysql>create<\/span> table<\/span> nu113r(name varchar<\/span>(50<\/span>));<\/span>
    mysql>insert<\/span> into<\/span> nu113r values<\/span>(\"<\/span>zukin\");<\/span>
    mysql>select<\/span> * from<\/span> nu113r;<\/span><\/code><\/pre>\n<\/div>\n
    Check the database on other node by mysql client:<\/p>\n
    mysql>show databases;
    <\/code><\/pre>\n
    Note :<\/b> There should be a database named \u201copstree\u201d.<\/p>\n
    <\/code>mysql>use opstree;<\/code><\/pre>\n
    mysql>select<\/span> * from<\/span> nu113r;<\/span><\/code>\u00a0<\/code><\/pre>\n
    Note :<\/b> Data will be same as in the previous node.<\/p>\n<\/div>\n\n\n
    <\/p>\n","protected":false},"excerpt":{"rendered":"
    Percona XtraDB Cluster As a DevOps activist I am exploring Percona XtraDB. In a series of blogs I will share my learnings. This blog intends to capture step by step details of installation of Percona XtraDB in Cluster mode.\u00a0 \u00a0 Why Cluster Mode Introduction: Percona XtraDB cluster is High Availability and Scalability solution for MySQL … Continue reading “Getting Started with Percona XtraDB Cluster”<\/span><\/a><\/p>\n","protected":false},"author":171775670,"featured_media":29900,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[28070474,11987323],"tags":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/11\/DevSecOps-1.jpg","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pfDBOm-6p","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts\/397"}],"collection":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/users\/171775670"}],"replies":[{"embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/comments?post=397"}],"version-history":[{"count":2,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts\/397\/revisions"}],"predecessor-version":[{"id":1339,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts\/397\/revisions\/1339"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/media\/29900"}],"wp:attachment":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/media?parent=397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/categories?post=397"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/tags?post=397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}