by Andrew Moore | Nov 18, 2014 | Insight for DBAs, MySQL, Percona Services
MySQL table alterations can interrupt production traffic causing bad customer experience or in worst cases, loss of revenue. Not all DBAs, developers, and syadmins know MySQL well enough to avoid this pitfall. DBAs usually encounter these kinds of production...
by Peter Zaitsev | Nov 18, 2014 | Benchmarks, MySQL
Starting with MySQL 5.6 there is an INNODB_METRICS table available in INFORMATION_SCHEMA which contains some additional information than provided in the SHOW GLOBAL STATUS output – yet might be more lightweight than PERFORMANCE_SCHEMA. Too bad INNODB_METRICS was...
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 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 Daniel Guzmán Burgos | Nov 12, 2014 | Insight for DBAs, MariaDB, MySQL, Percona Software
Did your logging stop working after you set up logrotate? Then this post might be for you. Some time ago, Peter Boros wrote about Rotating MySQL Slow Logs safely, explaining the steps of a “best practice” log rotate/archive. This post will add more info...
by Peter Zaitsev | Nov 10, 2014 | MongoDB, MySQL
I visited MongoDB Day in London on November 6. Here are a few observations: App-Developer Centric. It is interesting to see how much MongoDB is about developers; the ops side is something which is a necessary evil developers have to deal with. The ops topics covered...
by Stephane Combaudon | Nov 4, 2014 | MySQL, Percona Software
Percona Toolkit’s pt-table-checksum is a great tool to find data inconsistencies between a MySQL master and its replicas. However it is sometimes not enough to know that there are inconsistencies and let pt-table-sync fix the issue: you may want to know which...
by Tushar Katarki | Nov 1, 2014 | Insight for DBAs, MySQL, Percona Software
MySQL database usage is popular in OpenStack. Core OpenStack services for Compute (Nova), Storage (Cinder), Neutron (Networking), Image (Glance) and Identity (Keystone) all use MySQL database. MySQL – as the world’s most popular database, runs inside OpenStack...
by Peiran Song | Oct 28, 2014 | Insight for DBAs, MySQL, Percona Software
A deadlock in MySQL happens when two or more transactions mutually hold and request for locks, creating a cycle of dependencies. In a transaction system, deadlocks are a fact of life and not completely avoidable. InnoDB automatically detects transaction deadlocks,...
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 Peter Zaitsev | Oct 17, 2014 | MySQL, Percona Software
In many write-intensive workloads Innodb/XtraDB storage engines you may see hidden and dangerous “debt” being accumulated – unpurged transaction “history” which if not kept in check over time will cause serve performance regression or...
by Matthew Boehm | Oct 16, 2014 | MySQL, Percona Software
I recently had a client ask me how to use Percona Toolkit tools with an SSL connection to MySQL (MySQL-SSL). SSL connections aren’t widely used in MySQL due to most installations being within an internal network. Still, there are cases where you could be...
by David Busby | Oct 15, 2014 | MySQL, Security
Padding Oracle On Downgraded Legacy Encryption First off, the naming “convention” as of late for security issues has been terrible. The newest vulnerability (CVE-2014-3566) is nicknamed POODLE, which at least is an acronym and as per the header above has...
by Tom Diederich | Oct 15, 2014 | Insight for DBAs, MySQL, Percona Software
Founded in 1998, Rackspace has evolved over the years to address the way customers are using data – and more specifically, databases. The San Antonio-based company is fueling the adoption of cloud computing among organizations large and small. Today Rackspace is...
by Jervin Real | Oct 14, 2014 | MySQL
A few months back, Michael wrote about reconnecting orphaned *.ibd files using MySQL 5.6. I will show you the same procedure, this time for partitioned tables. An InnoDB partition is also a self-contained tablespace in itself so you can use the same method described...
by Arunjith Aravindan | Oct 13, 2014 | MySQL, Percona Software
Percona Toolkit’s pt-table-checksum performs an online replication consistency check by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master – and the tool pt-table-sync synchronizes...
by Peter Zaitsev | Oct 10, 2014 | MySQL, Percona Software
MySQL has information_schema.tables that contain information such as “data_length” or “avg_row_length.” Documentation on this table however is quite poor, making an assumption that those fields are self explanatory – they are not when it...
by Muhammad Irfan | Oct 8, 2014 | Insight for DBAs, MySQL, Percona Services
MySQL replication is a core process for maintaining multiple copies of data – and replication is a very important aspect in database administration. In order to synchronize data between master and slaves you need to make sure that data transfers smoothly, and to...
by Stephane Combaudon | Oct 7, 2014 | Insight for DBAs, MySQL, Percona Services
I’ve recently worked with customers using replication rings with 4+ servers; several servers accepting writes. The idea behind this design is always the same: by having multiple servers, you get high availability and by having multiple writer nodes, you get...
by Stephane Combaudon | Sep 29, 2014 | Insight for DBAs, MySQL
MySQL is the database of choice for most OpenStack components (Ceilometer is a notable exception). If you start with a small deployment, it will probably run like a charm. But as soon as the dataset grows, you will suddenly face several challenges. We will write a...
