Buy Percona ServicesBuy Now!

Galera replication – how to recover a PXC cluster

 | September 1, 2014 |  Posted In: Insight for DBAs, MySQL, Percona XtraDB Cluster

Galera replication for MySQL brings not only the new, great features to our ecosystem, but also introduces completely new maintenance techniques. Are you concerned about adding such new complexity to your MySQL environment? Perhaps that concern is unnecessarily. I am going to present here some simple tips that hopefully will let fresh Galera users prevent […]

Read More

Benchmark: SimpleHTTPServer vs pyclustercheck (twisted implementation)

 | May 16, 2014 |  Posted In: Benchmarks, Insight for DBAs, MySQL

Github user Adrianlzt provided a python-twisted alternative version of pyclustercheck per discussion on issue 7. Due to sporadic performance issues noted with the original implementation in SimpleHTTPserver, the benchmarks which I’ve included as part of the project on github use mutli-mechanize library, cache time 1 sec 2 x 100 thread pools 60s ramp up time 600s […]

Read More

Before every release: A glimpse into Percona XtraDB Cluster CI testing

 | February 21, 2014 |  Posted In: MySQL, Percona Software, Percona XtraDB Cluster

I spoke last month at linux.conf.au 2014 in Perth, Australia, and one of my sessions focused on the “Continuous Integration (CI) testing of Percona XtraDB Cluster (PXC)” at the Developer,Testing, Release and CI miniconf. Here is the video of the presentation: Here is the presentation itself: Percona XtraDB Cluster before every release: Glimpse into CI […]

Read More

Percona XtraDB Cluster/ Galera with Percona Monitoring Plugins

 | October 31, 2013 |  Posted In: MySQL, Percona Monitoring Plugins, Percona XtraDB Cluster, XtraDB Cluster

The Percona Monitoring Plugins (PMP) provide some free tools to make it easier to monitor PXC/Galera nodes.  Monitoring broadly falls into two categories: alerting and historical graphing, and the plugins support Nagios and Cacti, respectively, for those purposes. Graphing An update to the PMP this summer (thanks to our Remote DBA team for supporting this!) added a Galera-specific host template that […]

Read More

Choosing a MySQL HA Solution – MySQL Webinar: June 5

 | May 28, 2013 |  Posted In: Events and Announcements, Insight for DBAs, MySQL, Technical Webinars

Selecting the most appropriate solution for a MySQL HA infrastructure is as much a business and philosophical decision as it is a technical one, but often the choice is made without adequately considering all three perspectives.  When too much attention is paid to one of these aspects at the cost of the others, the resulting […]

Read More

Follow these basics when migrating to Percona XtraDB Cluster for MySQL

 | May 1, 2013 |  Posted In: Insight for DBAs, MySQL, Percona Software, XtraDB Cluster

Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump right in without enough testing. Consequently, they’re more likely to either suffer failure or issues that prevent them from moving forward. If you are thinking of migrating your workload to Percona XtraDB Cluster, make sure to go through these […]

Read More