by Brian Sumpter | Jul 1, 2021 | Insight for DBAs, MySQL, Open Source
MySQL 8 brought many highly anticipated features, with support for user roles, a new shell, a more robust data dictionary, and better SQL support, just to name a few. There are lesser-known new features, however, that aim to reduce overall DBA workload and streamline...
by Vinodh Krishnaswamy | Jun 30, 2021 | Insight for DBAs, MongoDB, Percona Software
In every new version of MongoDB, there have been a lot of changes and newly introduced features. One such change is the introduction of setDefaultRWConcern command from MongoDB 4.4. This feature has caused multi-document transaction writes to fail for one of my...
by Lalit Choudhary | Jun 30, 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 Marco Tusa | Jun 15, 2021 | Insight for DBAs, MySQL, Open Source
When trying to make things better, make it very complicated. I was working on a Security Threat Tool script when I had to learn more about the interaction between static and dynamic privileges in MySQL 8. Dynamic privileges is a “new” thing added in MySQL 8 to easily...
by David Ducos | Jun 8, 2021 | Insight for DBAs, MySQL
In my previous post Back From a Long Sleep, MyDumper Lives!, I told you that Fast Index Creation was in the queue and (after fixing several bugs) it will package in release 0.10.7 next month. But why am I so excited about it? Well, this feature opens new...
by Vinicius Grippa | Jun 3, 2021 | Insight for DBAs, MongoDB, Open Source
by Ibrar Ahmed | May 27, 2021 | Insight for DBAs, PostgreSQL
On September 30, 2021, PostgreSQL 14 was released. Need a primer? Umair Shahid recently put together a great overview, PostgreSQL 14 – Performance, Security, Usability, and Observability. Foreign Data Wrapper based on SQL-MED is one the coolest features of PostgreSQL....
by Akira Kurogane | May 18, 2021 | Insight for DBAs, MongoDB, Storage Engine
Most of the files in a data directory of a MongoDB server are made by the WiredTiger storage engine. If you want to look at the content inside them you can use the tool “wt” from the WiredTiger library: https://github.com/wiredtiger/wiredtiger/...
by David Quilty | May 7, 2021 | Cloud, Insight for DBAs, Webinars
Considering a move to the cloud, but unsure which provider is right for you? According to the results of our 2020 Open Source Data Management Software Survey, AWS continues to dominate the public cloud provider market, with 50% of respondents using its cloud platform...
by Yves Trudeau | May 4, 2021 | Insight for DBAs, MySQL, Storage Engine
There is a common pattern in life, you often discover or understand things by accident. Many scientific discoveries fit such a description. In our database world, I was looking to see how BLOB/TEXT columns are allocated using overlay pages and I stumbled upon...
by Lalit Choudhary | Apr 27, 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 Francisco Bordenave | Apr 27, 2021 | Insight for DBAs, MySQL
DBAs are important cogs in the availability, performance, and security of your data. Getting a great DBA is one of the most important things any company can do to ensure their database operations continue working without a problem. So how do you find great DBAs? In...
by Peter Zaitsev | Apr 22, 2021 | Insight for DBAs, Monitoring, Percona Software
A few years ago, I wrote about how to add information about processes to your Percona Monitoring and Management (PMM) instance as well as some helpful ways you can use this data. Since that time, PMM has released a new major version (PMM v2) and the Process Exporter...
by Robert Bernier | Apr 22, 2021 | Insight for DBAs, Open Source, PostgreSQL
These scripts demonstrate the command line interface, CLI, “pg_rewind” re-provisioning a formerly deprecated PRIMARY host, pg1, into a viable STANDBY. Although the scripts have been written expressly for a custom-made set of two Linux containers using...
by David Ducos | Apr 21, 2021 | Insight for DBAs, MySQL, Open Source
MySQL databases keep getting larger and larger. And the larger the databases get, the harder it is to backup and restore them. MyDumper has changed the way that we perform logical backups to enable you to restore tables or objects from large databases. Over the years...
by Sri Sakthivel | Apr 19, 2021 | Insight for DBAs, Insight for Developers, MySQL
MySQL Group Replication is a plugin that helps to implement highly available fault-tolerant replication topologies. In this blog, I am going to explain the complete steps involved in the below two topics. How to convert the group replication member to an asynchronous...
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...
