Skip to main content

Posts

Showing posts from February, 2015

PERCONA STANDALONE SERVER

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 Standalone mode

Introduction:
Percona Server is an enhanced drop-in replacement for Mysql. It offers breakthrough performance, scalability, features, and instrumentation. Percona focus on providing a solution for the most demanding applications, empowering users to get the best performance and lowest downtime possible.
The Percona XtraDB Storage Engine: Percona XtraDB is an enhanced version of the InnoDB storage engine, designed to better scale on modern hardware, and including a variety of other features useful in high performance environments. It is fully backwards compatible, and so can be used as a drop-in replacement for standard InnoDB. Percona XtraDB includes all of InnoDB's robust, reliable ACID-compliant design and advanced MVCC architecture, and builds on that solid foundation with more featu…

Understanding 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 theoretical knowledge of Percona XtraDB Cluster.

Prerequisites You should have basic knowledge of mysql. OS - Ubuntu What is Percona? Percona XtraDB cluster is an open source, free MySql high availability and scalability software. It provides: Synchronous Replication: Transaction either committed on all nodes or none. Multi-Master Replication: You can write to any node Parallel applying events on slave. Real “parallel replication”. Automatic node provisioning. Data consistency. No more unsynchronized slaves. Introduction The cluster consists of nodes. The cluster’s recommended configuration is to have 3 nodes, however 2 nodes can be used as well. 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. Each n…

Getting Started with Percona XtraDB Cluster

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. 
Why Cluster Mode Introduction:

Percona XtraDB cluster is High Availability and Scalability solution for MySQL users which provides
          Synchronous replication : Transaction either committed on all nodes or none.
          Multi-master replication : You can write to any node.
          Parallel applying events on slave : parallel event application on all slave nodes
          Automatic node provisioning
          Data consistency
Straight into the Act:Installing Percona XtraDB Cluster Pre-requisites/Assumptions OS - Ububtu3 Ubuntu nodes are available For the sake of this discussion lets name the nodes as node 1 hostname: percona_xtradb_cluster1 IP:192.168.1.2 node 2hostname: percona_xtradb_cluster2 IP:192.168.1.3 node 3hostname: percona_xtradb_cluster3 IP:19…