EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Live 2016 Call for Papers Open! Introducing: Community Voting

 | October 20, 2015 |  Posted In: Cloud and MySQL, Cloud and NoSQL, Events and Announcements, MongoDB, MySQL

The Call for Papers for the fifth annual Percona Live Data Performance Conference and Expo (formerly MySQL Conference and Expo) taking place April 18-21, 2016, in Santa Clara, California, is now officially open! Ask yourself… “Do I have…” Fresh ideas? Enlightening case studies? Insight on best practices? In-depth technical knowlege? If the answer to any of these is “YES,” then you […]

Read More

5 great new features from Percona Cloud Tools for MySQL

 | August 19, 2014 |  Posted In: Cloud and NoSQL, Insight for DBAs, MySQL, Percona Cloud Tools

It’s been three months since we announced anything for Percona Cloud Tools, not because we’ve been idle but because we’ve been so busy the time flew by!  Here’s the TL;DR to pique your interest: EXPLAIN queries in real-time through the web app Query Analytics for Performance Schema Dashboards: customizable, shared groups of charts Install and […]

Read More

What I learned while migrating a customer MySQL installation to Amazon RDS

 | July 28, 2014 |  Posted In: Cloud and MySQL, Cloud and NoSQL, Insight for DBAs, MySQL, Percona MySQL Consulting, Percona MySQL Support

Hi, I recently had the experience of assisting with a migration of a customer MySQL installation to Amazon RDS (Relational Database Service). Amazon RDS is a great platform for hosting your MySQL installation and offers the following list of pros and cons: You can scale your CPU, IOPS, and storage space separately by using Amazon […]

Read More

TIMESTAMP Columns, Amazon RDS 5.6, and You

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

This comes from an issue that I worked on recently, wherein a customer reported that their application was working fine under stock MySQL 5.6 but producing erroneous results when they tried running it on Amazon RDS 5.6. They had a table which, on the working server, contained two TIMESTAMP columns, one which defaulted to CURRENT_TIMESTAMP […]

Read More

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

Percona Monitoring Plugins 1.1.2, now with Amazon RDS support

 | March 14, 2014 |  Posted In: Cloud and MySQL, Cloud and NoSQL, Events and Announcements, MySQL, Percona Monitoring Plugins

Percona is glad to announce the release of Percona Monitoring Plugins 1.1.2. Changelog: * Added Nagios plugin and Cacti template for Amazon RDS * Added Nagios config template to the documentation * Added an option to pmp-check-pt-table-checksum to check MAX(ts) of latest checksum * Added generic Nagios plugin for PT tables * Extended pmp-check-mysql-processlist with […]

Read More

Running MySQL 5.6 on Amazon RDS: Webinar followup questions answered

 | September 4, 2013 |  Posted In: Cloud and MySQL, Cloud and NoSQL, MySQL, Technical Webinars

Thanks to everyone who attended last week’s webinar, Running MySQL 5.6 on Amazon RDS.” If you weren’t able to attend, the recording and slides are available for viewing/download (or, if you were able to attend and just want to see it again). I’ve also answered the questions I didn’t have a chance to field during […]

Read More

Amazon RDS with MySQL 5.6 – Configuration Variables

 | August 21, 2013 |  Posted In: Cloud and MySQL, Cloud and NoSQL, MySQL, Technical Webinars

One longstanding complaint I have heard for the past several years, and still hear today, is that Amazon’s Relational Database Service (RDS) does not allow the configuration flexibility as running MySQL in an ec2 instance. While true, this ignores the consistent work that Amazon has done to provide access to the most important configuration variables […]

Read More