by Peter Zaitsev | Oct 20, 2014 | Insight for DBAs, MySQL, Percona Events, Percona Live
Autumn is a season of MySQL-related conferences and I’m about to hit the road to speak and attend quite a few of them. This week I’ll participate in All Things Open, a local conference for me here in Raleigh, N.C. and therefore one I do not have to travel...
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 Dave Rosenlund | Oct 16, 2014 | MySQL
TokuDB 7.5 includes exclusive Read Free Replication (RFR) technology, fundamentally changing the MySQL replication landscape. By harnessing the power of Fractal Tree indexes, replication slaves can run with zero read IO, creating a variety of opportunities and...
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 Tim.Callaghan | Oct 16, 2014 | MySQL
In a few weeks I’m presenting “Performance Benchmarking: Tips, Tricks, and Lessons Learned” at Percona Live London 2014 (November 3-4). I continue to learn lessons and improve my benchmarking capabilities, so the content is a full upgrade from my...
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 Hrvoje Matijakovic | Oct 7, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.21-69.0 on October 7, 2014. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.21, including all the bug fixes in it, Percona Server...
by Hrvoje Matijakovic | Oct 7, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.40-36.1 on October 7, 2014. Based on MySQL 5.5.40, including all the bug fixes in it, Percona Server 5.5.40-36.1 is now the current stable release in the 5.5 series. Percona Server is open-source and free....
by Hrvoje Matijakovic | Oct 6, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.2.5 on October 2, 2014. Downloads are available from our download site here and Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for...
by Dave Rosenlund | Oct 3, 2014 | MySQL
MongoDB includes several powerful features like high availability, read scaling, and horizontal scalability in an easy-to-use, schema-free database platform. But, what if you could retain those properties, improve performance, and ensure scalability without...
by Stephane Combaudon | Oct 3, 2014 | Insight for DBAs, MySQL
HAProxy is frequently used as a load-balancer in front of a Galera cluster. While diagnosing an issue with HAProxy configuration, I realized that logging doesn’t work out of the box on CentOS 6.5. Here is a simple recipe to fix the issue. If you look at the top...
by Tim.Callaghan | Sep 30, 2014 | MySQL
Today we released TokuMX v2.0, the latest version of Tokutek’s high-performance MongoDB distribution. Highlights of this new release are as follows: Fast updates that can boost the speed of updates to unindexed fields by more than 10x. Ark elections making...
by Hrvoje Matijakovic | Sep 30, 2014 | MySQL, Percona Events, Percona Software
Percona is pleased to announce the availability of Percona Toolkit 2.2.11. Released on Sept. 25, Percona Toolkit is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex for DBAs to perform...
by Tim.Callaghan | Sep 29, 2014 | MySQL
Coming in TokuMX v2.0 is a feature we’re calling “Fast Updates”. Fast updates permit certain update operations to bypass the read-modify-write behavior that most databases require (including MongoDB and the current release of TokuMX). In this blog I’ll cover how Fast...
