by Peter Zaitsev | Dec 31, 2014 | Benchmarks, MySQL, Percona Software
If you’ve been studying complex systems you know what minor changes might cause consequences of much greater proportions, sometimes causing some effects that are not easily explained at first. I recently ran across a great illustration of such behavior while...
by Stephane Combaudon | Dec 30, 2014 | MySQL, Percona Software
State Snapshot Transfer (SST) is used in Percona XtraDB Cluster (PXC) when a new node joins the cluster or to resync a failed node if Incremental State Transfer (IST) is no longer available. SST is triggered automatically but there is no magic: If it is not configured...
by Bill Karwin | Dec 29, 2014 | Insight for DBAs, MySQL, Percona Software
Some time ago, Peter Zaitsev posted a blog titled “How well does your table fits in innodb buffer pool?” He used some special INFORMATION_SCHEMA tables developed for Percona Server 5.1 to report how much of each InnoDB table and index resides in your...
by Peter Zaitsev | Dec 24, 2014 | Insight for DBAs, MySQL
It has been a while since I have looked at InnoDB crash recovery. A lot has change in the last few years – we have serious crash recovery performance improvements in MySQL 5.5 and MySQL 5.6, we have solid state drives raising as typical high performance IO...
by Joel.Epstein | Dec 23, 2014 | MySQL
The MySQL 5.6 Release has introduced some changes to how two phase commit works and is managed. In particular, the commit phase of transactions to the binary log is now serialized and this behavior is something we identified fairly immediately. We implement a group...
by David Busby | Dec 23, 2014 | Insight for DBAs, MySQL, Security
This is a long overdue blog post from London’s 44con Cyber Security conference back in September. A lot of old memories were brought to the front as it were; the one I’m going to cover in this blog post is: file carving. So what is file carving? despite...
by Jay Janssen | Dec 22, 2014 | MySQL, Percona Software
Background on Backup Locks I was very excited to see Backup locks support in release notes for the latest Percona XtraDB Cluster 5.6.21 release. For those who are not aware, backup locks offer an alternative to FLUSH TABLES WITH READ LOCK (FTWRL) in
by Karthik Appigatla | Dec 19, 2014 | MySQL
Please note, a more up-to-date follow-up post is here: Storing UUID and Generated Columns A few years ago Peter Zaitsev, in a post titled “”There is timestamp based part in UUID which has similar properties to auto_increment and which could be used to have...
by Stephane Combaudon | Dec 18, 2014 | Insight for DBAs, MySQL, Percona Software
HAProxy is frequently used as a software load balancer in the MySQL world. Peter Boros, in a past post, explained how to set it up with Percona XtraDB Cluster (PXC) so that it only sends queries to available nodes. The same approach can be used in a regular...
by Rich.Prohaska | Dec 17, 2014 | MySQL
TokuDB offers high throughput for write intensive applications, and the throughput scales with the number of concurrent clients. However, when the binary log is turned on, TokuDB 7.5.2 throughput suffers. The throughput scaling problem is caused by a poor...
by Peter Zaitsev | Dec 17, 2014 | Insight for DBAs, MySQL
I believe InnoDB storage engine architecture is great for a lot of online workloads, however, there are no silver bullets in technology and all design choices have their trade offs. In this blog post I’m going to talk about one important InnoDB limitation that...
by Dave Rosenlund | Dec 16, 2014 | MySQL
UPDATE: Since the publication of this blog post, Tokutek subsequently published preliminary benchmark results for this new TokuMX sibling, now called TokuMXse. In addition, there have been a number of release candidates. Finally, MongoDB ultimately decided to call...
by Tom Diederich | Dec 16, 2014 | Insight for DBAs, MySQL, Percona Live
I attended the OpenStack Paris summit last month (Percona had a booth there). It was my first opportunity to meet face-to-face with this thriving community of developers and users. I’m proud that Percona is part of this open source family and look forward to...
by Tom Diederich | Dec 15, 2014 | MySQL, Percona Live
The many hours of intensive tutorials, led by some of the top minds in MySQL, have always been a major draw each year to the Percona Live MySQL Conference and Expo. And 2015’s event will be no exception. Percona Live 2015 runs April 13-16 in Santa Clara, Calif....
by Dave Rosenlund | Dec 10, 2014 | MySQL
Want to tweet out a personalized holiday video to your friends? Heckenlights is a Christmas lights installation playing Christmas songs that lets viewers customize and share it. Heckenlights was created by software developer Mark Paluch (@mp911de) who thought it was...
by Hrvoje Matijakovic | Dec 10, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.2.7 on December 10, 2014. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for...
by Daniel Guzmán Burgos | Dec 10, 2014 | Insight for DBAs, MySQL
Disclaimer: Reset the MySQL root password at your own risk! It doesn’t apply if you’re using Pluggable authentication and certainly won’t be usable if/when MySQL system tables are stored on InnoDB What is the situation? The situation is the classic...
by Kortney Runyan | Dec 9, 2014 | MySQL, Percona Live
On behalf of the OpenStack Live Conference Committee, I am excited to announce the sneak peek schedule for the inaugural OpenStack Live 2015 Conference! This new annual conference, running in parallel with the already established Percona Live MySQL Conference and...
by Muhammad Irfan | Dec 9, 2014 | Insight for DBAs, MySQL
In MySQL 5.6 Oracle introduced a Transportable Tablespace feature (copying tablespaces to another server) and Percona Server adopted it for partial backups which means you can now take individual database or table backups and your destination server can be a vanilla...
by Fernando Laudares Camargos | Dec 8, 2014 | Insight for DBAs, MySQL
Have you ever experienced a situation where one moment you can connect to the MySQL database and the next moment you cannot, only to be able to connect again a second later? As you may know one cannot open infinite connections with MySQL. There’s a practical...
