Buy Percona ServicesBuy Now!

Encryption of the InnoDB System Tablespace and Parallel Doublewrite Buffer

 | September 14, 2018 |  Posted In: MySQL, Percona Server for MySQL, Security

encryption of InnoDB tablespace parallel doublewrite buffer

In my last post I compared data at-rest encryption features available for MySQL and MariaDB. As noted at the time, some of the features available for Percona Server for MySQL were in development, and the latest version (5.7.23) sees two of them released as ALPHA quality. Encrypting the InnoDB system tablespace The first of the […]

Read More

Percona Toolkit 3.0.12 Is Now Available

 | September 13, 2018 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL, Percona Server for MongoDB, Percona Server for MySQL, Percona Toolkit

percona toolkit

Percona announces the release of Percona Toolkit 3.0.12 on September 13, 2018. Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL®, MongoDB® and system tasks that are too difficult or complex to perform manually. With over 1,000,000 downloads, […]

Read More

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

Percona Server for MySQL 5.7.23-23 Is Now Available

and  | September 12, 2018 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software

Percona Server for MySQL 5.6

Percona announces the release of Percona Server for MySQL 5.7.23-23 on September 12, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.23, including all the bug fixes in it. Percona Server for MySQL 5.7.23-23 is now the current GA release in the 5.7 series. All of Percona’s software is […]

Read More

Announcement: Experimental Build of Percona XtraBackup 8.0

 | September 12, 2018 |  Posted In: Backups, InnoDB, MySQL, MySQL 8.0, Percona Server for MySQL, Percona XtraBackup

Percona XtraBackup 8.0

Experimental Build of Percona XtraBackup 8.0 released An experimental alpha version of Percona XtraBackup 8.0.1 is now available in the Percona experimental software repositories. A few things to note about this release: We removed the deprecated innobackupex in this release Due to the new MySQL redo log and data dictionary formats the Percona XtraBackup 8.0.x versions […]

Read More

How To Deploy PMM on Linode With StackScripts

 | September 11, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Percona Monitoring and Management, PMM

rebuiild from a StackScript

In my previous blog post, I showed how to deploy Percona Monitoring and Management (PMM) on Linode manually. It is pretty simple, but with a little coding it can be done even more easily using StackScripts Here’s how: 1. Click on the “Add a Linode” and pick a Linode type you want to deploy. 2. Click on […]

Read More

Using ProxySQL to connect to IPv6-only databases over IPv4

 | September 10, 2018 |  Posted In: MySQL, Percona Server for MySQL, Percona XtraDB Cluster, ProxySQL, Security

connect to ipv6 database from ipv4 application using proxysql

It’s 2018. Maybe now is the time to start migrating your network to IPv6, and your database infrastructure is a great place to start. Unfortunately, many legacy applications don’t offer the option to connect to MySQL directly over IPv6 (sometimes even if passing a hostname). We can work around this by using ProxySQL’s IPv6 support […]

Read More

Percona Monitoring and Management (PMM) 1.14.1 Is Now Available

 | September 8, 2018 |  Posted In: Amazon RDS, AWS, Database Monitoring, Events and Announcements, MongoDB, MySQL, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL, PMM

Percona Monitoring and Management

Percona Monitoring and Management (PMM) 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 as possible. We’re releasing hotfix 1.14.1 to address two […]

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

Percona Monitoring and Management (PMM) 1.14.0 Is Now Available

 | September 5, 2018 |  Posted In: Amazon RDS, AWS, Database Monitoring, Events and Announcements, MongoDB, MySQL, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL, PMM

Percona Monitoring and Management

Percona Monitoring and Management (PMM) 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 as possible.  We’ve included a plethora of visual improvements in this release, including: PostgreSQL Metrics […]

Read More