by Mike Benshoof | Apr 1, 2021 | MySQL, Percona Software, Storage Engine
Percona Technical Account Managers get the privilege of working with some of our largest enterprise clients day in and day out. As such, we get to really focus on how to best leverage our technology to generate measurable benefits for our users. While it is fun to...
by Sergey Pronin | Apr 1, 2021 | Cloud, MySQL, Open Source, Percona Software
It is no secret that compute and storage costs are the main drivers of cloud bills. Migration of data from the legacy data center to the cloud looks appealing at first as it significantly reduces capital expense (CapEx) and keeps operational expenses (OpEx) under...
by David Quilty | Mar 31, 2021 | Insight for DBAs, MySQL, Percona Software, Webinars
Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBAs. The databases powering applications need to be able to handle changing traffic workloads while remaining responsive and stable in order...
by Brian Sumpter | Mar 31, 2021 | Insight for DBAs, MySQL
As many of you may remember, Percona added the super_read_only feature way back in Percona Server for MySQL 5.6.21, based on work done by WebScaleSQL. This feature eventually found its way into the Community branch of MySQL starting with 5.7.8, and it works the same...
by Sri Sakthivel | Mar 26, 2021 | Insight for DBAs, Insight for Developers, MySQL, Storage Engine
For MySQL, MyISAM and InnoDB storage engines are very popular. Currently, we are mostly using InnoDB engines for high reliability and high performance. Apart from those engines, we also have some other alternative engines and they have some nice features in them. In...
by Kathy Williamson | Mar 25, 2021 | Insight for Developers, MySQL, Percona Software
Have you ever wondered what it takes to complete Percona Server for MySQL (PS), Percona XtraDB Cluster (PXC), and Percona XtraBackup (PXB) releases? Let’s step back just a minute and talk about what Percona stands for. We believe we “stand on the shoulders of...
by Sri Sakthivel | Mar 24, 2021 | Insight for DBAs, MySQL
Transportable tablespaces were introduced in MySQL 5.6. Using this feature, we can directly copy a tablespace to another server and populate the table with data. This is a very useful feature for large tables. The transportable tablespace mechanism is faster than any...
by David Ducos | Mar 23, 2021 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Starting a long time ago, we wanted to reproduce workload in a non-production environment, and there were different attempts to achieve that goal (Query Playback is just one of them). But there is another point of view, where you need to write your own workload to do...
by Patrick Birch | Mar 23, 2021 | MySQL, Percona Announcements, Percona Software
Due to CVE-2020-29488, Percona XtraBackup is modifying how xbstream handles absolute paths to prevent malicious file injections. Like the tar archiving utility, the new behavior removes the leading ‘/’ character and references to the parent directory....
by Evgeniy Patlan | Mar 10, 2021 | Insight for DBAs, MySQL, Percona Software
Lately, the number of questions about how to build Percona software has been increased. More and more people try to add their own patches, add some modifications, and build software by themselves. But this raises the question of how to do this in the same way as...
by Sri Sakthivel | Feb 25, 2021 | Insight for DBAs, Monitoring, MySQL
MySQL Shell is the advanced MySQL client, which has many excellent features. In this blog, I am going to explain the MySQL shell commands “\show” and “\watch”. Both commands are very useful to monitor the MySQL process. It provides more insights into the foreground...
by Lalit Choudhary | Feb 25, 2021 | Insight for DBAs, Insight for Developers, Percona Software
Here at Percona, we operate on the premise that full-transparency makes a product better. We strive to build 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 Sergey Pronin | Feb 24, 2021 | Cloud, Monitoring, MySQL, Percona Software
Point-In-Time Recovery (PITR) for MySQL databases is an important feature that is essential and covers common use cases, like a recovery to the latest possible transaction or roll-back the database to a specific date before some bad query was executed. Percona...
by Matt Yonkovit | Feb 24, 2021 | Open Source, Percona Announcements
Great news! Percona’s Community-focused podcast, hosted by none other than the HOSS (Head of Open Source Software) himself (yeah, that is me), is now available on almost all podcast platforms. What? You didn’t know we had a podcast? We do, and we’ve had...
by Patrick Birch | Feb 16, 2021 | Insight for DBAs, MySQL, Percona Software
MySQL 5.6.51 is the last release of the MySQL 5.6 series. Oracle will no longer provide updates or security fixes for this version. Following Percona’s Release Lifecycle policies, the Percona Server for MySQL 5.6 series has reached End of Life (EOL) as well, and...
by Sri Sakthivel | Feb 11, 2021 | Insight for DBAs, MySQL, Storage Engine
The goal of this blog post is to explain the various types of transaction isolation levels available in MySQL. After reading the blog, you will be able to explain dirty reads, non-repeatable reads, and the concept of phantom rows as well. What is the Isolation Level...
by Sergey Pronin | Feb 8, 2021 | Cloud, Insight for DBAs, Open Source, Percona Software
Running Database-as-a-Service (DBaaS) in the cloud is the norm for users today. It provides a ready-to-use database instance for users in a few seconds, which can be easily scaled and usually comes with a pay-as-you-go model. We at Percona see that more and more cloud...
by David Quilty | Feb 5, 2021 | Insight for DBAs, MySQL, Percona Software, Webinars
Join Brian Walters and Brandon Fleisher for an interactive discussion around new service and software offerings coming from Percona. Oracle has decided that MySQL 5.6 will reach its end of life in February 2021. This means there will be no more updates and, more...
by Matt Yonkovit | Feb 5, 2021 | Insight for DBAs, Open Source, Percona Events
If you have not heard, this weekend is FOSDEM. FOSDEM this year is virtual (and open to all), and it looks like it is going to be an absolutely stellar lineup of open source content. The details: February 6-7th, 2021, with over 600 speakers, over 700 sessions, and...
by Michael Coburn | Feb 3, 2021 | Monitoring, MySQL, Percona Software, Webinars
Hi and thanks to all who attended my webinar on Tuesday, January 26th titled Using PMM to Identify & Troubleshoot Problematic MySQL Queries! Like we do after all our webinars, we compile the list of questions that were answered verbally and also those that were...
