Percona XtraDB Cluster 5.6 Setup Krishna Prajapati Fri, 07/04/2014 - 15:21 Percona XtraDB Cluster 5.6 Setup

Percona XtraDB Cluster (PXC) is a high availability and high scalability, solution for MySQL clustering. Percona Server, Percona Xtrabackup and Galera library for high availability integrated together as PXC. It provides synchronous, multi-master, and parallel replication. All the nodes of this cluster are ready to serve read/write request simultaneously.

VMs used for illustration. Here, I've used 1 centos node and 2 ubuntu nodes. In real world don't mix different OS. This is just for testing purpose. All nodes should be of the same configuration hardware/software.

1 Centos12 …

Percona XtraDB Cluster 5.6 Setup Krishna Prajapati Fri, 07/04/2014 - 15:21 Percona XtraDB Cluster 5.6 Setup

Percona XtraDB Cluster (PXC) is a high availability and high scalability, solution for MySQL clustering. Percona Server, Percona Xtrabackup and Galera library for high availability integrated together as PXC. It provides synchronous, multi-master, and parallel replication. All the nodes of this cluster are ready to serve read/write request simultaneously.

VMs used for illustration. Here, I've used 1 centos node and 2 ubuntu nodes. In real world don't mix different OS. This is just for testing purpose. All nodes should be of the same configuration hardware/software.

1 Centos12 …

Percona XtraDB Cluster 5.6 Setup Krishna Prajapati Fri, 07/04/2014 - 15:21 Percona XtraDB Cluster 5.6 Setup

Percona XtraDB Cluster (PXC) is a high availability and high scalability, solution for MySQL clustering. Percona Server, Percona Xtrabackup and Galera library for high availability integrated together as PXC. It provides synchronous, multi-master, and parallel replication. All the nodes of this cluster are ready to serve read/write request simultaneously.

VMs used for illustration. Here, I've used 1 centos node and 2 ubuntu nodes. In real world don't mix different OS. This is just for testing purpose. All nodes should be of the same configuration hardware/software.

1 Centos12 …

In previous posts, I was talking about how to set up MySQL replication, Classic Replication (based on binary logs information) and Transaction-based Replication (based on GTID). In this article I'll summarize how to troubleshoot MySQL replication for the most common issues we might face with a simple comparison how can we get them solved in the different replication methods (Classic VS GTID).

There are two main operations we might need to do in a replication setup:

• Skip or ignore a statement that causes the replication to stop.
• Re-initialize a slave when the Replication is broke and could not be started anymore.

Skip or Ignore statement

Basically, the slave should be always synchronized with its master having the same copy …

Percona XtraDB Cluster (PXC) is a high availability and high scalability, solution for MySQL clustering. Percona Server, Percona Xtrabackup and Galera library for high availability integrated together as PXC. It provides synchronous, multi-master, and parallel replication. All the nodes of this cluster are ready to serve read/write request simultaneously.

VMs used for illustration. Here, I've used 1 centos node and 2 ubuntu nodes. In real world don't mix different OS. This is just for testing purpose. All nodes should be of the same configuration hardware/software.

1 Centos12        192.168.56.12           node1
2 Ubuntu13        192.168.56.13           node2
3 Ubuntu14        192.168.56.14           node3

Adding repo's to the requisite OS

Centos/Redhat:

$ yum install …

The goal of this tutorial is to show you how to use Multi-Master and aggregate databases with the same name but with different data from different masters.

Example:

• master1 => a French subsidiary
• master2 => a British subsidiary

Both have the same database (PRODUCTION) but the data are totally different:

We will start with 3 servers (2 masters and 1 slave), you can add more master if needed.

Informations

•  10.10.16.231: first master (aka ”’master1”’) => a French subsidiary
• 10.10.16.232: second master (aka ”’master2”’) => a British subsidiary
• 10.10.16.233: slave (multi-master) (aka ”’slave”’)

If you have already your 3 servers correctly installed go directly to: “Dump your …

Finally! The new db4free.net Website has launched and along with it comes a new (slightly stronger) server and some simplifications with the service itself.

So what is new? Of course the new website which now is up to modern standards again, using a responsive design. While the old site was only designed for desktop (no surprise if you consider it was created in 2005 and remained more or less unchanged since), the new site adopts to small screen devices like mobile phones and tablets as well. Also the look is totally different:

db4free.net old

db4free.net new

The service now has a few simplifications. It is no longer allowed, or necessary, to …

My friend Brian Aker noticed my post from the other day on Ansible and image building had some things in the YAML Ansible playbooks that looked broken. Sure enough, I didn't notice when proofreading that double {{ and }}

curly braces weren't showing up! That was definite breakage but upon verification of the playbook in my repo, it was not broken and I realized that my markdown in my Jekyll-based github pages website/blog had manged the YAML …

This document describes how to setup a FreeRADIUS server. A MySQL server is used as backend and for the user accounting.

RADIUS is an industry-standard protocol for providing authentication, authorization, and accounting services.

• Authentication is the process of verifying a user’s identity and associating additional information (attributes) to the user’s login session.
• Authorization is the process of determining whether the user is allowed on the network and controlling network access values based on a defined security policy.
• Accounting is the process of generating log files that record session statistics used for billing, system diagnosis, and usage planning.

Installation:

Download freeradius source from http://freeradius.org/

tar -xzvf freeradius-server-3.0.3.tar.gz
cd freeradius …

Vagrant is an open source tool for building complete virtual development environment. Very often, test environment is required for testing latest release and new tools. Also, reduces the time spent in re-building OS. By default, it uses virtualbox for managing the Virtualization. Vagrant act as a central place configuration for managing/deploying multiple reproducible virtual environment with the same configuration.

Installing Virtualbox:

$ sudo apt-get install virtualbox

Installing Vagrant:

$ sudo apt-get install vagrant

Install the dkms package to ensure that the VirtualBox host kernel modules (vboxdrv, vboxnetflt and vboxnetadp) are properly updated if the Linux kernel version changes during the next apt-get …