by Marco Tusa | Apr 15, 2021 | Insight for DBAs, MySQL, Percona Software
While I was working on my grFailOver POC, I have also done some additional parallel testing. One of them was to see how online DDL is executed inside a Group Replication cluster. The online DDL feature provides support for instant and in-place table alterations and...
by Tom Basil | Apr 14, 2021 | Insight for DBAs, Open Source, Percona Software
You can earn Percona swag by writing a short technical review about Percona software by May 30, 2021! The keyword here is technical. Percona is seeking reviews that describe Percona software use in particular environments or in solving particular issues, and why!...
by Marco Tusa | Apr 14, 2021 | Insight for DBAs, MySQL, Open Source, Percona Software
Where x is >= 22 😉 The Problem There are few things your data does not like. One is water and another is fire. Well, guess what: If you think that everything will be fine after all, take a look: Given my ISP had part of its management infrastructure on OVH, they...
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 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 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 David Quilty | Mar 11, 2021 | Insight for DBAs, MongoDB, Webinars
Join Percona Technical Expert Corrado Pandiani as he presents a quick yet robust comparison of the different backup solutions that can be used with MongoDB. This webinar will highlight: – Terminology – Elements of MongoDB Backups – Backup &...
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 David Quilty | Mar 9, 2021 | Insight for DBAs, PostgreSQL, Webinars
Join Peter Zaitsev, Percona CEO, and Ibrar Ahmed, Percona Sr. Software Engineer, as they discuss pg_stat_monitor! If you’re tasked with optimizing PostgreSQL performance, chances are you’re relying on the pg_stat_statements extension to capture information...
by Jobin Augustine | Feb 26, 2021 | Benchmarks, Insight for DBAs, Insight for Developers, PostgreSQL
Yes, this post is about connection queueing, not just pooling. Because “connection pooling” – pre-created connections as a pool – is a much-celebrated feature. Almost every discussion on connection pool/pgBouncer starts with the overhead of...
by David Quilty | Feb 26, 2021 | Cloud, Insight for DBAs, Webinars
Join Rick Vasquez, Percona Technical Expert, as he discusses the pros and cons of moving your database to the cloud. Flexibility, performance, and cost management are three things that make cloud database environments an easy choice for many businesses. If you are...
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 Matt Yonkovit | Feb 17, 2021 | Database Trends, Insight for DBAs, Insight for Developers
I have talked extensively about the DBA’s evolving role and how many DBA’s and operations professionals are now becoming SRE’s (site reliability engineers) or DBRE’s (database reliability engineers). Often, databases get blamed as the bottleneck for application...
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 Akira Kurogane | Feb 15, 2021 | Cloud, Insight for DBAs, Insight for Developers
For MongoDB data directories only XFS is recommended. The ext4 filesystem isn’t so bad but when there are a very, very high number of random accesses (which WiredTiger can reach) it can hit a bottleneck. To be fair most deployments will never hit this...
by Mukesh Kumar | Feb 15, 2021 | Insight for DBAs, Insight for Developers, MongoDB
MongoDB is one of the most admired and effortless NoSQL databases to set up. Developers want to spend time building the features for their application, and with MongoDB, developers can build the application quickly while utilizing well-supported infrastructure 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 Matt Yonkovit | Feb 9, 2021 | Insight for DBAs, Insight for Developers, MongoDB
A few weeks ago I sat down and talked about tuning MongoDB memory settings with Mike Grayson, one of our MongoDB Database Engineers here at Percona. If you have not seen the video I would recommend it. Since then I have heard from people in the community about other...
