by Kenny Gryp | Jul 9, 2014 | Insight for DBAs, MySQL, Percona Software
A while back, I made some changes to the plugin interface for pt-online-schema-change which allows custom replication checks to be written. As I was adding this functionality, I also added the –plugin option to pt-table-checksum. This was released in Percona...
by Ernie Souhrada | Jul 8, 2014 | Cloud, Insight for DBAs, Insight for Developers, MySQL
This comes from an issue that I worked on recently, wherein a customer reported that their application was working fine under stock MySQL 5.6 but producing erroneous results when they tried running it on Amazon RDS 5.6. They had a table which, on the working server,...
by Matthew Boehm | Jul 7, 2014 | Insight for DBAs, MySQL
by Stephane Combaudon | Jul 3, 2014 | Insight for DBAs, MySQL
In the previous post of this series we saw how you could use mysqlrpladmin to perform manual failover/switchover when GTID replication is enabled in MySQL 5.6. Now we will review mysqlfailover (version 1.4.3), another tool from the MySQL Utilities that can be used for...
by Hrvoje Matijakovic | Jul 2, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.38-35.2 on July 2, 2014 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.38, including all the bug fixes in it, Percona Server 5.5.38-35.2 is now the current...
by Michael Coburn | Jul 2, 2014 | Cloud, Insight for DBAs, MySQL
I recently had an opportunity to migrate a customer from a physical server into Amazon’s RDS environment. In this particular case the customers’ platform makes extensive use of MySQL triggers and views. I came across two significant issues that prevented...
by Hrvoje Matijakovic | Jul 1, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.19-67.0 on July 1, 2014. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.19, including all the bug fixes in it, Percona Server 5.6.19-67.0...
by Bill Karwin | Jun 30, 2014 | Insight for DBAs, MySQL, Webinars
On July 16 I’ll be presenting my next webinar focusing on common mistakes committed by MySQL users. How to Avoid Even More of the Common (but Deadly) MySQL Development Mistakes “Why can’t I just save my data to a file?” Using an SQL database...
by Stephane Combaudon | Jun 27, 2014 | Insight for DBAs, MySQL
MySQL Utilities are a set of tools provided by Oracle to perform many kinds of administrative tasks. When GTID-replication is enabled, 2 tools can be used for slave promotion: mysqlrpladmin and mysqlfailover. We will review mysqlrpladmin (version 1.4.3) in this post....
by Zardosht.Kasheff | Jun 27, 2014 | MySQL
In TokuMX 1.5, we introduced partitioned collections for non-sharded clusters. That is, one can have a partitioned collection in a replica set, but one cannot shard a partitioned collection. In this post, I explain why. As I mentioned here, partitioned collections are...
by Fernando Laudares Camargos | Jun 26, 2014 | MySQL, Percona Software
My previous post was an introduction to the TokuDB storage engine and aimed at explaining the basics of its design and how it differentiates from InnoDB/XtraDB. This post is all about motivating you to give it a try and have a look for yourself. Percona Server is not...
by Dave Rosenlund | Jun 25, 2014 | MySQL
Today, at MongoDB World 2014 in New York City, we announced the winners of our inaugural TokuMX Compression & Performance Innovation Award. We selected two winners from amongst the nominees – Brightcove and Crowdtap. The announcement was made at the TokuMX...
by Peter Zaitsev | Jun 25, 2014 | Insight for DBAs, MySQL
Earlier this month I wrote about vmstat iowait cpu numbers and some of the comments I got were advertising the use of util% as reported by the iostat tool instead. I find this number even more useless for MySQL performance tuning and capacity planning. Now let me...
by Kenny Gryp | Jun 24, 2014 | Benchmarks, Insight for DBAs, MySQL
Tesora, previously called Parelastic, asked Percona to do a sysbench benchmark evaluation of its Database Virtualization Engine on specific architectures on Amazon EC2. The focus of Tesora is to provide a scalable Database As A Service platform for OpenStack. The...
by Fernando Laudares Camargos | Jun 23, 2014 | Insight for DBAs, MySQL, Percona Software
During last April’s Percona Live MySQL Conference and Expo, TokuDB celebrated it’s first full-year as an open source storage engine. I still remember reading the official announcement and the expectations it created one year ago. The premises were very...
by Dave Rosenlund | Jun 21, 2014 | MySQL
On Monday, some of the Boston-area Tokutek team will board New York bound trains to join our Union Square colleagues at MongoDB World 2014. We couldn’t be more excited. You would be too. TokuMX, our high-performance distribution of MongoDB, just had its first...
by Jericho Rivera | Jun 20, 2014 | Cloud, Insight for DBAs, MySQL, Percona Software
In my Percona ClusterControl and add the existing Patrick Galbraith’s blog series about Docker.
by Zardosht.Kasheff | Jun 20, 2014 | MySQL
Take the following scenario. You have a time-series data application for which you would like to store a rolling period of data. For example, you may want to maintain the last six months of traffic logs for a website, in order to analyze activity of different periods...
by Alexander Rubin | Jun 19, 2014 | MySQL
In my previous post about geo-spatial search in MySQL I described (along with other things) how to use geo-distance functions. In this post I will describe the geo-spatial distance functions in more details. If you need to calculate an exact distance between 2 points...
by Tim.Callaghan | Jun 18, 2014 | MySQL
Tokutek is pleased to announce today’s release of TokuMX v1.5. Also worth noting is that TokuMX is exactly 1 year old tomorrow. But enough about birthdays, and more about features! This release brings with it the ability to partition a collection in unsharded...
