EmergencyEMERGENCY? Get 24/7 Help Now!

Streamlined Percona XtraDB Cluster (or anything) testing with Consul and Vagrant

 | December 5, 2014 |  Posted In: Benchmarks, MySQL, Percona Cloud Tools, Percona XtraDB Cluster

Introducing Consul I’m always interested in what Mitchell Hashimoto and Hashicorp are up to, I typically find their projects valuable.  If you’ve heard of Vagrant, you know their work. I recently became interested in a newer project they have called ‘Consul‘.  Consul is a bit hard to describe.  It is (in part): Highly consistent metadata […]

Read More

Auto-bootstrapping an all-down cluster with Percona XtraDB Cluster

 | December 3, 2014 |  Posted In: MySQL, Percona XtraDB Cluster

One new feature in Percona XtraDB Cluster (PXC) in recent releases was the inclusion of the ability for an existing cluster to auto-bootstrap after an all-node-down event.  Suppose you lose power on all nodes simultaneously or something else similar happens to your cluster. Traditionally, this meant manually re-bootstrapping the cluster, but not any more. How it […]

Read More

Tips from the trenches for over-extended MySQL DBAs

 | December 2, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Managed Services, Percona Monitoring Plugins, Percona Remote DBA

This post is a follow-up to my November 19 webinar, “Tips from the Trenches: A Guide to Preventing Downtime for the Over-Extended DBA,” during which I described some of the most common reasons DBAs experience avoidable downtime. The session was aimed at the “over-stretched DBA,” identified as the MySQL DBA short of time or an […]

Read More

MySQL benchmarking: Know your baseline variance!

 | November 26, 2014 |  Posted In: Benchmarks, MySQL

Often enough I find MySQL benchmark results where the difference between results is 1% or even less and some conclusions are drawn. Now it is not that 1% is not important – especially when you’re developing the product you should care about those 1% improvements or regressions because they tend to add up. However with […]

Read More

Percona XtraDB Cluster 5.6.21-25.8 is now available

 | November 25, 2014 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraDB Cluster

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on Novmeber 25th 2014. Binaries are available from downloads area or from our software repositories. We’re also happy to announce that Ubuntu 14.10 and CentOS 7 users can download, install, and upgrade Percona XtraDB Cluster 5.6 from Percona’s software repositories. Based on […]

Read More

(More) Secure local passwords in MySQL 5.6 and up

 | November 25, 2014 |  Posted In: MySQL, Security

I log into a lot of different servers running MySQL and one of the first things I do is create a file in my home directory called ‘.my.cnf’ with my credentials to that local mysql instance:

This means I don’t have to type my password in every time, nor am I tempted to include […]

Read More

Percona Server 5.6.21-70.1 is now available

 | November 24, 2014 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software

Percona is glad to announce the release of Percona Server 5.6.21-70.1 on November 24, 2014. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.21, including all the bug fixes in it, Percona Server 5.6.21-70.1 is the current GA release in the Percona Server 5.6 series. Percona Server is […]

Read More