Monthly Archives - May 2014

High Availability with MySQL Fabric: Part II

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 recently. You can read the press release here, and see this blog post from […]

Read more

Introducing Partitioned Collections for MongoDB Applications

TokuMX 1.5 is around the corner. The big feature will be something we discussed briefly when talking about replication changes in 1.4: partitioned collections.
Before introducing the feature, I wanted to mention the following. Although TokuMX 1.5 is not available as of this writing, we would love to hear feedback on partitioned collections, which we […]

Read more

How MySQL ‘queries’ and ‘questions’ are measured

MySQL has status variables “questions” and “queries” which are rather close but also a bit different, making it confusing for many people. The manual describing it might not be very easy to understand:

Shell

Queries

The number of statements executed by the server. This variable includes statements executed within stored programs, unlike the Questions variable. It does […]

Read more

From zero to full visibility of MySQL in 3 minutes with Percona Cloud Tools

First, I would like to invite you to my webinar, “Monitoring All (Yes, All!) MySQL Metrics with Percona Cloud Tools,” on Wednesday, June 25 at 10 a.m. Pacific Daylight Time, where I will talk on the
new features in Percona Cloud Tools, including monitoring capabilities.
In this post I’d like to show the cool and interesting […]

Read more

Location for InnoDB tablespace in MySQL 5.6.6

There is one new feature in MySQL 5.6 that didn’t get the attention it deserved (at least from me 😉 ) : “DATA DIRECTORY” for InnoDB tables.
This is implemented since MySQL 5.6.6 and can be used only at the creation of the table. It’s not possible to change the DATA DIRECTORY with an ALTER […]

Read more

Installing Percona XtraDB Cluster 5.6 with the Docker open-source engine

In my previous post, I blogged about using Percona Server with Docker and have shown you how fast and easy it was to create a virtual environment with just a few commands.
This time I will be showing you how to setup a three-node Percona XtraDB Cluster (PXC) 5.6 on the Docker open-source engine. Just […]

Read more

Introducing the 3-Minute MySQL Monitor

There are many cool, new things happening with Percona Cloud Tools.  To avoid “tl;dr” I will highlight only one new feature after a brief, general announcement.  The new feature is a 3-minute MySQL monitor.  I’ll blog later about other features.
The general announcement is: Last week we quietly released a brand-new agent called percona-agent, and we added MySQL and […]

Read more

How to improve InnoDB performance by 55% for write-bound loads

Update: do not do this, this has been proven to corrupt data!
 
During April’s Percona Live MySQL Conference and Expo 2014, I attended a talk on MySQL 5.7 performance an scalability given by Dimitri Kravtchuk, the Oracle MySQL benchmark specialist. He mentioned at some point that the InnoDB double write buffer was a real performance […]

Read more

TokuMX Compared to MongoDB Using a Specific Common Use Case

Former AOL chief database architect, now independent database consultant, John Schulz guest blogs about his experience with basic MongoDB (from MongoDB, Inc.) and TokuMX™.  If you’d like to speak with John about your own big data challenges you can contact him via email at john_schulz at aol dot com.
Before leaving AOL to start my […]

Read more

May 29 Webinar: Get More Out of MongoDB with TokuMX

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 specialized tuning just by replacing the storage stack?
Register Now!
SPEAKER: Tim Callaghan, VP of Engineering
DATE: Thursday, May 29th
TIME: 1pm EDT/10am PDT
Join this […]

Read more