Buy Percona ServicesBuy Now!

Analyzing Amazon Aurora Slow Logs with pt-query-digest

 | September 13, 2018 |  Posted In: Amazon Aurora, Amazon RDS, AWS, MySQL, Percona Toolkit, Performance Tuning

Amazon Aurora MySQL slow query logs with pt-query-digest slow

In this blog post we shall discuss how you can analyze slow query logs from Amazon Aurora for MySQL, (referred to as Amazon Aurora in the remaining blog). The tools and techniques explained here apply to the other MySQL compatible services available under Amazon Aurora. However, we’ll focus specially on analyzing slow logs from Amazon […]

Read More

Upcoming Webinar Tues 9/11: Migrating to AWS Aurora: A Checklist for Success

 | September 7, 2018 |  Posted In: Amazon Aurora, AWS, Insight for DBAs, MySQL, Technical Webinars

Migrating to AWS Aurora: A Checklist for Success

Please join Percona’s Senior Consultant, Jervin Real, as he presents Migrating to AWS Aurora: A Checklist for Success. The event will take place on Tuesday, September 11th, 2018, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now   In the last few weeks, we have shown you how to successfully migrate from […]

Read More

This Week in Data with Colin Charles 49: MongoDB Conference Opportunities and Serverless Aurora MySQL

 | August 17, 2018 |  Posted In: Amazon Aurora, Events and Announcements, MariaDB, MongoDB, MySQL

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Beyond the MongoDB content that will be at Percona Live Europe 2018, there is also a bit of an agenda for MongoDB Europe 2018, happening on November 8 in London—a day after Percona Live in […]

Read More

Webinar Thursday Aug 9: Migrating to AWS Aurora, Monitoring AWS Aurora with PMM

 | August 9, 2018 |  Posted In: Amazon Aurora, AWS, Events and Announcements, MySQL, Percona Monitoring and Management, PMM, Technical Webinars

Monitoring Amazon Aurora with PMM

Please join Autodesk’s Senior Database Engineer, Vineet Khanna, and Percona’s Sr. MySQL DBA, Tate McDaniel as they present Migrating to Aurora and Monitoring with PMM on Thursday, August 9th, 2018, at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now Amazon Web Services (AWS) Aurora is one of the most popular cloud-based RDBMS […]

Read More

Webinar Wednesday, August 1, 2018: Migrating to AWS Aurora, Monitoring AWS Aurora with PMM

 | July 31, 2018 |  Posted In: Amazon Aurora, AWS, MySQL, Technical Webinars

Migrating to AWS Aurora

Please join Autodesk’s Senior DevOps Engineer, Sanjeet Deshpande, Autodesk’s Senior Database Engineer, Vineet Khanna, and Percona’s Sr. MySQL DBA, Tate McDaniel as they present Migrating to AWS Aurora, Monitoring AWS Aurora with PMM on Wednesday, August 1st, 2018, at 5:00 PM PDT (UTC-7) / 8:00 PM EDT (UTC-4). Amazon Web Services (AWS) Aurora is one […]

Read More

When Should I Use Amazon Aurora and When Should I use RDS MySQL?

 | July 17, 2018 |  Posted In: Amazon Aurora, Amazon RDS, AWS, Cloud and MySQL, Insight for DBAs, MySQL, MySQL DBaaS, ProxySQL

Now that Database-as-a-service (DBaaS) is in high demand, there is one question regarding AWS services that cannot always be answered easily : When should I use Aurora and when RDS MySQL? DBaaS cloud services allow users to use databases without configuring physical hardware and infrastructure, and without installing software. I’m not sure if there is […]

Read More

How to Set Up Replication Between AWS Aurora and an External MySQL Instance

 | July 4, 2018 |  Posted In: Amazon Aurora, Amazon RDS, Insight for DBAs, MySQL, Replication

Amazon RDS Aurora replication to external server

Amazon RDS Aurora (MySQL) provides its own low latency replication. Nevertheless, there are cases where it can be beneficial to set up replication from Aurora to an external MySQL server, as Amazon RDS Aurora is based on MySQL and supports native MySQL replication. Here are some examples of when replicating from Amazon RDS Aurora to […]

Read More

This Week in Data with Colin Charles 42: Security Focus on Redis and Docker a Timely Reminder to Stay Alert

 | June 15, 2018 |  Posted In: Amazon Aurora, Events and Announcements, MySQL, MySQL 8.0, Security

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Much of last week, there was a lot of talk around this article: New research shows 75% of ‘open’ Redis servers infected. It turns out, it helps that one should always read beyond the headlines […]

Read More

Using gh-ost with Amazon Aurora for MySQL

 | June 7, 2018 |  Posted In: Amazon Aurora, Cloud and MySQL

gh-ost online schema change

In this day and age of agile methodologies and fast-paced development methods, database schema changes are as inevitable as the growth of data. We have been thoroughly familiar with the effectivity of pt-online-schema-change for the last couple of years but it has one limitation. If the table is too hot to acquire metadata locks to […]

Read More

This Week in Data with Colin Charles 39: a valuable time spent at rootconf.in

 | May 11, 2018 |  Posted In: Amazon Aurora, Amazon RDS, AWS, Events and Announcements, MyRocks, MySQL, MySQL 8.0, Percona Live

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. rootconf.in 2018 just ended, and it was very enjoyable to be in Bangalore for the conference. The audience was large, the conversations were great, and overall I think this is a rather important conference if you’re […]

Read More