Please join Percona’s Senior Support Engineer, Adamo Tonete, as he presents Percona Server for MongoDB vs MongoDB Enterprise on Wednesday, September 19th, 2018, at 12:30 PM PDT (UTC-7) / 3:30 PM EDT (UTC-4). Register Now   In this webinar we will evaluate MongoDB Community, MongoDB Enterprise Advanced, and Percona Server for MongoDB side-by-side to better inform [&]

The post Upcoming Webinar Wed 9/19: Percona Server for MongoDB vs MongoDB Enterprise appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/17/webinar-percona-mongodb-enterprise/

Percona announces the release of Percona Server for MongoDB 3.6.7-1.5 on September 17, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 3.6 Community Edition. It supports MongoDB 3.6 protocols and drivers. Percona [&]

The post Percona Server for MongoDB 3.6.7-1.5 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/17/percona-server-for-mongodb-3-6-7-1-5-is-now-available/

This is the first of a two-part series on using the keyring_vault plugin with Percona Server for MySQL 5.7. The second part will walk you through on how to use Percona Xtrabackup to backup from this instance and restore to another server and set it up as a slave with keyring_vault plugin. What is the [&]

The post Using the keyring_vault Plugin with Percona Server for MySQL 5.7 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/17/using-the-keyring_vault-plugin-with-percona-server-for-mysql-5-7/

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. This week wraps up the London MySQL meetup, where there were four presentations, for the intimate yet diverse crowd. We saw representation from Oracle MySQL, MariaDB Corporation, Pythian, and Percona. Long-time organizer Ivan Zoratti has [&]

The post This Week in Data With Colin Charles 52: London MySQL Meetup appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/14/this-week-in-data-with-colin-charles-52-london-mysql-meetup/

Please join Percona’s PostgreSQL Support Technical Lead,  Avinash Vallarapu; Senior Support Engineer, Fernando Laudares; and Senior Support Engineer, Jobin Augustine, on Wednesday, October 10th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4), as they demonstrate an enterprise-grade PostgreSQL® environment built using a combination of open source tools and extensions. Register Now We [&]

The post PostgreSQL Webinar Wed Oct 10th  Enterprise-Grade PostgreSQL: Built on Open Source Tools appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/14/postgresql-webinar-wed-oct-10th-enterprise-grade-postgresql-built-on-open-source-tools/

Please join Percona’s PostgreSQL Support Technical Lead,  Avinash Vallarapu; Senior Support Engineer, Fernando Laudares; and Senior Support Engineer, Jobin Augustine, on Wednesday, October 10th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4), as they demonstrate an enterprise-grade PostgreSQL® environment built using a combination of open source tools and extensions. Register Now We [&]

The post PostgreSQL Webinar Wed Oct 10th  Enterprise-Grade PostgreSQL: Built on Open Source Tools appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/14/postgresql-webinar-wed-oct-10th-enterprise-grade-postgresql-built-on-open-source-tools/

Please join Percona’s PostgreSQL Support Technical Lead,  Avinash Vallarapu; Senior Support Engineer, Fernando Laudares; and Senior Support Engineer, Jobin Augustine, on Wednesday, October 10th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4), as they demonstrate an enterprise-grade PostgreSQL® environment built using a combination of open source tools and extensions. Register Now We [&]

The post PostgreSQL Webinar Wed Oct 10th  Enterprise-Grade PostgreSQL: Built on Open Source Tools appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/14/postgresql-webinar-wed-oct-10th-enterprise-grade-postgresql-built-on-open-source-tools/

Please join Percona’s PostgreSQL Support Technical Lead,  Avinash Vallarapu; Senior Support Engineer, Fernando Laudares; and Senior Support Engineer, Jobin Augustine, on Wednesday, October 10th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4), as they demonstrate an enterprise-grade PostgreSQL® environment built using a combination of open source tools and extensions. Register Now We [&]

The post PostgreSQL Webinar Wed Oct 10th  Enterprise-Grade PostgreSQL: Built on Open Source Tools appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/14/postgresql-webinar-wed-oct-10th-enterprise-grade-postgresql-built-on-open-source-tools/

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 [&]

The post Encryption of the InnoDB System Tablespace and Parallel Doublewrite Buffer appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/14/encryption-innodb-system-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 [&]

The post Encryption of the InnoDB System Tablespace and Parallel Doublewrite Buffer appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/14/encryption-innodb-system-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 [&]

The post Encryption of the InnoDB System Tablespace and Parallel Doublewrite Buffer appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/14/encryption-innodb-system-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 [&]

The post Encryption of the InnoDB System Tablespace and Parallel Doublewrite Buffer appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/14/encryption-innodb-system-tablespace-parallel-doublewrite-buffer/

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, [&]

The post Percona Toolkit 3.0.12 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/13/percona-toolkit-3-0-12-is-now-available/

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, well focus specially on analyzing slow logs from Amazon [&]

The post Analyzing Amazon Aurora Slow Logs with pt-query-digest appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/13/analyzing-amazon-aurora-slow-logs-pt-query-digest/

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 [&]

The post Percona Server for MySQL 5.7.23-23 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/12/percona-server-for-mysql-5-7-23-23-is-now-available/

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 [&]

The post Announcement: Experimental Build of Percona XtraBackup 8.0 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/12/announcement-experimental-build-of-percona-xtrabackup-8-0/

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 Heres how: 1. Click on the “Add a Linode” and pick a Linode type you want to deploy. 2. Click on [&]

The post How To Deploy PMM on Linode With StackScripts appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/11/how-to-deploy-pmm-on-linode-with-stackscripts/

Its 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 dont offer the option to connect to MySQL directly over IPv6 (sometimes even if passing a hostname). We can workaround this by using ProxySQLs IPv6 support which [&]

The post Using ProxySQL to connect to IPv6-only databases over IPv4 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/10/using-proxysql-to-connect-to-ipv6-only-databases-over-ipv4/

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. Were releasing hotfix 1.14.1 to address two [&]

The post Percona Monitoring and Management (PMM) 1.14.1 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/08/percona-monitoring-and-management-pmm-1-14-1-is-now-available/

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. Were releasing hotfix 1.14.1 to address three [&]

The post Percona Monitoring and Management (PMM) 1.14.1 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/08/percona-monitoring-and-management-pmm-1-14-1-is-now-available/