Drizzle: the most influential software project you’ve (probably) never heard of

Posted on Tue 10 May 2022 in blog • Tagged with Development, CI, MySQL, OpenStack • 7 min read

Drizzle aimed to rewrite the MySQL database server. It instead rewrote collaborative software development.


Continue reading

Celery to Chew On

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

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 • 1 min read

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


Continue reading

Adding MySQL/Galera resources to Pacemaker

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

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 • 1 min read

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