EmergencyEMERGENCY? Get 24/7 Help Now!

Enabling crash-safe slaves with MySQL 5.6

 | September 13, 2013 |  Posted In: Insight for DBAs, MySQL

Being able to configure slaves to be crash-safe is one of the major improvements of MySQL 5.6 with regards to replication. However we noticed confusion on how to enable this feature correctly, so let’s clarify how it should be done. In short 1. Stop MySQL on slave 2. Add relay_log_info_repository = TABLE and relay_log_recovery = […]

Read More

TokuDB Hot Backup – Part 1

 | September 12, 2013 |  Posted In: Tokutek, TokuView

There are multiple ways to backup a MySQL database. Some are more painful than others. In this two part blog we are going to discuss why the new hot backup system in TokuDB is special amidst the existing solutions. First let’s look at existing backup solutions for MySQL and InnoDB. Let’s start with the most […]

Read More

MySQL webinar: ‘Introduction to open source column stores’

 | September 12, 2013 |  Posted In: MySQL, MySQL Webinars

Join me Wednesday, September 18 at 10 a.m. PDT for an hour-long webinar where I will introduce the basic concepts behind column store technology. The webinar’s title is: “Introduction to open source column stores.” What will be discussed? This webinar will talk about Infobright, LucidDB, MonetDB, Hadoop (Impala) and other column stores I will compare […]

Read More

TokuMX vs. MongoDB : In-Memory Sysbench Performance

 | September 10, 2013 |  Posted In: Tokutek, TokuView

In talking to existing MongoDB users and TokuMX evaluators, I’ve often heard that the performance of MongoDB is very good as long as your working data set fits in RAM. The story continues that if your working data set grows to be larger than the RAM on your server, the built-in sharding capabilities of MongoDB […]

Read More

How InnoDB promotes UNIQUE constraints

 | September 10, 2013 |  Posted In: Insight for DBAs, Insight for Developers, MySQL

The other day I was running pt-duplicate-key-checker on behalf of a customer and noticed some peculiar recommendations on an InnoDB table with an odd structure (no PRIMARY key, but multiple UNIQUE constraints). This got me thinking about how InnoDB promotes UNIQUE constraints to the role of PRIMARY KEYs. The documentation is pretty clear: [DOCS] When […]

Read More

Introduction to Percona XtraBackup 2.1 (MySQL webinar & more)

 | September 6, 2013 |  Posted In: MySQL Webinars, Percona Server, Percona XtraBackup, xtrabackup

Percona XtraBackup 2.1 has been in GA now for a little over four months and has some impressive new features to improve backup performance, security, and storage requirements. When used with Percona Server, additional features are enabled that can provide even more dramatic performance improvements. Percona XtraBackup is open source, free MySQL hot backup software […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.