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/

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 infrastructure or try out PMM before implementing it to monitor your [&]

The post Deploying PMM on DigitalOcean appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/29/deploying-pmm-digitalocean/

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 infrastructure or try out PMM before implementing it to monitor your [&]

The post Deploying PMM on DigitalOcean appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/29/deploying-pmm-digitalocean/

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 infrastructure or try out PMM before implementing it to monitor your [&]

The post Deploying PMM on DigitalOcean appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/29/deploying-pmm-digitalocean/

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 (UTC-4). Register Now   In this webinar, Alex will discuss how to deploy [&]

The post Webinar Tues, 5/29: MySQL, Percona XtraDB Cluster, ProxySQL, Kubernetes: How they work together appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/25/upcoming-webinar-tuesday-5-29-mysql-percona-xtradb-cluster-proxysql-kubernetes/

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 (UTC-4). Register Now   In this webinar, Alex will discuss how to deploy [&]

The post Webinar Tues, 5/29: MySQL, Percona XtraDB Cluster, ProxySQL, Kubernetes: How they work together appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/25/upcoming-webinar-tuesday-5-29-mysql-percona-xtradb-cluster-proxysql-kubernetes/

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 Giuseppes post, so head there if you want a deeper dive. First step [&]

The post Using dbdeployer to manage MySQL, Percona Server and MariaDB sandboxes appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/24/using-dbdeployer-to-manage-mysql-percona-server-and-mariadb-sandboxes/

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 Cloud Platform) project [&]

The post Setting up PMM on Google Compute Engine in 15 minutes or less appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/24/setting-up-pmm-on-google-compute-engine-in-15-minutes/

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. In PMM Release 1.11.0, we deliver the following changes: Configurable MySQL Slow Log Rotation [&]

The post Percona Monitoring and Management 1.11.0 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/23/percona-monitoring-and-management-1-11-0-is-now-available/

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 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.4-1.2 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/23/percona-server-for-mongodb-3-6-4-1-2-is-now-available/

In this article series, we will talk about the basic high availability architecture of a MongoDB: the MongoDB replica set. Part 1 : We introduced basic replica set concepts, how it works and what its main features Part 2 (this post): We’ll provide a step-by-step guide to configure a three-node replica set Part 3: We’ll [&]

The post Deploy a MongoDB Replica Set with Transport Encryption (Part 2) appeared first on Percona Database Performance Blog.

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

Percona announces the release of Percona Toolkit 3.0.10 on May 22, 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, Percona [&]

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

https://www.percona.com/blog/2018/05/22/percona-toolkit-3-0-10-is-now-available/

ProxySQL 1.4.8, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Perconas proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. Ren'e Canna`o created [&]

The post ProxySQL 1.4.8 and Updated proxysql-admin Tool Now in the Percona Repository appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/22/proxysql-1-4-8-available-percona-repository/

Please join Percona’s Senior Support Engineer, Adamo Tonete as he presents What’s New in MongoDB 3.6 on Thursday, May 24th, 2018, at 12:30 PM PDT (UTC-7) / 3:30 PM EDT (UTC-4). In this webinar, Adamo will walk though what’s new in MongoDB 3.6, including: Change streams for building reactive, real-time applications Retryable writes for always-on [&]

The post Upcoming Webinar Thursday, 5/24: What’s New in MongoDB 3.6 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/22/webinar-thursday-5-24-whats-new-mongodb-3-6/

Percona announces the release of Percona Server for MongoDB 3.2.20-3.11 on May 21, 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.2 Community Edition. It supports MongoDB 3.2 protocols and drivers. Percona [&]

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

https://www.percona.com/blog/2018/05/21/percona-server-for-mongodb-3-2-20-3-11-is-now-available/

Please join Perconas Principal Support Escalation Specialist, Sveta Smirnova, as she presents Troubleshooting MySQL Concurrency Issues with Load Testing Tools on Wednesday, May 23, 2018 at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now   Normally, we use benchmarking tools when we are developing applications. When applications are deployed, benchmarks tests are usually too [&]

The post Webinar Wed, 5/23: Troubleshooting MySQL Concurrency Issues with Load Testing Tools appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/21/webinar-wed-5-23-troubleshooting-mysql-concurrency-issues-with-load-testing-tools/

If you are a regular reader of this blog, you likely know I like the ZFS filesystem a lot. ZFS has many very interesting features, but I am a bit tired of hearing negative statements on ZFS performance. It feels a bit like people are telling me Why do you use InnoDB? I have read [&]

The post About ZFS Performance appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/15/about-zfs-performance/

Do you want to install MySQL 8.0 on Ubuntu 16.04 LTS? In this quick tutorial, I show you exactly how to do it in five minutes or less. This tutorial assumes you dont have MySQL or MariaDB installed. If you do, its necessary to uninstall them or follow a slightly more complicated upgrade process (not [&]

The post Installing MySQL 8.0 on Ubuntu 16.04 LTS in Five Minutes appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/14/installing-mysql-8-on-ubuntu-16-04-lts/

Do you want to install MySQL 8.0 on Ubuntu 16.04 LTS? In this quick tutorial, I show you exactly how to do it in five minutes or less. This tutorial assumes you dont have MySQL or MariaDB installed. If you do, its necessary to uninstall them or follow a slightly more complicated upgrade process (not [&]

The post Installing MySQL 8.0 on Ubuntu 16.04 LTS in Five Minutes appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/14/installing-mysql-8-on-ubuntu-16-04-lts/

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. rootconf.in 2018 just ended, and it was very enjoyable to be in Bangalore for the conference. The audience was large, the conversations were great, and overall I think this is a rather important conference if youre [&]

The post This Week in Data with Colin Charles 39: a valuable time spent at rootconf.in appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/11/this-week-in-data-with-colin-charles-39/