EmergencyEMERGENCY? Get 24/7 Help Now!

Keep your MySQL data in sync when using Tungsten Replicator

 | May 4, 2015 |  Posted In: Insight for DBAs, MariaDB, MySQL, MySQL 101

MySQL replication isn’t perfect and sometimes our data gets out of sync, either by a failure in replication or human intervention. We are all familiar with Percona Toolkit’s pt-table-checksum and pt-table-sync to help us check and fix data inconsistencies – but imagine the following scenario where we mix regular replication with the Tungsten Replicator: We […]

Read More

Optimizer hints in MySQL 5.7.7 – The missed manual

 | April 30, 2015 |  Posted In: EXPLAIN, Insight for DBAs, MySQL, Percona Live, query tuning

In version MySQL 5.7.7 Oracle presented a new promising feature: optimizer hints. However it did not publish any documentation about the hints. The only note which I found in the user manual about the hints is: It is now possible to provide hints to the optimizer by including /*+ … */ comments following the SELECT, […]

Read More

Test your knowledge: Percona XtraDB Cluster (PXC) quiz

 | April 28, 2015 |  Posted In: High-availability, Insight for DBAs, MySQL, Percona XtraDB Cluster

I often talk with people who are very interested in the features of Percona XtraDB Cluster (PXC) such as synchronous and parallel replication, multi-node writing and high availability. However some get confused when operating a real PXC cluster because they do not fully realize the implications of these features. So here is a fun way […]

Read More

Considering Sharding with MySQL? Join my April 22 webinar. Questions welcome!

 | April 21, 2015 |  Posted In: Insight for DBAs, MySQL, MySQL Webinars

MySQL sharding is one of the most used and surely the most abused MySQL scaling technology. My April 2 Dzone article, “To Shard, or Not to Shard,” proved there is indeed quite an interest in this topic. As such, I’m hosting a live webinar tomorrow (April 22) that will shed light on questions about sharding with […]

Read More

Staying ahead of MySQL operational problems at Percona Live

 | April 13, 2015 |  Posted In: Insight for DBAs, MySQL, MySQL 101, Percona Live, Percona Toolkit

I’ve started my long journey from Florianópolis, Brazil, to Santa Clara, California and I type this words while waiting for a connection flight. Next Wednesday, Daniel Guzmán Burgos and I will be presenting in the Percona Live MySQL Conference and Expo (PLMCE). I’m so excited with the new MySQL 101 program that has been added […]

Read More

pquery binaries with statically included client libs now available!

 | April 9, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

After we released pquery to the community, and as we started logging bug reports with pquery testcases, it quickly became clear that pquery binaries with statically compiled-in client libraries would be of great convenience, both for ourselves and for the community. (If you haven’t heard about pquery yet, read the pquery introduction blog post, come and […]

Read More

MySQL QA Episode 1: Bash/GNU Tools & Linux Upskill & Scripting Fun

 | March 17, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Percona MySQL Training, Quality Assurance

MySQL QA Episode 1

MySQL QA Episode #1: Bash/GNU Tools & Linux Upskill & Scripting Fun This episode consists of 13 parts, and an introduction. See videos below In HD quality (set your player to 720p!) Introduction Part 1: echo, ls, cp, rm, vi, cat, df, du, tee, cd, clear, uname, date, time, cat, mkdir Part 2: find, wc, sort, […]

Read More

Free MySQL QA & Bash/Linux Training Series

 | March 17, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Percona MySQL Training, Quality Assurance

MySQL QA

Welcome to the MySQL QA Training Series! If you have not read our introductory blog post on pquery yet, I’d recommend reading that one first to get a bit of background. The community is enthuastic about pquery, and today I am happy to announce a full training series on pquery and more. Whether you are […]

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.