EmergencyEMERGENCY? Get 24/7 Help Now!

Understanding the Performance Characteristics of Partitioned Collections

 | June 10, 2014 |  Posted In: Tokutek, TokuView

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 complicated. The answer depends on your workload, your schema, and your […]

Read More

Architecture and Design of MySQL-powered applications: June 11 Webinar

 | June 9, 2014 |  Posted In: Insight for Developers, MySQL, Technical 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 failing with performance, high availability or security requirements… or failing to deliver […]

Read More

Using MySQL 5.6 Performance Schema in multi-tenant environments

 | June 9, 2014 |  Posted In: 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 sever. One of issues of this approach, however, is the lack of visibility: it is hard to tell how many resources (queries, disk, […]

Read More

June 11 Webinar: Comparing MongoDB and TokuMX Replication

 | June 5, 2014 |  Posted In: Tokutek, TokuView

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! SPEAKER: Zardosht Kasheff, Sr. Engineer DATE: Wednesday, June 11th TIME: 1pm EDT/10am PDT TokuMX is built on Fractal Tree® technology, unlike […]

Read More

Why TokuMX Changed MongoDB’s Oplog Format for Operations

 | June 5, 2014 |  Posted In: Tokutek, TokuView

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 log updates and deletes differently. Suppose we have a collection foo, with the following element:

We perform […]

Read More

The Difference Between TokuMX Partitioning and Sharding

 | June 4, 2014 |  Posted In: Tokutek, TokuView

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 differences between partitioning a collection and sharding a collection. In this post, I hope […]

Read More

Why did we develop percona-agent in Go?

 | June 4, 2014 |  Posted In: Insight for Developers, MySQL, Percona Cloud Tools, Percona Server for MySQL, Percona Software, Percona Toolkit, Percona XtraBackup, Percona XtraDB Cluster, Technical 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. Our requirements are quite demanding for our agents. This one is software that works […]

Read More

Percona Toolkit 2.2.8 is now available

 | June 4, 2014 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona Toolkit

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 has been replaced by percona-agent. More information on percona-agent can be found in the Introducing the 3-Minute […]

Read More

Do not trust vmstat IOwait numbers

 | June 3, 2014 |  Posted In: Benchmarks, Insight for DBAs, MySQL, Percona Cloud Tools, Percona Server for MySQL

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:

Which means: create 64 threads and hammer the database with queries as quickly as possible. As the test […]

Read More

Percona Server 5.5.37-35.1 is now available

 | June 3, 2014 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, 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 stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release […]

Read More