{"id":392,"date":"2015-02-23T05:19:00","date_gmt":"2015-02-23T05:19:00","guid":{"rendered":"https:\/\/opstree.com\/blog\/\/2015\/02\/23\/understanding-percona-xtradb-cluster\/"},"modified":"2019-09-18T14:12:26","modified_gmt":"2019-09-18T08:42:26","slug":"understanding-percona-xtradb-cluster","status":"publish","type":"post","link":"https:\/\/opstree.com\/blog\/2015\/02\/23\/understanding-percona-xtradb-cluster\/","title":{"rendered":"Understanding Percona XtraDB cluster"},"content":{"rendered":"
\n
\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 theoretical knowledge of Percona XtraDB Cluster.<\/span><\/span>
\n
\n<\/span><\/span><\/div>\n<\/div>\n
\n

Prerequisites<\/span><\/span><\/span><\/h2>\n<\/div>\n
\n
    \n
  1. You should have basic knowledge of mysql.\u00a0<\/span><\/span><\/span><\/li>\n
  2. OS – Ubuntu<\/span><\/span><\/span><\/li>\n<\/ol>\n<\/div>\n
    \n

    What is Percona?<\/span><\/span><\/span><\/h3>\n<\/div>\n
    Percona XtraDB cluster is an open source, free MySql high availability and scalability software.<\/span><\/span><\/span><\/div>\n
    It provides:<\/span><\/span><\/span><\/div>\n
      \n
    1. \n
      Synchronous Replication: Transaction either committed on all nodes or none.<\/span><\/span><\/span><\/div>\n<\/li>\n
    2. \n
      Multi-Master Replication: You can write to any node<\/span><\/span><\/span><\/div>\n<\/li>\n
    3. \n
      Parallel applying events on slave. Real \u201cparallel replication\u201d.<\/span><\/span><\/span><\/div>\n<\/li>\n
    4. \n
      Automatic node provisioning.<\/span><\/span><\/span><\/div>\n<\/li>\n
    5. \n
      Data consistency. No more unsynchronized slaves. <\/span><\/span><\/span><\/div>\n<\/li>\n<\/ol>\n
      \n


      \nIntroduction<\/span><\/span><\/span><\/h3>\n<\/div>\n
        \n
      1. \n
        The cluster consists of nodes. The cluster\u2019s recommended configuration is to have 3 nodes, however 2 nodes can be used as well.<\/span><\/span><\/span><\/div>\n<\/li>\n
      2. \n
        Every node is a regular Mysql \/ Percona server setup. You can convert your existing MySQL \/ Percona Server into Node and roll Cluster using it as a base or you can detach Node from Cluster and use it as a regular server.<\/span><\/span><\/span><\/div>\n<\/li>\n
      3. \n
        Each node will contain full copy of data.<\/span><\/span><\/span><\/div>\n<\/li>\n<\/ol>\n

        <\/b>\"percona.jpeg.jpg\"<\/b><\/p>\n

        \n

        <\/b>Benefits of this approach:<\/span><\/span><\/span><\/h4>\n<\/div>\n