Monthly Archives - July 2017

Faster Node Rejoins with Improved IST performance

IST Performance

In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
Introduction
Starting in version 5.7.17-29.20 of Percona XtraDB Cluster significantly improved performance. Depending on the workload, the increase in throughput is in the range of 3-10x. (More details here). These optimization fixes also helped improve IST (Incremental State Transfer) performance. This blog […]

Read more

Where Do I Put ProxySQL?

ProxySQL

In this blog post, we’ll look at how to deploy ProxySQL.
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. It was created for DBAs by René Cannaò, as a means of solving […]

Read more

Blog Poll: What Operating System Do You Run Your Development Database On?

Blog Poll

In this post, we’ll use a blog poll to find out what operating system you use to run your development database servers.
In our last blog poll, we looked at what OS you use for your production database. Now we would like to see what you use for your development database.
As databases grow to meet more […]

Read more

Multi-Threaded Slave Statistics

Multi-Threaded Slave Statistics

In this blog post, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
MySQL version 5.6 and later allows you to execute replicated events using parallel threads. This feature is called Multi-Threaded Slave (MTS), and to enable it you need to modify the
slave_parallel_workers variable to a value greater than 1.
Recently, a few […]

Read more

Backups and Disaster Recovery

Backups and Disaster Recovery

In this post, we’ll look at strategies for backups and disaster recovery.
Note: I am giving a talk on Backups and Disaster Recovery Best Practices on July 27th.
Register Now

When discussing disaster recovery, it’s important to take your business’ continuity plan into consideration. Backup and recovery processes are a critical part of any application infrastructure.
A well-tested […]

Read more

Percona Live Europe 2017 Call for Papers Deadline Extended to July 24, 2017

Colin Charles

We are extending the Percona Live Open Source Database Conference Europe 2017 call for papers deadline to Monday, July 24, 2017. Get your submissions in now!
Between our Conference Committee working hard to review all the outstanding talk ideas, and the many community requests for more time, we didn’t want to shortchange any of our applicants. If […]

Read more

Percona Server for MongoDB 3.2.14-3.4 is Now Available

Percona Server for MongoDB 3.2

Percona announces the release of Percona Server for MongoDB 3.2.14-3.4 on July 17, 2017. Download the latest version from the Percona web site or the Percona Software Repositories.
(more…)

Read more

Percona Monitoring and Management 1.2.0 is Now Available

Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.2.0 on July 14, 2017.
For installation instructions, see the Deployment Guide.

Changes in PMM Server
PMM Server 1.2.0 introduced the following changes:

Updated Components

Consul 0.8.5
Grafana 4.3.2
Orchestrator 2.1.5
Prometheus 1.7.1

New Features

PMM-737: New graphs in System Overview dashboard:

Memory Advanced Details
Saturation Metrics

PMM-1090: Added ESXi support for PMM Server virtual appliance.

UI Fixes

PMM-707: Fixed QPS metric in MySQL Overview dashboard to always show queries […]

Read more

A Little Trick Upgrading to MySQL 5.7

Upgrading to MySQL 5.7

In this blog post, I’ll look at a trick we use at Percona when upgrading to MySQL 5.7.
I’ll be covering this subject (and others) in my webinar Learning MySQL 5.7 on Wednesday, July 19, 2017.
We’ve been doing upgrades for quite a while here are Percona, and we try to optimize, standardize and improve this process […]

Read more