Buy Percona ServicesBuy Now!

Binlog Encryption with Percona Server for MySQL

 | March 8, 2018 |  Posted In: Database Monitoring, Insight for DBAs, MySQL, Percona Server for MySQL, Security

binlog encryption

In this blog post, we’ll look at how to turn on binlog encryption in Percona Server for MySQL. Why do I need this? As you probably know, Percona Server for MySQL’s binlog contains sensitive information. Replication uses the binlog to copy events between servers. They contain all the information from one server so that it can […]

Read More

Percona Live 2018 Featured Talk: Securing Your Data on PostgreSQL with Payal Singh

 | March 7, 2018 |  Posted In: Percona Live, PostgreSQL, Security

Payal PostgreSQL 1

Welcome to another interview blog for the rapidly-approaching Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog post highlights Payal Singh, DBA at OmniTI Computer Consulting Inc. Her talk is […]

Read More

Webinar Thursday March 1, 2018: Performance Schema for MySQL Troubleshooting

 | February 28, 2018 |  Posted In: Insight for DBAs, MySQL, Performance Schema, Technical Webinars

Performance Schema for MySQL Troubleshooting

Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents Performance Schema for MySQL Troubleshooting on Thursday, March 1, 2018, at 10:00 am PST (UTC-8) / 1:00 pm EST (UTC-5). Register Now Performance Schema, first introduced in version 5.5, is a really powerful tool. It is actively under development, and each new version provides […]

Read More

Analyze Your Raw MySQL Query Logs with ClickHouse

 | February 28, 2018 |  Posted In: Database Monitoring, Insight for DBAs, MySQL, Yandex ClickHouse

In this blog post, I’ll look at how you can analyze raw MySQL query logs with ClickHouse. For typical query performance analyses, we have an excellent tool in Percona Monitoring and Management. You may want to go deeper, though. You might be longing for the ability to query raw MySQL “slow” query logs with SQL. […]

Read More

Percona Monitoring and Management 1.8.0 Is Now Available

 | February 27, 2018 |  Posted In: Events and Announcements, MySQL, Percona Monitoring and Management, PMM

Percona Monitoring and Management

The latest release of Percona Monitoring and Management (PMM) 1.8.0 is available as of February 27, 2018. Percona Monitoring and Management is a free and open-source platform for managing and monitoring MySQL and MongoDB performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL and MongoDB servers to ensure that your data works as efficiently […]

Read More

Percona Live 2018 Open Source Database Conference Full Schedule Now Available

 | February 21, 2018 |  Posted In: Amazon Aurora, Amazon RDS, AWS, MariaDB, MongoDB, MySQL, Percona Live

Percona Live 2018 Keynotes

The conference session schedule for the seventh annual Percona Live 2018 Open Source Database Conference, taking place April 23-25 at the Santa Clara Convention Center in Santa Clara, CA is now live and available for review! Advance Registration Discounts can be purchased through March 4, 2018, 11:30 p.m. PST. Percona Live Open Source Database Conference […]

Read More

Amazon Aurora MySQL Monitoring with Percona Monitoring and Management (PMM)

 | February 14, 2018 |  Posted In: MySQL

Amazon Aurora MySQL Monitoring small

In this blog post, we’ll review additional Amazon Aurora MySQL monitoring capabilities we’ve added in Percona Monitoring and Management (PMM) 1.7.0. You can see them in action in the MySQL Amazon Aurora Metrics dashboard. Amazon Aurora MySQL Transaction Commits This graph looks at the number of commits the Amazon Aurora engine performed, as well as the […]

Read More

Tutorial Schedule for Percona Live 2018 Is Live

 | February 8, 2018 |  Posted In: AWS, Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, Percona Live

Percona Live 2018 Keynotes

Percona has revealed the line-up of in-depth tutorials for the Percona Live 2018 Open Source Database Conference, taking place April 23-25, 2018 at the Santa Clara Convention Center in Santa Clara, Calif. Secure your spot now with Advanced Registration prices (available until March 4, 2018). Sponsorship opportunities for the conference are still available. Percona Live 2018 […]

Read More

ProxySQL Query Cache: What It Is, How It Works

 | February 7, 2018 |  Posted In: Insight for DBAs, MySQL, ProxySQL

ProxySQL query cache

In this blog post, I’ll present the ProxySQL query cache functionality. This is a query caching mechanism on top of ProxySQL. As there are already many how-tos regarding the ProxySQL prerequisites and installation process, we are going to skip these steps. For those who are already familiar with ProxySQL query cache configuration, let’s go directly […]

Read More

Announcing Experimental Percona Monitoring and Management (PMM) Functionality via Percona Labs

 | February 6, 2018 |  Posted In: Database Monitoring, MySQL, open source databases, Percona Monitoring and Management

Percona Monitoring and Management

In this blog post, we’ll introduce how you can look at some experimental Percona Monitoring and Management (PMM) features using Percona Labs builds on GitHub. Note: PerconaLabs and Percona-QA are open source GitHub repositories for unofficial scripts and tools created by Percona staff. While not covered by Percona support or services agreements, these handy utilities […]

Read More