by Borys Belinsky | Nov 29, 2017 | MongoDB, MySQL, Open Source, Percona Events, Percona Software
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...
by Hrvoje Matijakovic | Nov 29, 2017 | MySQL, Percona Events, Percona Software
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...
by Hrvoje Matijakovic | Nov 29, 2017 | MySQL, Percona Events, Percona Software
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...
by Vadim Tkachenko | Nov 28, 2017 | MySQL
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...
by Borys Belinsky | Nov 28, 2017 | MongoDB, MySQL, Open Source, Percona Events, Percona Software
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...
by Shahriyar Rzayev | Nov 27, 2017 | Insight for DBAs
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:...
by Colin Charles | Nov 24, 2017 | MySQL
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...
by David Murphy | Nov 22, 2017 | Insight for DBAs, Insight for Developers, MongoDB, Percona Software
by Colin Charles | Nov 22, 2017 | Insight for DBAs, MariaDB, MySQL
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...
by Hrvoje Matijakovic | Nov 21, 2017 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Toolkit 3.0.5 on November 21, 2017. Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL and MongoDB server and system tasks too difficult or complex for DBAs to perform manually....
by Vadim Tkachenko | Nov 20, 2017 | Insight for DBAs, MySQL
In this blog post, we’ll look at some of the facets of InnoDB page compression. Somebody recently asked me about the best way to handle JSON data compression in MySQL. I took a quick look at InnoDB page compression and wanted to share my findings. First, the...
by Colin Charles | Nov 17, 2017 | MariaDB, MongoDB, MySQL, Open Source, Percona Live, PostgreSQL
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. So we have announced the call for presentations for Percona Live Santa Clara 2018. Please send your submissions in! As you...
by Krunal Bauskar | Nov 15, 2017 | Insight for DBAs, MySQL, Percona Software
In a clustering environment, we often see a node that needs to be taken down for maintenance. For a node to rejoin, it should re-sync with the cluster state. In PXC (Percona XtraDB Cluster), there are 2 ways for the rejoining node to re-sync: State Snapshot Transfer...
by Yves Trudeau | Nov 15, 2017 | Hardware and Storage, Insight for DBAs, MySQL
Since the purpose of a database system is to store data, there is close relationship with the filesystem. As MySQL consultants, we always look at the filesystems for performance tuning opportunities. The most common choices in term of filesystems are XFS and EXT4, on...
by Peter Zaitsev | Nov 14, 2017 | Insight for Developers, MariaDB, MongoDB, MySQL, Percona Events, Percona Software, ProxySQL, Webinars
Do you need to get to grips with MySQL proxies? Or maybe you could do with discovering the latest developments and plans for Percona’s software? Well, wait no more because … on Wednesday November 15, 2017, we bring you a webinar double bill. Join Percona’s...
by David Murphy | Nov 14, 2017 | Insight for DBAs, Insight for Developers, MongoDB
In this blog post, we’ll look at some common MongoDB topologies used in database deployments. The question of the best architecture for MongoDB will arise in your conversations between developers and architects. In this blog, we wanted to go over the main...
by Colin Charles | Nov 13, 2017 | Cloud, Insight for DBAs, MariaDB, MongoDB, MySQL, Percona Live, PostgreSQL
Announcing the opening of the Percona Live Open Source Database Conference 2018 in Santa Clara, CA, call for papers. It will be open from now until December 22, 2017. Our theme is “Championing Open Source Databases,” with topics of MySQL, MongoDB and other open...
by Colin Charles | Nov 10, 2017 | Insight for DBAs, Insight for Developers, MongoDB, MySQL, Percona Events, Percona Live, PostgreSQL
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. We’re close to opening up the call for papers for Percona Live Santa Clara 2018 and I expect this to happen next...
by Peter Zaitsev | Nov 9, 2017 | MySQL
In this blog post, I’ll look at MySQL and Linux context switches and what is the normal number per second for a database environment. You might have heard many times about the importance of looking at the number of context switches to indicate if MySQL is...
by Daniel Guzmán Burgos | Nov 8, 2017 | Insight for DBAs, Percona Software
In this blog post, we’ll look at how to use Prometheus to check for auto_increment value exhaustion. One of the proactive tasks DBAs perform is checking if a field defined as auto_increment is about to reach the maximum allowed value of the int definition. For...
