Celery to Chew On

Posted on Wed 06 May 2020 in hints-and-kinks • Tagged with Django, MySQL, HAProxy, Celery, Python

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


Continue reading

Hands On Trove: Database as a Service in OpenStack

Posted on Thu 27 March 2014 in presentations • Tagged with Conference, MySQL, 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 …


Continue reading

Adding MySQL/Galera resources to Pacemaker

Posted on Tue 04 December 2012 in hints-and-kinks • Tagged with Galera, MySQL, 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 …


Continue reading

Bootstrapping the Galera cluster

Posted on Tue 04 December 2012 in hints-and-kinks • Tagged with Galera, MySQL, Pacemaker

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 …

Continue reading

Configuring Corosync

Posted on Tue 04 December 2012 in hints-and-kinks • Tagged with Galera, MySQL, Pacemaker

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 …


Continue reading