EmergencyEMERGENCY? Get 24/7 Help Now!

Using MySQL triggers and views in Amazon RDS

 | July 2, 2014 |  Posted In: Cloud and MySQL, Cloud and NoSQL, Insight for DBAs, MySQL

I recently had an opportunity to migrate a customer from a physical server into Amazon’s RDS environment. In this particular case the customers’ platform makes extensive use of MySQL triggers and views.  I came across two significant issues that prevented me from following Amazon’s documentation, which basically states “use mysqldump” but doesn’t call out a […]

Read More

Seconds_Behind_Master fluctuating wildly? Check for events caught in a loop

 | December 13, 2013 |  Posted In: Insight for DBAs, MySQL, Percona MySQL Consulting

Recently I was working with a customer where we noticed that Seconds_Behind_Master fluctuating from an expected value of 0 seconds behind to a fairly high six figure value.  The servers were configured in a master-master relationship and used 5 figure server_id values, and we had just migrated this cluster from one data centre to another […]

Read More

Recovering from a bad UPDATE statement

 | October 19, 2012 |  Posted In: Insight for DBAs, Insight for Developers, MySQL

Did you just run an UPDATE against your 10 million row users table without a WHERE clause?  Did you know that in MySQL 5.5 that sometimes you can recover from a bad UPDATE statement?  This is possible if you are running in binlog_format=ROW ! Imagine this scenario:

We run an accidental UPDATE statement that […]

Read More

Data compression in InnoDB for text and blob fields

 | May 30, 2012 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Percona Software

Have you wanted to compress only certain types of columns in a table while leaving other columns uncompressed? While working on a customer case this week I saw an interesting problem where a table had many heavily utilized TEXT fields with some read queries exceeding 500MB (!!), and stored in a 100GB table. In this […]

Read More