Monthly Archives - November 2017

Percona Server for MongoDB 3.4.10-2.10 Is Now Available

Percona Server for MongoDB Operator

Percona announces the release of Percona Server for MongoDB 3.4.10-2.10 on November 30, 2017. Download the latest version from the Percona web site or the Percona Software Repositories.
Percona Server for MongoDB is an enhanced, open source, fully compatible, highly-scalable, zero-maintenance database supporting the MongoDB v3.4 protocol and drivers. It extends MongoDB with Percona Memory Engine and MongoRocks storage engine, as well as several enterprise-grade features:

External Authentication
Audit Logging
Profiling […]

Read more

Percona Monitoring and Management 1.5.1 Is Now Available

Percona Monitoring and Management 1.17.0

Percona announces the release of Percona Monitoring and Management 1.5.1. This release contains fixes for bugs found after Percona Monitoring and Management 1.5.0 was released.

Bug fixes

PMM-1771: When upgrading PMM to 1.5.0 using Docker commands, PMM System Summary, PMM Add Instance, PMM Query Analytics dashboards were not available.
PMM-1761: The PMM Query Analytics dashboard did not display the list of hosts correctly.
PMM-1769: It was possible to add an Amazon RDS instance providing invalid […]

Read more

Percona XtraBackup 2.3.10 Is Now Available

Percona XtraBackup 8.0

Percona announces the release of Percona XtraBackup 2.3.10 on November 29, 2017. Downloads are available from our download site or Percona Software Repositories.
Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open […]

Read more

Percona XtraBackup 2.4.9 Is Now Available

Percona XtraBackup 8.0

Percona announces the GA release of Percona XtraBackup 2.4.9 on November 29, 2017. You can download it from our download site and apt and yum repositories.
Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free […]

Read more

Best Practices for Percona XtraDB Cluster on AWS

Percona XtraDB Cluster on AWS 2 small

In this blog post I’ll look at the performance of Percona XtraDB Cluster on AWS using different service instances, and recommend some best practices for maximizing performance.
You can use Percona XtraDB Cluster in AWS environments. We often get questions about how best to deploy it, and how to optimize both performance and spend when […]

Read more

Percona Monitoring and Management 1.5.0 Is Now Available

Percona Monitoring and Management 1.17.0

Percona announces the release of Percona Monitoring and Management 1.5.0 on November 28, 2017.
This release focuses on the following features:

Enhanced support for MySQL on Amazon RDS and Amazon Aurora – Dedicated Amazon Aurora dashboard offers maximum visibility into key database characteristics, eliminating the need for additional monitoring nodes.  We renamed Amazon RDS OS Metrics to Amazon […]

Read more

autoxtrabackup v1.5.0: A Tool for Automatic Backups

autoxtrabackup

There is a new version of the autoxtrabackup tool. In this post, I’ll provide some of the highlights available this time around.
autoxtrabackup is a tool created by PerconLabs. We’ve now put out the 1.5.0 version, and you can test it further.
Note: PerconaLabs and Percona-QA are open source GitHub repositories for unofficial scripts and tools […]

Read more

This Week in Data with Colin Charles 16: FOSDEM, Percona Live call for papers, and ARM

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
Hurry up – the call for papers (CFP) for FOSDEM 2018 ends December 1, 2017. I highly recommend submitting as its a really fun, free, and technically-oriented event.
Don’t forget that the CFP for Percona Live […]

Read more

MongoDB 3.6 Change Streams: A Nest Temperature and Fan Control Use Case

MongoDB 3.6 Change Streams

In this post, I’ll look at what MongoDB 3.6 change streams are, in a creative way. Just in time for the holidays!
What is a change stream?
Change streams in MongoDB provide a cross-platform unified API that can be supported with sharding. It has an option for talking to secondaries, and even allows for security controls […]

Read more

Sudoku Recursive Common Table Expression Solver

Recursive Common Table Expressions

In this blog post, we’ll look at a solving Sudoku using MySQL 8.0 recursive common table expression.
Vadim was recently having a little Saturday morning fun solving Sudoku using MySQL 8. The whole idea comes from SQLite, where Richard Hipp has come up with some outlandish recursive query examples — WITH clause.
The SQLite query:

Shell

WITH RECURSIVE
 input(sud) […]

Read more