by Peter Zaitsev | Jun 12, 2018 | MySQL, Webinars
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...
by Marco Tusa | Jun 12, 2018 | MySQL, Percona Software, Security
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 iptables -F and save. In short, they remove any rules for their firewall. With...
by Walter Garcia | Jun 11, 2018 | MySQL, ProxySQL
ProxySQL 1.4.2 introduced native clustering, allowing several ProxySQL instances to communicate with and share configuration updates with each other. In this blog post, I’ll review this new feature and how we can start working with 3 nodes. Before I continue,...
by Vinodh Krishnaswamy | Jun 8, 2018 | Insight for DBAs, Percona Software
In this blog post, I will share with you how to set up the PMM QAN for MongoDB and the formulas behind the metrics and graphs that you see on the QAN dashboard. When one of my customers wanted to load test and understand the behavior of the queries in their MongoDB...
by Colin Charles | Jun 8, 2018 | MariaDB, MongoDB, MySQL, Storage Engine
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Some big news out from Microsoft about their acquisition of GitHub for $7.5 billion. GitHub hosts many projects, including...
by Jervin Real | Jun 7, 2018 | Cloud
In this day and age of agile methodologies and fast-paced development methods, database schema changes are as inevitable as the growth of data. We have been thoroughly familiar with the effectivity of pt-online-schema-change for the last couple of years but it has one...
by Sveta Smirnova | Jun 5, 2018 | Benchmarks, MySQL
If you attended my latest Troubleshooting MySQL Concurrency Issues with Load Testing Tools webinar you learned how I exploit benchmarking tools to replicate locking issues and crashes. But I told you nothing about proper use of these tools: for reliable benchmarks. I...
by Sveta Smirnova | Jun 4, 2018 | Benchmarks, MySQL
In this blog, I will provide answers to the Q & A for the Troubleshooting MySQL Concurrency Issues with Load Testing Tools webinar. First, I want to thank everybody for attending my May 23, 2018, webinar on troubleshooting tools for MySQL. The recording and slides...
by Colin Charles | Jun 1, 2018 | Cloud, MariaDB, MongoDB, MySQL, Open Source, Percona Events, Percona Software, PostgreSQL, ProxySQL
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...
by Dmitriy Kostiuk | May 31, 2018 | MySQL, Percona Events, Percona Live, Percona Software, Security, Storage Engine
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....
by Rick Golba | May 31, 2018 | Insight for DBAs, MySQL, Open Source
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 aren’t clear that they need...
by Corrado Pandiani | May 31, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Security
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...
by Dmitriy Kostiuk | May 30, 2018 | MySQL, Percona Events, Percona Software
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...
by Sveta Smirnova | May 30, 2018 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
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...
by Roma Novikov | May 29, 2018 | Cloud, MySQL, Percona Software
It’s very easy to install Percona Monitoring and Management (PMM) on DigitalOcean. If you’ve never used DigitalOcean before, you will find that it is user-friendly and not very expensive. For $5/month you can easily host your PMM on it, letting you monitor your simple...
by Alexander Rubin | May 25, 2018 | Cloud, Insight for DBAs, Insight for Developers, MySQL, Percona Software, ProxySQL, Webinars
Please join Percona’s Principal Architect Alex Rubin as he presents MySQL, Percona XtraDB Cluster, ProxySQL, Kubernetes: How they work together to give you a highly available cluster database environment on Tuesday, May 29th at 7:00 AM PDT (UTC-7) / 10:00 AM EDT...
by Agustín | May 24, 2018 | Insight for DBAs, Insight for Developers, MariaDB, MySQL, Percona Software
Some years ago, Peter Z wrote a blogpost about using MySQL Sandbox to deploy multiple server versions. Last February, Giuseppe introduced us to its successor: dbdeployer. In this blogpost we will demonstrate how to use it. There is a lot of information in...
by Jericho Rivera | May 24, 2018 | Cloud, Insight for DBAs, MySQL, Percona Software
In this blog post, I will show you how easy it is to set up a Percona Monitoring and Management server on Google Compute Engine from the command line. First off you will need to have a Google account and install the Cloud SDK tool. You need to create a GCP (Google...
by Michael Coburn | May 23, 2018 | Cloud, MongoDB, Monitoring, MySQL, Percona Events, Percona Software
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...
by Dmitriy Kostiuk | May 23, 2018 | MongoDB, Percona Events, Percona Live, Percona Software
Percona announces the release of Percona Server for MongoDB 3.6.4-1.2 on May 23, 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...
