All posts by Phil

Installing ClusterControl with an existing cluster and Nginx

ClusterControl is a comprehensive tool for managing and monitoring MySQL and MongoDb clusters, more information can be found here: http://www.severalnines.com/clustercontrol ClusterControl comes with some great scripts for automating deployment, however there are a number of hard coded dependencies (like Apache) which make it a rather more painful process to integrate with your existing systems. Background […]

Share

Some observations while upgrading Percona XtraDB Cluster from 5.5 to 5.6

I followed the Percona guide to upgrade my XtraDB Cluster (MySQL + Galera) from 5.5 to 5.6, details can be found here: http://www.percona.com/doc/percona-xtradb-cluster/5.6/upgrading_guide_55_56.html The upgrade process I included putting the upgraded nodes into read only mode and I performed an additional step to reconfigure the xinetd process used to run clustercheck after installing the new […]

Share

Showing the correct client IP in logs and scripts when using Nginx behind a reverse proxy

I’ve noticed when it comes to use of reverse proxies such as HAProxy to serve high availability websites that many people seem to struggle to get the real client IP address both in their server logs and scripting languages (e.g. PHP). This is actually really easy to do, but it seems that the methods are […]

Share

PC Rebuild – Part 2

All the parts have finally arrived, including one or two things I forgot about. I had to order a few extra connectors as the 1/2″ ID tubing was slightly less easy to route as I expected (coming from 3/8″ ID tubing currently). Also worth mentioning that neither Aqua Computer’s D5 pumps or XSPC’s twin D5 […]

Share

PC Rebuild – Part 1

Lately I’ve been trying to reduce noise in my desktop PC, but the knock on effect of this has been at the expense of cooling performance. I’m also bored of the case (which looks pretty grubby now) and the system colours as well as being fed up with the mess of cables inside (no cable […]

Share