by Hrvoje Matijakovic | Jan 12, 2016 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.28-76.1 on January 12, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.28, including all the bug fixes in it, Percona Server...
by Hrvoje Matijakovic | Jan 12, 2016 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.47-37.7 on January 12, 2016. Based on MySQL 5.5.47, including all the bug fixes in it, Percona Server 5.5.47-37.7 is now the current stable release in the 5.5 series. Percona Server is open-source and free....
by Alexander Rubin | Nov 25, 2015 | Hardware and Storage, MySQL, Percona Software
Introduction In my last blog post, Internet of Things, Messaging and MySQL, I have showed how to start your own Internet of Things with Particle Photon board. That implementation is great, but requires constant internet (wi-fi) access as the Particle Photon board does...
by Matthew Boehm | Jun 9, 2015 | MongoDB, MySQL, Percona Software
Greetings everyone! Let’s discuss a 3rd Party auditing solution to MySQL and how we can leverage MongoDB® to make sense out of all of that data. The McAfee MySQL Audit plugin does a great job of capturing, at low level, activities within a MySQL server. It does...
by Jervin Real | Apr 10, 2015 | Benchmarks, MySQL, Percona Software
A few years back Deva wrote about how to use tcpdump on very busy hosts. That post sparked my interest about exploring how to measure the impact of tcpdump on very busy hosts. In this post, I wanted to highlight how much of an impact there really is and what options...
by Muhammad Irfan | Mar 16, 2015 | MySQL, Percona Services
One of our Percona Support customers recently reported that Percona XtraBackup failed with a page corruption error on an InnoDB table. The customer thought it was a problem or bug in the Percona XtraBackup tool. After investigation we found that an InnoDB page was...
by Stephane Combaudon | Mar 13, 2015 | Insight for DBAs, MySQL, Percona Software, Webinars
My webinar “Multi-threaded Replication in MySQL 5.6 and 5.7” on February 25 generated several excellent questions following the presentation (available an online migration to GTIDs and that’s why here.
by Stephane Combaudon | Mar 2, 2015 | Insight for DBAs, MySQL, Percona Software
From time to time people wonder how to implement roles in MySQL. This can be useful for companies having to deal with many user accounts or for companies with tight security requirements (PCI or HIPAA for instance). Roles do not exist in regular MySQL but here is an...
by Brock Wilson | Feb 24, 2015 | Benchmarks, MySQL, Percona Services, Percona Software
MySQL’s innodb_file_per_table is a wonderful thing – most of the time. Having every table use its own .ibd file allows you to easily reclaim space when dropping or truncating tables. But in some use cases, it may cause significant performance issues. Many...
by Peter Zaitsev | Jan 19, 2015 | Benchmarks, MySQL, Percona Software
A few days ago I wrote about MySQL performance implications of InnoDB isolation modes and I touched briefly upon the bizarre performance regression I found with InnoDB handling a large amount of versions for a single row. Today I wanted to look a bit deeper into the...
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 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 Matt Griffin | Nov 14, 2014 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL, Percona Software
One of the big announcements at the Amazon Web Services re:Invent 2014 conference this week was the unveiling of Aurora. The result of years of internal work, Aurora, currently in preview, is a MySQL 5.6-compatible option that “combines the speed and availability of...
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 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 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 Fernando Laudares Camargos | Aug 26, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
The need to have multiple instances of MySQL (the well-known mysqld process) running in the same server concurrently in a transparent way, instead of having them executed in separate containers/virtual machines, is not very common. Yet from time to time the Percona...
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 Fernando Laudares Camargos | Aug 22, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
In my last post, “
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...
