We are experiencing an intermittent commenting problem on the Percona Database Performance Blog. At Percona, part of our purpose is to engage with the open source database community. A big part of this engagement is the Percona Database Performance Blog, and the participation of the community in reading and commenting. We appreciate your interest and contributions. [&]

The post Percona Database Performance Blog Commenting Issues appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/18/percona-database-performance-blog-commenting-issues/

Please join Percona’s CEO, Peter Zaitsev as he presents MySQL: Scaling and High Availability – Production Experience Over the Last Decade(s) on Tuesday, June 19th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now   Percona is known as the MySQL performance experts. With over 4,000 customers, we’ve studied, mastered and [&]

The post Webinar Tues 19/6: MySQL: Scaling and High Availability – Production Experience from the Last Decade(s) appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/18/webinar-tues-19-6-mysql-scaling-and-high-availability/

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

The post This Week in Data with Colin Charles 42: Security Focus on Redis and Docker a Timely Reminder to Stay Alert appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/15/this-week-in-data-with-colin-charles-42/

Percona has a long tradition of performance investigation and benchmarking. Peter Zaitsev, CEO and Vadim Tkachenko, CTO, led their crew into a series of experiments with MySQL in this space. The discussion that always follows on the results achieved is well known and praised even by the PostgreSQL community. So when Avi joined the team [&]

The post Tuning PostgreSQL for sysbench-tpcc appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/15/tuning-postgresql-for-sysbench-tpcc/

If you have already deployed PMM server using Docker you might be aware that we begin by creating a special container for persistent PMM data. In this post, I aim to explain the importance of pmm-data container when you deploy PMM server with Docker. By the end of this post, you will have a fair [&]

The post Percona Monitoring and Management: Look After Your pmm-data Container appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/14/percona-monitoring-management-look-after-pmm-data/

I frequently talk to our customer base about what keeps them up at night. While there is a large variance of answers, they tend to fall into one of two categories. The first is the conditioned fear of some monster lurking behind the scenes that could pounce at any time. The second, of course, is [&]

The post What is the Top Cause of Application Downtime Today? appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/14/top-cause-of-application-downtime-today/

In this blog post, we will discuss about how to use zone based sharding to deploy a sharded MongoDB cluster in a customized manner so that the queries and data will be redirected per geographical groupings. This feature of MongoDB is a part of its Data Center Awareness, that allows queries to be routed to particular [&]

The post Zone Based Sharding in MongoDB appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/13/zone-based-sharding-in-mongodb/

Please join Percona’s Sr. Technical Operations Architect, Tim Vaillancourt as he presents MongoDB Backup and Recovery Field Guide on Thursday, June 14, 2018, at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now This talk will cover backup and recovery solutions for MongoDB replica sets and clusters, focusing on online and low-impact solutions [&]

The post Webinar Thurs 6/14: MongoDB Backup and Recovery Field Guide appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/13/webinar-thurs-6-14-mongodb-backup-and-recovery-field-guide/

Please join Percona’s CEO, Peter Zaitsev as he presents Performance Analysis and Troubleshooting Methodologies for Databases on Wednesday, June 13th, 2018 at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now   Have you heard about the USE Method (Utilization  Saturation  Errors)? RED (Rate  Errors  Duration), or Golden Signals [&]

The post Webinar Weds 6/13: Performance Analysis and Troubleshooting Methodologies for Databases appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/12/webinar-database-performance-analysis-troubleshooting-methodologies/

Let them stay together. In the last YEARS, I have seen quite often that users, when installing a product such as PXC, instead of spending five minutes to understand what to do just run [crayon-5b286a52c77b0634119669-i/]  and save. In short, they remove any rules for their firewall. With this post, I want to show you how [&]

The post PXC loves firewalls (and System Admins loves iptables) appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/12/pxc-loves-firewalls-system-admins-loves-iptables/

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Shortly after the last dispatch, I jetted off for a spot of vacation (which really meant I was checking out the hype behind Blockchain with a database developer lens at the Blockchain Week NYC), and then [&]

The post This Week in Data with Colin Charles 40: a Peak at Blockchain, Lots of MariaDB News, then Back on the Road appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/01/this-week-in-data-with-colin-charles-40/

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Shortly after the last dispatch, I jetted off for a spot of vacation (which really meant I was checking out the hype behind Blockchain with a database developer lens at the Blockchain Week NYC), and then [&]

The post This Week in Data with Colin Charles 40: a Peak at Blockchain, Lots of MariaDB News, then Back on the Road appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/01/this-week-in-data-with-colin-charles-40/

Percona announces the GA release of Percona Server for MySQL 5.7.22-22 on on May 31, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based on MySQL 5.7.22, including all the bug fixes in it, Percona Server for [&]

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

https://www.percona.com/blog/2018/05/31/percona-server-for-mysql-5-7-22-22-is-now-available/

Percona announces the GA release of Percona Server for MySQL 5.7.22-22 on on May 31, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based on MySQL 5.7.22, including all the bug fixes in it, Percona Server for [&]

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

https://www.percona.com/blog/2018/05/31/percona-server-for-mysql-5-7-22-22-is-now-available/

A data lake is “…a method of storing data within a system or repository, in its natural format, that facilitates the collocation of data in various schemata and structural forms…”1. Many companies find value in using a data lake but arent clear that they need to properly plan for it and maintain it in order [&]

The post Don’t Drown in your Data Lake appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/31/dont-drown-in-your-data-lake/

A data lake is “…a method of storing data within a system or repository, in its natural format, that facilitates the collocation of data in various schemata and structural forms…”1. Many companies find value in using a data lake but arent clear that they need to properly plan for it and maintain it in order [&]

The post Don’t Drown in your Data Lake appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/31/dont-drown-in-your-data-lake/

In this third and final post of the series, we look at how to configure transport encryption on a deployed MongoDB replica set. Security vulnerabilities can arise when internal personnel have legitimate access to the private network, but should not have access to the data. Encrypting intra-node traffic ensures that no one can sniff sensitive data [&]

The post MongoDB: deploy a replica set with transport encryption (part 3/3) appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/31/mongodb-deploy-replica-set-with-transport-encryption-part-3/

Percona announces the release of Percona Server for MySQL 5.6.40-84.0 on May 30, 2018 (downloads are available here and from the Percona Software Repositories). Based on MySQL 5.6.40, including all the bug fixes in it, Percona Server for MySQL 5.6.40-84.0 is now the current GA release in the 5.6 series. All of Percona’s software is open-source and free. [&]

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

https://www.percona.com/blog/2018/05/30/percona-server-for-mysql-5-6-40-84-0-is-now-available/

Percona announces the release of Percona Server for MySQL 5.6.40-84.0 on May 30, 2018 (downloads are available here and from the Percona Software Repositories). Based on MySQL 5.6.40, including all the bug fixes in it, Percona Server for MySQL 5.6.40-84.0 is now the current GA release in the 5.6 series. All of Percona’s software is open-source and free. [&]

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

https://www.percona.com/blog/2018/05/30/percona-server-for-mysql-5-6-40-84-0-is-now-available/

At my latest webinar MySQL Test Framework (MTR) for Troubleshooting, I received an interesting question about MTR test cases for Percona XtraDB Cluster (PXC). Particularly about testing SST and IST. This post is intended to answer this question. It assumes you are familiar with MTR and can write tests for MySQL servers. If you are [&]

The post MySQL Test Framework for Percona XtraDB Cluster appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/30/mysql-test-framework-percona-xtradb-cluster/