by Vadim Tkachenko | Jun 18, 2014 | Insight for DBAs, MySQL, Percona Software, Webinars
We recently released a new version of Percona Cloud Tools with MySQL monitoring capabilities. Join me June 25 and learn the details about all of the great new features inside Percona Cloud Tools – which is now free in beta. The webinar is titled...
by Peter Zaitsev | Jun 17, 2014 | MySQL, Percona Services, Percona Software
The Percona Backup Service managed service launched today. It ensures properly configured backups run successfully as scheduled on customer provided backup storage – whether on premise, in the cloud, or a hybrid. Backup issues or production data recovery are...
by Zardosht.Kasheff | Jun 13, 2014 | MySQL
In my last post, I gave a technical explanation of the performance characteristics of partitioned collections in TokuMX 1.5 (which is right around the corner) and partitioned tables in relational databases. Given those performance characteristics, in this post, I will...
by Max Bubenick | Jun 13, 2014 | Insight for DBAs, MySQL
In this post I would like to review how my dumper for MySQL works from the point of view of locks. Since 0.6 serie we have different options, so I will try to explain how they work As you may know mydumper is multithreaded and this adds a lot of complexity compared...
by Hrvoje Matijakovic | Jun 12, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.2.3 on June 12th 2014. Downloads are available from our download site here and Percona Software Repositories. Percona XtraBackup enables backups without blocking user queries, making it ideal for...
by Hrvoje Matijakovic | Jun 11, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.17-66.0 on June 11, 2014. Downloads are available here and from the Percona Software Repositories. Based on MySQL 5.6.17, including all the bug fixes in it, Percona Server 5.6.17-66.0 is the current...
by Alexander Rubin | Jun 11, 2014 | Insight for DBAs, MySQL, Percona Software
When you make a change to your MySQL configuration in production it would be great to know the impact (a “before and after” type of picture). Some changes are obvious. For many variables proper values can be determined beforehand, i.e....
by Zardosht.Kasheff | Jun 10, 2014 | MySQL
In TokuMX 1.5 that is right around the corner, the big feature will be partitioned collections. This feature is similar to partitioned tables in Oracle, MySQL, SQL Server, and Postgres. A question many have is “why should I use partitioned tables?” In short, it’s...
by Peter Zaitsev | Jun 9, 2014 | Insight for Developers, MySQL, Webinars
The architecture of MySQL-powered applications is one of my favorite topics to talk about. It’s a very important topic because if you do not get the architecture right then you’re very likely to fail with your project – either from the standpoint of...
by Alexander Rubin | Jun 9, 2014 | Insight for DBAs, MySQL
Hosting a shared MySQL instance for your internal or external clients (“multi-tenant”) was always a challenge. Multi-tenants approach or a “schema-per-customer” approach is pretty common nowadays to host multiple clients on the same MySQL...
by Dave Rosenlund | Jun 5, 2014 | MySQL
MongoDB replication has a lot of great features including crash safety, automatic failover and parallel slave replication. Although MongoDB’s replication is impressive in many ways, TokuMX™ replication internals are purposely designed differently. Register Now!...
by Zardosht.Kasheff | Jun 5, 2014 | MySQL
Over several posts, I’ve explained the differences between TokuMX replication and MongoDB replication, and why they are completely incompatible. In this (belated) post, I explain one last difference: the oplog format for operations. Specifically, TokuMX and MongoDB...
by Zardosht.Kasheff | Jun 4, 2014 | MySQL
In my last post, I described a new feature in TokuMX 1.5—partitioned collections—that’s aimed at making it easier and faster to work with time series data. Feedback from that post made me realize that some users may not immediately understand the...
by Vadim Tkachenko | Jun 4, 2014 | Insight for Developers, MySQL, Percona Software, Webinars
We recently open-sourced our percona-agent and if you check out the source code, you’ll find that it is written in the Go programming language (aka Golang). For those not up to speed, the percona-agent is a real-time client-side agent for Percona Cloud Tools....
by Hrvoje Matijakovic | Jun 4, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Toolkit 2.2.8 on June 4th, 2014 (Downloads are available here and from the Percona Software Repositories). This release is the current GA (Generally Available) stable release in the 2.2 series. New Features: pt-agent...
by Peter Zaitsev | Jun 3, 2014 | Benchmarks, Insight for DBAs, MySQL, Percona Software
I’ve been running a benchmark today on my old test box with conventional hard drives (no raid with BBU) and noticed something unusual in the CPU utilization statistics being reported. The benchmark was run like this: sysbench --num-threads=64 --max-requests=0...
by Hrvoje Matijakovic | Jun 3, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.37-35.1 on June 3rd, 2014 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.37, including all the bug fixes in it, Percona Server 5.5.37-35.1 is now the current...
by Alexander Rubin | Jun 2, 2014 | MySQL
In my previous post about Hadoop and Impala I benchmarked performance of analytical queries in Impala. This time I’ve tried InfiniDB for Hadoop (open-source version) on the modern hardware with an 8-node Hadoop cluster. One of the main advantages (at least for...
by Fernando Ipar | May 30, 2014 | Insight for DBAs, MySQL
This is the third post in our MySQL Fabric series. If you missed the previous two, we started with an overall introduction, and then a discussion of MySQL Fabric’s high-availability (HA) features. MySQL Fabric was RC when we started this series, but it went GA...
by Zardosht.Kasheff | May 29, 2014 | MySQL
