by Jay Janssen | Dec 5, 2014 | Benchmarks, MySQL, Percona Software
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...
by Peter Boros | Dec 4, 2014 | Insight for DBAs, MySQL, Webinars
Fact: MySQL is the most commonly used database in OpenStack deployments. Of course that includes a number of MySQL variants – standard MySQL by Oracle, MariaDB, Percona Server, MySQL Galera, Percona XtraDB Cluster, etc. However, there are many misconceptions and...
by Jay Janssen | Dec 3, 2014 | MySQL, Percona Software
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...
by Andrew Moore | Dec 2, 2014 | Insight for DBAs, MySQL, Percona Services
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...
by Jay Janssen | Nov 21, 2014 | Cloud, MySQL, Percona Software
I’m happy to announce that Google has added Click-to-deploy functionality for Percona XtraDB Cluster (PXC) on Google Cloud Compute nodes. This gives you the ability to rapidly spin up a cluster for experimentation, performance testing, or even production use on...
by Stephane Combaudon | Nov 17, 2014 | Insight for DBAs, MySQL
Even if a Galera node looks like a regular MySQL server, the underlying replication mechanism is very different. This implies some changes in the way you have to configure the Galera nodes. Here are some of the most common misconceptions about Galera when using this...
by Jay Janssen | Nov 14, 2014 | Insight for DBAs, MySQL, Percona Software
Thanks to all who attended my Nov. 12 webinar titled, “Percona XtraDB Cluster as a MySQL HA Solution for OpenStack.” I had several questions which I covered at the end and a few that I didn’t. You can view the entire webinar and download the slides...
by Aurimas Mikalauskas | Nov 14, 2014 | Insight for DBAs, MySQL
This blog post was inspired by my visit at the annual Zabbix Conference in Riga, Latvia this year, where I gave a couple of talks on MySQL and beyond. It was a two-day single-track event with some 200 participants, a number of interesting talks on Zabbix (and related...
by Jay Janssen | Nov 6, 2014 | Insight for DBAs, MySQL, Percona Software, Webinars
MySQL is the most popular and widely used open source database on the planet. OpenStack is fast evolving as the defacto open source cloud platform. OpenStack services such as Nova (Compute), Cinder (Storage), Neutron (Networking), to name just a few, all use MySQL as...
by Liz van Dijk | Oct 31, 2014 | MySQL, Percona Live, Percona Software
If you’re following this blog, it’s quite likely you’re already aware of the Percona Live London 2014 conference coming up in just a few days. Just in case, though (you know, if you’re still looking for an excuse to sign up), I wanted to put a...
by Fernando Laudares Camargos | Oct 21, 2014 | MySQL, Percona Software
I reckon there’s little sense in running 2 or more Percona XtraDB Cluster (PXC) nodes in a single physical server other than for educational and testing purposes – but doing so is still useful in those cases. The most popular way of achieving this seems to...
by Jay Janssen | Sep 22, 2014 | MySQL, Percona Services, Percona Software
Interest in Percona XtraDB Cluster / Galera has been high ever since we introduced the product in 2012. I typically have a conversation about Galera and Percona XtraDB Cluster (PXC) at least once a week with a consulting customer who wants to know if it will be a...
by Peter Boros | Sep 11, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
I was fortunate to attend an Ops discussion about databases at the OpenStack Summit Atlanta this past May as one of the panelists. The discussion was about deadlock issues OpenStack operators see with
by Ernie Souhrada | Sep 9, 2014 | Insight for DBAs, MySQL, Percona Software
A common migration path from standalone MySQL/Percona Server to a Percona XtraDB Cluster (PXC) environment involves some measure of time where one node in the new cluster has been configured as a slave of the production master that the cluster is slated to replace. In...
by Miguel Angel Nieto | Sep 8, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
When a write query is sent to
by Przemysław Malkowski | Sep 1, 2014 | Insight for DBAs, MySQL, Percona Software
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...
by Fernando Laudares Camargos | Aug 29, 2014 | MySQL, Percona Services, Percona Software
I was talking with a Percona Support customer earlier this week who was looking for Galera data on Percona Cloud Tools. (Percona Cloud Tools is a hosted service providing access to query performance insights for all MySQL uses.) The customer mentioned they were...
by Tim Sharp | Aug 25, 2014 | Insight for DBAs, MySQL, Percona Software
In a previous post, my colleague mission statement declares, the Trove project seeks to provide a scalable and reliable cloud database service providing functionality for both relational and non-relational database engines. With the current release of Icehouse, the...
by Matt Griffin | Aug 1, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
MySQL plays a critical role in OpenStack. It serves as the host database supporting most components such as Nova, Glance, and Keystone and is the most mature guest database in Trove. Many OpenStack operators use Percona open source software including the MySQL drop-in...
by Stephane Combaudon | Jul 25, 2014 | Insight for DBAs, MySQL, Percona Software
Monitoring flow control in a Galera cluster is very important. If you do not, you will not understand why writes may sometimes be stalled. Percona XtraDB Cluster 5.6 provides 2 status variables for such monitoring: wsrep_flow_control_paused and...
