May 20, 2013

How to start a Percona XtraDB Cluster

Before version 5.5.28 of Percona XtraDB Cluster, the easiest way was to join the cluster using wsrep_urls in [mysqld_safe] section of my.cnf. So with a cluster of 3 nodes like this : node1 = 192.168.1.1 node2 = 192.168.1.2 node3 = 192.168.1.3 we defined the setting like this :

With that line above in my.cnf [...]

Aligning IO on a hard disk RAID – the Benchmarks

In the first part of this article I have showed how I align IO, now I want to share results of the benchmark that I have been running to see how much benefit can we get from a proper IO alignment on a 4-disk RAID1+0 with 64k stripe element. I haven’t been running any benchmarks [...]