MaxScale, the pluggable proxy for MySQL databases has just gone beta. With this new release comes a number of new features that improve the usability, functionality and versatility of MaxScale. Here are  a few of the things that have now become available with MaxScale 1.0 Beta.Read/Write Splitter Routing ModuleA number of enhancements have been made to the Read/Write splitter routing module for MaxScale

• Support for prepared statements
• Fault tolerance for read operations via multiple slaves
• Configurable load balancing methods
• Integration with slave replication lag monitoring to cap the acceptable lag
• Ability to weight the load distribution mechanism

Prepared StatementsThe preparation stage is now correctly recognised and distributed to all servers within a session that might need to execute these statements at a later date. The execution is then routed to an …

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 …

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 …

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 …