Celery to Chew On

Asynchronous Celery tasks that manipulate a MySQL/Galera database from a Django application can produce very interesting behavior when HAProxy is involved.

more ...

Hands On Trove: Database as a Service in OpenStack

This tutorial covered OpenStack Trove at Percona Live 2014. If you want to recreate the experience, read on!

In order to make the most of this tutorial, you can recreate the interactive steps presented. Please note: the process, while simple, is extremely bandwidth intensive and you don't want to be …

more ...

Adding MySQL/Galera resources to Pacemaker

Once you have one instance of Galera running, and it is running on the same node that holds the temporarily-configured cluster IP (192.168.122.99 in our example), you can add your resources to the Pacemaker cluster configuration.

Create a temporary file, such as /tmp/galera.crm, with the …

more ...

Bootstrapping the Galera cluster

In order to bootstrap your Galera cluster, manually bring up the cluster IP address on the desired interface. In this example, we'll use 192.168.122.99 and eth1:

ip address add 192.168.122.99/24 dev eth1 label eth1:galera

And initialize the Galera cluster:

mysqld --wsrep_cluster_address=gcomm …
more ...

Configuring Corosync

You now need configure Corosync. The following example configuration file assumes that your cluster nodes have two network interfaces, using the 192.168.122.0/24 and 192.168.133.0/24 networks. You will need to adjust this to your own network configuration.

Set the contents of /etc/corosync …

more ...