EmergencyEMERGENCY? Get 24/7 Help Now!

Faster Node Rejoins with Improved IST performance

and  | July 21, 2017 |  Posted In: MySQL, Percona XtraDB Cluster

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

Read More

Where Do I Put ProxySQL?

 | July 20, 2017 |  Posted In: High-availability, ProxySQL, Replication

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

Multi-Threaded Slave Statistics

 | July 19, 2017 |  Posted In: Insight for DBAs, MySQL, Replication

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

Read More

Backups and Disaster Recovery

 | July 18, 2017 |  Posted In: Backups, Business Continuity, MySQL, MySQL 101, Percona Backup Service, Percona XtraBackup

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

Read More

Upcoming Webinar Wednesday, July 19, 2017: Learning MySQL 5.7

 | July 18, 2017 |  Posted In: MySQL

MySQL 5.7

Join Percona’s, Technical Services Manager, Jervin Real as he presents Learning MySQL 5.7 on Wednesday, July 19, 2017 at 10:00 am PDT / 1:00 pm EDT (UTC-7). Register Now MySQL 5.7 has a lot of new features. If you’ve dabbled with an older version of MySQL, it is worth learning what new features exist and […]

Read More

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

 | July 17, 2017 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL, Percona Live

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 Monitoring and Management 1.2.0 is Now Available

 | July 14, 2017 |  Posted In: Database Monitoring, Events and Announcements, Insight for DBAs, MariaDB, MongoDB, MySQL, Orchestrator, Percona Monitoring and Management, Percona Software, PMM, Prometheus, ProxySQL

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

Read More