by Mike Benshoof | Sep 28, 2021 | Insight for DBAs, Insight for Developers, MySQL
In a previous post, A Horizontal Scalability Mindset for MySQL, I discussed the concerns around growing individual MySQL instances too large and some basic strategies: Optimizing/minimizing size with proper data types Removing unused/duplicate indexes Keeping your...
by Sri Sakthivel | Sep 22, 2021 | Insight for DBAs, MySQL
MySQL 8 comes with a lot of good features, and recently I explored its password management systems. I wanted to put together a series of blogs about it, and this is the first part. In this post, I am going to explain the following topics in detail. Password Reuse...
by Ivan Groenewold | Sep 22, 2021 | Cloud, Database Trends, Insight for DBAs, Open Source
This article is meant to provide a high-level overview of how a web-based application is commonly structured nowadays. Keep in mind the topic presented is very simplified. It is meant as an introduction only and hopefully encourages the reader to investigate some of...
by Lalit Choudhary | Jul 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 Kimberly Wilkins | Jul 8, 2021 | Insight for DBAs, MongoDB
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...
