Monthly Archives - February 2014

TokuMX vs. MongoDB : Sharding Balancer Performance

I have always believed that TokuMX’s Fractal Tree indexes are an ideal fit for MongoDB’s sharding model, especially when it comes time for balancing to occur. At a very high level, balancing is needed when one shard contains more chunks than another. The actual formula is well described in the MongoDB documentation. Balancing shards […]

Read more

What’s new in TokuMX 1.4, Part 1: Primary keys

We just released version 1.4.0 of TokuMX, our high-performance distribution of MongoDB. There are a lot of improvements in this version (release notes), the most of any release yet. In this series of blog posts, we describe the most interesting changes and how they’ll affect users.
MongoDB doesn’t have a “primary key” the way SQL […]

Read more

Using Percona rsync repositories to set up the local CentOS mirror

One of the more popular support requests we get involves setting up the official Percona rsync repositories that can be used to set up local mirrors. I’m glad to announce that this was implemented recently. You can now access the rsync repository at:
rsync://rsync.percona.com/rsync/
Setting up the local mirror can be useful if you have a […]

Read more

Percona XtraDB Cluster performance monitoring and troubleshooting: Webinar

Next Wednesday, Severalnines CTO Johan Andersson and I will co-present a webinar about ClusterControl, a cluster management tool created by Severalnines that can monitor Percona XtraDB Cluster. It provides DBAs with the right metrics to manage and optimize applications during development and production.
In the webinar, titled “Performance Monitoring and Troubleshooting of Percona XtraDB Cluster,” we […]

Read more

Changing an async slave of a PXC cluster to a new Master using 5.6 and GTID

Before Percona XtraBackup 2.1.7 and Percona XtraDB Cluster 5.6.15-25.3, rsync was the only SST method supporting GTID in the way that it was possible to move an asynchronous slave from one Galera node to another one (related bug).
Indeed, previous versions of Percona XtraBackup didn’t copy any binary log and due to that, moving the […]

Read more

Introducing TokuMX 1.4: Major improvements to MongoDB sharding and replication

Today we are thrilled to announce the availability of the latest release (1.4.0) of TokuMX, our high-performance distribution of MongoDB.
For those of you just joining us, TokuMX is an open-source distribution of MongoDB that shares much of the code, and all of the driver protocols, data model, and programming interface with MongoDB, but which […]

Read more

February 20 Webinar: MongoDB and Sharding for Scalability – Tips & Tricks

As your database begins to scale, sharding can be an effective way to manage your data. In MongoDB, sharding is unique because it retains nearly all of the the full expressiveness of a single server database while scaling out.
Register Now!
SPEAKER: Leif Walsh, Tokutek
DATE: Thursday, February 20th
TIME: 1pm ET
However, while sharding in MongoDB can be […]

Read more

Keynote Speakers for Percona Live MySQL Conference 2014 and $5 Expo Only Passes

The Percona Live MySQL Conference 2014 in Santa Clara, California is just around the corner: April 1-4. There is a tremendous amount of activity leading up to the conference, some of which I will highlight here.
Percona Live MySQL Conference 2014 Keynote Speakers
Oracle’s Tomas Ulin will speak again this year.
I am extremely pleased with the […]

Read more

8 common (but deadly) MySQL operations mistakes and how to avoid them

January 22 I gave a presentation on “How to Avoid Common (but Deadly) MySQL Operations Mistakes” for Percona MySQL Webinars. If you missed it, you can still register to view the recording and my slides.
Thanks to everyone who attended, and especially to folks who asked the great questions. I answered as many as we […]

Read more