EmergencyEMERGENCY? Get 24/7 Help Now!

High Availability with MySQL Fabric: Part II

and  | May 30, 2014 |  Posted In: High-availability, 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 recently. You can read the press release here, and see this blog post from Oracle’s Mats […]

Read More

How MySQL ‘queries’ and ‘questions’ are measured

 | May 29, 2014 |  Posted In: Insight for DBAs, MySQL

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:

In a nutshell if you’re not using prepared statements the big difference between those is what “Questions” would count stored procedure calls as […]

Read More

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

 | May 28, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Cloud Tools, Percona Software

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 […]

Read More

Introducing the 3-Minute MySQL Monitor

 | May 23, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Cloud Tools

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

 | May 23, 2014 |  Posted In: Benchmarks, Hardware and Storage, Insight for DBAs, MySQL, Percona Live

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 […]

Read More

TokuMX Compared to MongoDB Using a Specific Common Use Case

 | May 22, 2014 |  Posted In: Tokutek, TokuView

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

 | May 22, 2014 |  Posted In: Tokutek, TokuView

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 […]

Read More