Buy Percona ServicesBuy Now!

How to Enable Amazon RDS Remote Access

 | May 8, 2018 |  Posted In: Amazon RDS, AWS, Insight for DBAs

Amazon RDS remote access

It’s easy to enable Amazon RDS remote access when launching an Amazon RDS instance, but there can be many issues. I created this blog as a guide describing the various issues/configurations we might encounter. As the first step, we need to select a VPC where we will launch our Amazon RDS instance. The default VPC […]

Read More

Webinar Wednesday, May 9, 2018: MySQL Troubleshooting and Performance Optimization with Percona Monitoring and Management (PMM)

 | May 7, 2018 |  Posted In: Insight for DBAs, Percona Monitoring and Management, Technical Webinars

MySQL Troubleshooting

Please join Percona’s CEO, Peter Zaitsev as he presents MySQL Troubleshooting and Performance Optimization with PMM on Wednesday, May 9, 2018, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBAs. The databases powering your applications […]

Read More

How Binary Logs (and Filesystems) Affect MySQL Performance

 | May 4, 2018 |  Posted In: Benchmarks, InnoDB, Insight for DBAs, MySQL, MySQL 8.0

I want to take a closer look at MySQL performance with binary logs enabled on different filesystems, especially as MySQL 8.0 comes with binary logs enabled by default. As part of my benchmarks of the MyRocks storage engine, I’ve noticed an unusual variance in throughput for the InnoDB storage engine, even though we spent a […]

Read More

Percona Live 2018 Community Report

 | May 4, 2018 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL, open source databases, Percona Live, PostgreSQL

So, after a whirlwind few days, Percona Live 2018 has been and gone. There was a great energy about the conference, and it was fantastic to meet so many open source database enthusiasts and supporters. A few things that I experienced: Your great willingness to share knowledge. It was a fantastic place to learn for […]

Read More

Q&A: “Percona XtraDB Cluster 5.7 and ProxySQL for Your High Availability Needs” Webinar

and  | May 3, 2018 |  Posted In: MySQL, Percona XtraDB Cluster, Technical Webinars

High Availability

On March 22, 2018, we held a webinar on how Percona XtraDB cluster 5.7 (PXC) and ProxySQL can help achieve your database clustering high availability needs. Firstly, thanks to all the attendees for taking time to attend the webinar and we are sure you had a webinar experience. We tried answering some of your high […]

Read More

Causes and Workarounds for Slave Performance Too Slow with Row-Based Events

 | May 3, 2018 |  Posted In: High-availability, Insight for DBAs, MySQL, Replication

Slave Performance Too Slow

Recently I worked on one customer issue that I would describe as “slave performance too slow”. During a quick analysis, I’ve found that the replication slave SQL thread cannot keep up while processing row-based events from the master’s binary log. For example:

The processlist state for the SQL thread can be one of the following: Reading […]

Read More