Percona Software and Roadmap Update with CEO Peter Zaitsev: Q2 2017

This blog post is a summary of the Percona Software and Roadmap Update – Q2 2017 webinar given by Peter Zaitsev on May 4, 2017. This webinar reflects changes and updates since the last update (Q1 2017).

A full recording of this webinar, along with the presentation slide deck, can be found here.

Percona Software

Below are the latest and upcoming features in Percona’s software. All of Percona’s software is 100% free and open source, with no restricted “Enterprise” version. Percona doesn’t restrict users with open core or “open source, eventually” (BSL) licenses.

Percona Server for MySQL 5.7

Latest Improvements

• Column Compression now available in Percona Server 5.7
• MySQL Group Replication included
• Experimental MyRocks build available

Features About To Be Released 

• Integration of TokuDB and Performance Schema
• MyRocks integration in Percona Server
• Starting to look towards MySQL 8

Percona XtraBackup 2.4

Latest Improvements

• Hardware accelerated crc32 for page and log checksums
• Parallel stream extraction
• Parallel encryption and decryption

Percona Toolkit

Latest Improvements

• Initial support for MongoDB:

  • pt-mongodb-summary
  • pt-mongodb-query-digest

• New tools implemented in Go
• Performance Schema support in pt-stalk

Percona Server for MongoDB 3.4

Latest Improvements

• Updated MongoRocks storage engine
• Updated Percona Memory storage engine
• PerconaFT storage engine no longer available
• Log redaction (sensitive data masking)
• Profile rate limiting (query sampling)
• Hot backup for WiredTiger and MongoRocks

Percona XtraDB Cluster 5.7

Latest Improvements

• Up to 10 times better performance
• Parallel State Transfer support with Percona XtraBackup
• Better instrumentation of Flow Control Status

  • also see More Trackable Flow Control for Percona XtraDB Cluster

• Instrumentation of Incremental State Transfer (IST)

  • also see Tracking IST Progress in Percona XtraDB Cluster

Performance Improvement Benchmarks

Below, you can see the benchmarks for improvements to Percona XtraDB Cluster 5.7 performance. You can read about the improvements and benchmark tests in more detail here and here.

Percona XtraDB Cluster 5.7 Integrated with ProxySQL 1.3

• proxysql-admin script to simplify configuration
• Support for Zero Downtime Maintenance
• Support even larger number of connections
• Support for Prepared Statements (experimental)

Percona Monitoring and Management

New in Percona Monitoring and Management

• Continuing to improve and expand dashboards with every release:

  • Advanced MariaDB dashboards
  • Improved MongoDB dashboards

• Includes Grafana 4.2 (with basic Alerting)
• SSL support for server-agent communications
• Supports authentication for server-agent communication
• Added support for Amazon RDS
• Reduced space consumption by using advanced compression
• AMI and OVA builds

Advanced MariaDB Dashboards in PMM (Links go to PMM Demo)

• Aria Pagecache Reads/Writes
• Aria Pagecache Blocks
• InnoDB Online DDL
• InnoDB Defragmentation

Improved MongoDB Dashboards in PMM (Links go to PMM Demo)

• MMAPv1 Lock Ratio
• MMAPv1 Page Faults
• MMAPv1 Journaling Time

• WiredTiger Checkpoint Time
• WiredTiger Log Bytes

• RocksDB Memtable Entries

Check out the PMM Demo

• http://pmmdemo.percona.com

Thanks for tuning in for an update on Percona Software and Roadmap Update – Q2 2017.

New Percona Online Store – Easy to Buy, Pay Monthly

• Purchase some of Percona’s services online
• Fast and easy credit card payments
• Recurring monthly payments
• https://www.percona.com/store