by Matt Yonkovit | Dec 15, 2020 | Database Trends, Insight for DBAs, Open Source
Covid-19 has had a significant impact on most aspects of our lives in 2020. Although some companies saw unexpected growth due to offering in-demand tools or services, I think most of us will be happy to draw a line under 2020 and hope for a better 2021. In the spirit...
by Vinicius Grippa | Dec 2, 2020 | Insight for DBAs, MySQL, Percona Software
The benefits of jemalloc versus glibc memory allocator for use with MySQL have been widely discussed. With jemalloc (along with Transparent Huge Pages disabled) there is less memory fragmentation, and thus more efficient resource management of the server memory. For...
by Jobin Augustine | Dec 1, 2020 | Insight for DBAs, Percona Software, PostgreSQL
In one of my previous blog posts, Why PostgreSQL WAL Archival is Slow, I tried to explain three of the major design limitations of PostgreSQL’s WAL archiver which is not so great for a database with high WAL generation. In this post, I want to discuss how...
by Peter Zaitsev | Nov 23, 2020 | Insight for DBAs, Insight for Developers, MySQL
If I ask you if running EXPLAIN on the query can change your database, you will probably tell me NO; it is common sense. EXPLAIN should show us how the query is executed, not execute the query, hence it can’t change any data. Unfortunately, this is the case where...
by Brandon Fleisher | Nov 23, 2020 | Insight for DBAs, Monitoring, Open Source, Percona Software
In the first quarter of 2021 (expected late January), Percona is slated to release a version of Percona Monitoring and Management (PMM) v2 that will include all of the critical functionality users of PMM v1 have come to know and love over the years. While PMM v2 has...
by Rick Vasquez | Nov 17, 2020 | Database Trends, Insight for DBAs, Open Source, Percona Services
It’s that time of year! The Halloween decorations have come down and the leaves have started to change and the Black Friday/Cyber Monday buying season is upon us! For consumers, it can be a magical time of year, but for those of us that have worked in e-commerce or...
by Vadim Tkachenko | Nov 12, 2020 | Cloud, Insight for DBAs, Open Source
I wrote about the usage of OpenEBS to manage local storage in Kubernetes in my previous posts: Deploying Percona Kubernetes Operators with OpenEBS Local Storage OpenEBS for the Management of Kubernetes Storage Volumes The primary reason to use the local storage is...
by Ivan Groenewold | Nov 10, 2020 | Insight for DBAs, MongoDB, Percona Software
Percona Backup for MongoDB (PBM) is our open source tool for backing up MongoDB clusters. Initially, the tool was developed for restoring the backups in the same environment they are taken. In this post, I will show you how to restore a backup to a new environment...
by Vadim Tkachenko | Nov 9, 2020 | Cloud, Insight for DBAs, Insight for Developers, Open Source
I recently wrote about OpenEBS in regard to local volumes in my post Deploying Percona Kubernetes Operators with OpenEBS Local Storage. And there are also my recent blog posts about Kubernetes, Percona Operators, and storage management problems: Using Volume...
by Daniil Bazhenov | Nov 9, 2020 | Insight for DBAs, MySQL, Open Source, PostgreSQL
Percona University Online has released its second free course, “A Deep Dive Into PostgreSQL Indexes” by Ibrar Ahmed, Senior Software Engineer at Percona. Indexes are a basic feature of relational databases. PostgreSQL offers a rich collection of index...
by Mani Paluru | Nov 6, 2020 | Insight for DBAs, Insight for Developers, MySQL
Mysqlpump is a client program that was released with MySQL 5.7.8 and is used to perform logical backups in a better way. Mysqlpump supports parallelism and it has the capability of creating compressed output. Pablo already wrote a blog about this utility (The...
by Vadim Tkachenko | Nov 5, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
In my talk on Percona Live (download the presentation), I spoke about how we can use Percona Kubernetes Operators to deploy our own Database-as-Service, based on fully OpenSource components and independent from any particular cloud provider. Today I want to mention an...
by Dawn Heiberg | Nov 3, 2020 | Cloud, Database Trends, Insight for DBAs
In this year’s Open Source Data Management Software survey, we asked organizations “What issues have you experienced in the last 12 months?” The main issue, flagged by three-quarters of respondents, was performance. Given the adverse impact that data slowdown has on...
by Matthew Boehm | Nov 3, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
So you’ve just added some more memory to your MySQL server; now what? If you’ve been around the MySQL block for a while, you know that nothing is automatically changed to take advantage of this new system RAM. Let’s have a look at a few parameters...
by David Quilty | Nov 3, 2020 | Cloud, Insight for DBAs, MongoDB, Percona Software, Webinars
There are many potential benefits to moving to the cloud such as increasing resources on the fly, multi-region infrastructure, and hardware maintenance, to mention only a few. On the other hand, there are critical points such as security (the latest was MEOW attack),...
by Peter Zaitsev | Nov 2, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
Understanding how MySQL uses memory is key to tuning it for optimal performance as well as troubleshooting cases of unexpected memory usage, i.e. when you have MySQL Server using a lot more than you would expect based on your configuration settings. Early in MySQL...
by Lalit Choudhary | Oct 30, 2020 | Insight for DBAs, Insight for Developers, Percona Software
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 form,...
by Arunjith Aravindan | Oct 27, 2020 | Insight for DBAs, Insight for Developers, MySQL
This blog discusses new features about the persisted system variables and how we can use it to make variable changes persistent. The MySQL server maintains system variables that control its operations. The dynamic variables used prior to the MySQL 8 release are not...
by Sri Sakthivel | Oct 26, 2020 | Insight for DBAs, Insight for Developers, MySQL
MySQL 8.0.22 was released on Oct 19, 2020, and came with nice features and a lot of bug fixes. Now, you can configure your async replica to choose the new source in case the existing source connection (IO thread) fails. In this blog, I am going to explain the entire...
by Paul Jacobs | Oct 26, 2020 | Insight for DBAs, Insight for Developers, Monitoring, Percona Software
Percona is making changes in its documentation processes for Percona Monitoring and Management (PMM) to make it easier and more welcoming for community members to contribute to our documentation. Percona Monitoring and Management (PMM) is a free, open-source database...
