by Bhargav Kamineni | May 8, 2023 | Insight for DBAs, PostgreSQL
In simpler terms, logical replication in PostgreSQL is a way to copy data from one database to another in a more flexible and customizable manner compared to physical replication. Instead of copying the entire database, logical replication focuses on replicating...
by Vinicius Grippa | Apr 17, 2023 | Insight for DBAs, MongoDB
In this blog post, we will discuss the best practices on the MongoDB ecosystem applied at the Operating System (OS) and MongoDB levels. We’ll also go over some best practices for MongoDB security as well as MongoDB data modeling. The main objective of this post is to...
by Matt Kane | Nov 25, 2022 | MySQL
Shopping mayhem on the day after Thanksgiving exploded in the 1950s and ’60s, with cops dubbing it Black Friday. Internet shopping put Cyber Monday in the retail lexicon 17 years ago. In 2010, a credit card company coined (pun intended) the title Small Business...
by Bhargav Kamineni | Nov 15, 2022 | Insight for DBAs, PostgreSQL
In one of our previous posts—pgBackRest: A Great Backup Solution and a Wonderful Year of Growth—we discussed the installation of pgBackRest and the backup, quick restore command. It would be ideal to have a restoration activity scheduled as per business needs so that...
by Mukesh Kumar | Oct 17, 2022 | Insight for DBAs, MongoDB, Percona Software
In this blog post, we will discuss delayed members of a replica set and how it can be useful. A delayed member of the replica set is similar to like other members of the replica set but its data set mirrors the set delayed state of the data. Let’s say if a delayed...
by Aaditya Dubey | Sep 28, 2022 | 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 Aleksandra Abramova | Sep 21, 2022 | Insight for DBAs, Insight for Developers, Open Source, Percona Software
October is close, and it is time for Hacktoberfest! If you love open source as much as we do, this event is created for you. It is a unique opportunity to be a part of a great open source community. And you get not only a memorable experience but also some fantastic...
by Ninad Shah | Jun 30, 2022 | Database Trends, Insight for DBAs, Open Source
Though I am writing this post being a PostgreSQL DBA, this page can be read by anyone because the concept of corruption is the same in every database. After reading this blog post, one should understand what database corruption is and how it may occur. Being DBAs,...
by Aaditya Dubey | Jun 24, 2022 | 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 Mukesh Kumar | Jun 3, 2022 | Insight for DBAs, MongoDB, Percona Software
In this blog post, we will discuss how can we migrate from a replica set to sharded cluster. Before moving to migration let me briefly explain Replication and Sharding and why do we need to shard a replica Set. Replication: It creates additional copies of data and...
by Lalit Choudhary | Feb 24, 2022 | 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 Lalit Choudhary | Nov 26, 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 Charly Batista | Nov 18, 2021 | Insight for DBAs, Insight for Developers, PostgreSQL
Welcome to a weekly blog where I get to answer (like, really answer) some of the questions I’ve seen in the webinars I’ve presented lately. If you missed the latest one, PostgreSQL Performance Tuning Secrets, it might be helpful to give some of it a listen before or...
by Oleksandr Miroshnychenko | Oct 19, 2021 | Insight for DBAs, MongoDB, Percona Software
Following this series of blog posts started by Evgeniy Patlan: How to Manually Build Percona Server for MySQL RPM Packages How to Build Percona Server for MySQL From Sources we’ll show you how to build Percona Server for MongoDB for various operating systems¹...
by Lalit Choudhary | Sep 29, 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 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
