Buy Percona ServicesBuy Now!

Improving Percona XtraDB Cluster SST startup with Google Compute Engine snapshots

 | March 3, 2015 |  Posted In: Cloud and MySQL, MySQL, Percona XtraDB Cluster

As the need for information grows so does the size of data we need to keep in our databases. SST is unavoidable for spinning up new nodes in a PXC cluster and when datasets reach the “terra-byte” range this becomes ever more cumbersome requiring many hours for a new node to synchronize. More often that not, […]

Read More

Google Compute Engine adds Percona XtraDB Cluster to click-to-deploy process

 | November 21, 2014 |  Posted In: Cloud and MySQL, MySQL, MySQL DBaaS, Percona XtraDB Cluster

I’m happy to announce that Google has added Click-to-deploy functionality for Percona XtraDB Cluster (PXC) on Google Cloud Compute nodes. This gives you the ability to rapidly spin up a cluster for experimentation, performance testing, or even production use on Google Compute Engine virtual machines. What is Percona XtraDB Cluster? Percona XtraDB Cluster is a […]

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

Amazon Web Services and HP Keynotes at Percona Live MySQL Conference and Expo

 | February 14, 2013 |  Posted In: Cloud and MySQL, Cloud and NoSQL, Events and Announcements, MySQL, Percona Live

We are very pleased to announce the addition of HP and Amazon Web Services as keynote speakers for the Percona Live MySQL Conference and Expo which is April 22-25 in Santa Clara, California. Amazon Web Services is sending Simone Brunozzi, Senior Technology Evangelist, who will speak on “Databases in the Cloud: Present and Future.” HP […]

Read More