by Peter Zaitsev | Oct 23, 2019 | Monitoring, MySQL
MySQL Workbench is a great multi-purpose GUI tool for MySQL, which I think is not marketed enough by the MySQL team and is not appreciated enough by the community for what it can do. MySQL Workbench Licensing MySQL Workbench is similar to MySQL Server and is an...
by Ramesh Sivaraman | Oct 15, 2019 | MySQL, Percona Software
This blog post will help you configure a 3-node Percona XtraDB Cluster using a binary tarball on your local machine. Configuration files are auto-generated with mostly default configurations except for port/IP address details. The tool has the handy script to create...
by Dmitriy Kostiuk | Oct 9, 2019 | Monitoring, Percona Software
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring your database performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL®,...
by Kenn Takara | Oct 4, 2019 | Insight for DBAs, MySQL, Percona Software
Starting with the experimental release of Percona XtraDB Cluster 8.0, we have made changes to the SST process to make the process more robust and easier to use. mysqldump and rsync are no longer supported SST methods. Support for mysqldump was deprecated starting with...
by Borys Belinsky | Oct 1, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is happy to announce the first experimental binary of Percona XtraDB Cluster 8.0 on October 1, 2019. This is a major step for tuning Percona XtraDB Cluster to be more cloud- and user-friendly. This release combines the updated and feature-rich Galera 4, with...
by Daniel Guzmán Burgos | Sep 27, 2019 | MySQL
MySQL Shell is a pretty nice piece of software. Is not just another mysql client but it is also a tool that offers scripting capabilities for JavaScript and Python. And one of the coolest things you can do with it is to check if your MySQL 5.7 server is ready for an...
by Walter Garcia | Sep 26, 2019 | Insight for DBAs, MySQL, Percona Software
In a previous post, I showed you how to compile Percona Mysql 5.7 on Raspberry PI 3. Now, I’ll show you how to compile and run the latest version of Percona XtraDB Cluster 5.7.26. We will need at least 3 RaspberryPi 3 boards, and I recommend you use an external...
by Mike Benshoof | Sep 23, 2019 | Insight for DBAs, MySQL
If you have been around MySQL for any length of time, you are probably aware that choosing the correct data types and optimizing your schema are actually important tasks. A few years back at Percona Live 2016, I gave an introductory talk on schema review and...
by Yves Trudeau | Sep 19, 2019 | Hardware and Storage
Last year, I wrote a post focused on the performance of the 3D_XPoint technology and sold under the Optane brand. Those devices are outperforming regular flash devices and have higher endurance. In the context of this post, I found they are also very good at handling...
by Dmitriy Kostiuk | Sep 19, 2019 | Monitoring, Percona Software
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL®, MongoDB®, and PostgreSQL® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis...
by Dmitriy Kostiuk | Sep 19, 2019 | Monitoring, Percona Software
We are pleased to announce the General Availability of PMM2, our latest software release! Created specifically to support open source software users, Percona Monitoring and Management (PMM) is a leading, free, open-source platform that allows you to actively manage...
by Borys Belinsky | Sep 18, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is happy to announce the release of Percona XtraDB Cluster 5.7.27-31.39 on September 18, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.7.27-31.39 is now the current release, based on the...
by Borys Belinsky | Sep 17, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.6.45-28.36 on September 17, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.6.45-28.36 is now the current release, based on the...
by David Quilty | Sep 13, 2019 | Percona Software, Webinars
Please join Percona Senior Support Engineer Juan Pablo Arruti as he presents his talk “Percona XtraBackup vs Mariabackup vs MySQL Enterprise Backup” on Tuesday, September 17th, 2019 at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). View the Recording There are few ways...
by Dmitriy Kostiuk | Sep 9, 2019 | Monitoring, Percona Software
We are pleased to announce our 7th Beta release of PMM 2! Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance. This release includes the following improvements: Query...
by Stephen Thorn | Sep 9, 2019 | Monitoring, MySQL, Percona Software, Storage Engine
One of the great things about working at Percona is the constant innovation that occurs as a result of a deep level of technical expertise. A more recent conversation about the Information Schema table: here. The README.md has installation instructions. Download the...
by Agustín | Aug 29, 2019 | MySQL, Open Source
In this short blog post, we will check how to use here and https://dbsake.readthedocs.io/en/latest/commands/uncache.html (Updated: Check LeFred’s comments below for more insight on this.) As an added bonus, DBSake has a fincore tool you can use! vmtouch –...
by Patrick Birch | Aug 20, 2019 | MySQL, Percona Software
Percona announces the release of Percona Server for MySQL 5.6.45-86.1 on August 20, 2019. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the 5.6.45, and including all...
by Patrick Birch | Aug 15, 2019 | MySQL, Percona Software
Percona announces the release of Percona Server for MySQL 8.0.16-7 on August 15, 2019 (downloads are available here and from the Percona Software Repositories). This release is based on MySQL 8.0.16. It includes all bug fixes in these releases. Percona Server for...
