by Sveta Smirnova | Apr 2, 2021 | Insight for DBAs, MySQL, Percona Software
Recovering to a particular time in the past is called Point-In-Time Recovery (PITR). With PITR you can rollback unwanted DELETE without WHERE clause or any other harmful command. PITR with Percona XtraBackup is pretty straightforward and perfectly described in the...
by Mike Benshoof | Apr 2, 2021 | Insight for DBAs, MySQL, Percona Services
Nobody likes change, especially when that change may be challenging. When faced with a technical challenge, I try to remember this comment from Theodore Roosevelt: “Nothing in the world is worth having or worth doing unless it means effort, pain, difficulty.” While...
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 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 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 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...
by Ivan Groenewold | Jan 28, 2021 | Cloud, MySQL, ProxySQL
There are several ways to deploy ProxySQL between your applications and the database servers. A common approach is to have a floating virtual IP (VIP) managed by keepalived as the application endpoint. The proxies have to be strategically provisioned to improve the...
by Patrick Birch | Jan 27, 2021 | Insight for DBAs, MySQL, Percona Software
Percona XtraBackup 8.0.23 enables the “lock-ddl” option by default to ensure any DDL events do not corrupt the backups. Any DML events continue to occur, and only DDL events are blocked. A DDL lock protects the definition of tables and views. With the...
by Nickolay Ihalainen | Jan 27, 2021 | Benchmarks, MariaDB, MongoDB, MySQL, PostgreSQL
I want to present a tool for running a specific version of open source databases in a single instance, replication setups, and Kubernetes. AnyDbVer deploys MySQL/MariaDB/MongoDB/PostgreSQL for testing and experiments. It Could Be Started By… Docker (or Podman)...
