by David Busby | Sep 26, 2014 | MySQL
The media train is in full steam today over the the CVE-2014-6271 programming flaw, better known as the “Bash Bug” or “Shellshock” – the original problem was disclosed on Wednesday via this post. Firstly this issue exploits bash...
by Przemysław Malkowski | Sep 25, 2014 | Insight for DBAs, Insight for Developers, MySQL
Recently I encountered a specific situation in which a customer was forced to stay with the MyISAM engine due to a legacy application using tables with over 1000 columns. Unfortunately InnoDB has a limit at this point. I did not expect to hear this argument for...
by Tushar Katarki | Sep 24, 2014 | Insight for DBAs, MySQL, Percona Software
Percona Server and Percona XtraDB Cluster provide high-performance alternatives for MySQL users. We have also seen rapidly growing interest in these solutions in the OpenStack community where higher performance and high availability are crucial. Many OpenStack users...
by Muhammad Irfan | Sep 19, 2014 | Insight for DBAs, MySQL
MySQL upgrades are necessary tasks and we field a variety of questions here at Percona Support regarding MySQL upgrade best practices. This post highlights the recommended ways to upgrade MySQL in different scenarios. Why are MySQL upgrades needed? The reasons are...
by Mike Benshoof | Sep 18, 2014 | Insight for DBAs, MySQL
Over the past few months, I’ve seen an increase in the following use case while working on performance and schema review engagements: I need to store exponentially increasing amounts of data and analyze all of it in real-time. This is also known simply as:...
by Jervin Real | Sep 17, 2014 | Insight for DBAs, MySQL, Percona Software
I recently encountered a situation in which after running Percona Toolkit’s pt-table-checksum on a customer system, 95% of the table on the MySQL master was different on the MySQL slave. Although this table was not a critical part of the infrastructure, from...