EmergencyEMERGENCY? Get 24/7 Help Now!

Take Percona’s One-Click 2017 Top Database Concerns Poll

 | October 10, 2016 |  Posted In: Cloud and MySQL, Cloud and NoSQL, Database Monitoring, High-availability, MariaDB, MongoDB, MySQL

2017 top database concerns

Take Percona’s One-Click 2017 Top Database Concerns Poll. With 2017 coming quick around the corner, it’s time to start thinking about what next year is going to bring to the open source database community. We just finished Percona Live Europe 2017, and at the conference we looked at new technologies, new techniques, and new ideas. […]

Read More

Amazon RDS and pt-online-schema-change

 | July 1, 2016 |  Posted In: Cloud and MySQL, Cloud and NoSQL, MySQL

Amazon RDS and pt-online-schema-change

In this blog post, I discuss some of the insights needed when using Amazon RDS and pt-online-schema-change together. The pt-online-schema-change tool runs DDL queries (ALTER) online so that the table is not locked for reads and writes. It is a commonly used tool by community users and customers. Using it on Amazon RDS requires knowing about some specific […]

Read More

2016 Percona Live Tutorials Schedule is UP!

 | December 29, 2015 |  Posted In: Big Data, Cloud and MySQL, Cloud and NoSQL, Events and Announcements, MongoDB, Percona Live

12 Days Until Percona Live

We are excited to announce that the tutorial schedule for the Percona Live Data Performance Conference 2016 is up! The schedule shows all the details for each of our informative and enlightening Percona Live tutorial sessions, including insights into InnoDB, MySQL 5.7, MongoDB 3.2 and RocksDB. These tutorials are a must for any data performance professional! The […]

Read More

Amazon Aurora in sysbench benchmarks

 | December 3, 2015 |  Posted In: Cloud and MySQL, Cloud and NoSQL, MySQL, Percona Server

In my previous post Amazon Aurora – Looking Deeper, I promised benchmark results on Amazon Aurora. There are already some results available from Amazon itself: https://d0.awsstatic.com/product-marketing/Aurora/RDS_Aurora_Performance_Assessment_Benchmarking_v1-2.pdf. There are also some from Marco Tusa: http://www.tusacentral.net/joomla/index.php/mysql-blogs/175-aws-aurora-benchmarking-blast-or-splash.html. Amazon used quite a small dataset in their benchmark: 250 tables, with 25000 rows each, which in my calculation corresponds to 4.5GB […]

Read More

Amazon Aurora – Looking Deeper

 | November 16, 2015 |  Posted In: Cloud and MySQL, Cloud and NoSQL, MySQL

Recently my colleague (by Percona) Yves Trudeau and colleague (by industry) Marco Tusa published their materials on Amazon Aurora. Indeed, Amazon Aurora is a hot topic these days, and we have a stream of customer inquiries regarding this technology. I’ve decided to form my own opinion, and nothing is better than a personal, hands-on experience, which I […]

Read More

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