by Artem Gavrilov | Jun 29, 2020 | Insight for Developers, Monitoring, Percona Software, Security
Security Threat Tool (STT) is the new Percona Monitoring and Management (PMM) feature. It provides the ability to run automated security checks across all of your databases and detect potential security problems. For example: empty or default passwords, weak security...
by David Quilty | Jun 26, 2020 | MySQL, Open Source, Webinars
Join Sveta Smirnova, MySQL Engineer at Percona, as she discusses modern solutions for modern database loads. MySQL is famous for working well in high performing environments. This is the reason why it is the most popular backend for web applications. But our view of...
by Sri Sakthivel | Jun 24, 2020 | Insight for DBAs, MySQL
Usually, database people are familiar with table fragmentation with DELETE statements. Whenever doing a huge delete, in most cases, they are always rebuilding the table to reclaim the disk space. But, are you thinking only DELETEs can cause table fragmentation?...
by Fernando Laudares Camargos | Jun 23, 2020 | Monitoring, MySQL, Percona Software
by Lalit Choudhary | Jun 23, 2020 | Insight for DBAs, Percona Software
At Percona, we operate on the premise that full-transparency makes a product better. We strive to build not only the best open-source database products but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source...
by Rick Golba | Jun 23, 2020 | Insight for DBAs, MySQL, Percona Software
Percona is pleased to announce the release of Percona Distribution for MySQL. Following our recent releases of Percona Distribution for MongoDB and Percona Distribution for PostgreSQL, we have assembled the best and most critical enterprise components for MySQL,...
by Carlos Tutte | Jun 19, 2020 | Insight for DBAs, Monitoring, Percona Software
Disclaimer: This blog post is about migrating Percona Monitoring and Management 2 (PMM) data between PMM2 versions, and not for migrating data from PMM1 to PMM2. Restoring data from PMM1 to PMM2 is NOT supported since there were many architectural changes. I...
by Peter Zaitsev | Jun 17, 2020 | Monitoring, MySQL, Percona Software
The RED Method (Rate, Errors, Duration) is one of the more popular performance monitoring approaches. It is often applied to Monitoring Microservices though there is nothing that prevents it from being applied to databases like MySQL. In Percona Monitoring and...
by Bronwyn Campbell | Jun 17, 2020 | Percona Events, Percona Live
We are excited to share that we are proceeding with plans to host Percona Live Europe in person, 19-21 October 2020 in Amsterdam. With that, we can also announce that the Call for Papers for Percona Live Europe is now open! Given that COVID-19 local restrictions...
by Tom Basil | Jun 16, 2020 | Open Source, Percona Services, Percona Software
All Percona products are free and open-source. If you use Percona software, provide us with your feedback and help make a larger audience aware at the same time. This helps drive our software development forward – without costing you anything. You can do this...
by David Quilty | Jun 16, 2020 | MySQL, Open Source, Webinars
Join Peter Zaitsev, CEO at Percona, as he discusses database challenges and the concepts of open source and open core. Over the years, open source companies have tried to bring products to market and maximize their revenue streams. To date, the most popular open...
by Mykola Marzhan | Jun 12, 2020 | Insight for DBAs, MySQL, Security
In most cases, MySQL password instructions provide information on changing MySQL user passwords on the production system (e.g., reset root password without restart). It is even recommended to change passwords regularly for security reasons. But still, sometimes DBA...
by Max Dudin | Jun 11, 2020 | Insight for DBAs, MySQL, Security
Day-to-day database operation requires, from an administrator, deep knowledge of db internals and security issues, in particular things like SQL injections. In order to prevent such kind of an attack, we have included go-sql-driver into our code for secure placeholder...
by David Quilty | Jun 11, 2020 | MySQL, Percona Software, Webinars
In this webinar, Sveta Smirnova, MySQL Engineer at Percona, will uncover nuances of Percona XtraDB Cluster (PXC) schema upgrades and point out details you need to give extra attention to. Percona XtraDB Cluster (PXC) is a 100% synchronized cluster in regards to DML...
by Carlos Salguero | Jun 10, 2020 | Monitoring, MySQL, Percona Software
Even though Percona Monitoring and Management 2 (PMM) comes with a lot of dashboards and metrics out of the box, sometimes we need to extend the default metrics by running custom MySQL queries. For example, suppose you want to have information about cached indexes...
by Rachel Pescador | Jun 9, 2020 | Database Trends, MySQL, Percona Services, Percona Software
Our latest Solution Brief uses our relationship with Patreon to detail the ways that Percona services work together to provide customers with a complete database infrastructure solution. Last year Patreon enlisted Percona’s help with their MySQL databases. Utilizing...
by Sveta Smirnova | Jun 4, 2020 | MySQL, Percona Software, Webinars
First I want to thank everyone who attended my May 21, 2020 webinar “How Safe is Asynchronous Master-Master Setup in MySQL?“. Recording and slides are available on the webinar page. Here are answers to the questions from participants which I was not able to provide...
by Carlos Tutte | Jun 3, 2020 | MySQL, Security
In systems nowadays, improving security is a must! One of the weakest links in the security system is the user password from where an attacker can enter. In order to improve password strength and security, MySQL provides a plugin called “Validation plugin” which can...
by Daniil Bazhenov | Jun 3, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
Percona engineers often need to analyze and review complex SQL database queries. Good formatting can make these SQL queries much easier to understand and work with. Without clear formatting, queries can become confusing and hard to debug. Online query formatting...
by Roman Misyurin | Jun 2, 2020 | Insight for Developers, Monitoring, Open Source, Percona Software
The frontend part of Percona Monitoring and Management (PMM) is a set of extensions for Grafana, and the Grafana documentation provides a basic understanding of how things work. But after I studied it, it was still difficult to understand how to approach development...
