Tag: MySQL

MySQL Query Profiling with Performance Schema

One of my favorite tools for query optimization is profiling. But recently I noticed this warning: After looking through certain documentation , I should indeed start using the Performance Schema to get this information. Okay, so let’s give that a try….

Read More >

MySQL Sounds Like Fun

I love finding out new things about MySQL. Last week, I stumbled on a query that had the phrase “SOUNDS LIKE” in it. Sounds made-up, right? Turns out MySQL is using a known “soundex” algorithm common to most databases, and…

Read More >

Detecting Source of MySQL Queries with Comments

As a MySQL DBA I already know the data changes that happen on my system. I have logs for that. However, it’s a common problem that several years into the life of an application, the current developers won’t know where…

Read More >

Pythian at Percona Live London 2014

Percona Live London takes place next week from November 3-4 where Pythian is a platinum sponsor—visit us at our booth during the day on Tuesday, or at the reception in the evening. Not only are we attending, but we’re taking part in…

Read More >

MariaDB 10.0 Multi-source Replication at Percona Live UK 2014

Percona Live UK is upon us and I have the privilege to present a tutorial on setting up multi-source replication in MariaDB 10.0 on Nov 3, 2014. If you’re joining me at PLUK14, we will go over setting up two…

Read More >

MySQL: Troubleshooting an Instance for Beginners

So as you may know, my new position involves the MySQL world, so I’m in the task of picking up the language and whereabouts of this DBMS, and my teamate Alkin Tezuysal (@ask_dba on Twitter) has a very cool break and…

Read More >

Benchmark: TokuDB vs. MariaDB / MySQL InnoDB Compression

As the amount of data companies are interested in collecting grows, life becomes all the more difficult for IT staff at all levels within an organization. SAS Enterprise storage devices that were once considered giants are now being phased out in favor…

Read More >

Tungsten Replicator: MariaDB Master-Master and Master-Slave Topologies

A common concern in the MySQL community is how to best implement high availability for MySQL. There are various built-in mechanisms to accomplish this such as Master/Master and Master/Slave replication using binary logs as well as FOSS solutions such as Galera…

Read More >

Building a MariaDB Galera Cluster with Docker

There’s been a lot of talk about Docker for running processes in isolated userspace (or the cloud for that matter) lately. Virtualization is a great way to compartmentalise applications  and processes however the overhead of virtualization isn’t always worth it…

Read More >

Critical MySQL 5.6 bug: GRANTs and replication

Critical MySQL 5.6 bug: any user with GRANT privileges can unwillingly cause all replicas to break The latest major release of MySQL brought us a lot of new and exciting features. As always, new features come with brand new bugs…

Read More >