Percona

APRIL 28, 2023

Let’s start with a simple introductory comparison: With proprietary (closed source) database software, the public does not have access to the source code; only the company that owns it and those given access can modify it. Myth #2: Proprietary databases are better and therefore more suitable for large enterprises.

Open Source 119

Open Source Database Software Software 119

Percona

FEBRUARY 23, 2023

If you ever had to make a quick ad-hoc backup of your MongoDB databases, but there was not enough disk space on the local disk to do so, this blog post may provide some handy tips to save you from headaches. while not overloading the CPU capacity on the production database. zst 2023-02-07T19:33:58.138+0100 writing db2.products

AWS 125

AWS Storage Database Open Source 125

Percona

FEBRUARY 13, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Today’s post includes those releases and updates that have come out since January 30, 2023. was released on February 9, 2023.

Open Source 89

Open Source Database Servers Scalability 89

Percona

AUGUST 21, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Today’s post includes those releases and updates that have come out since August 7, 2023.

Open Source 87

Open Source AWS Servers Database 87

Percona

OCTOBER 31, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Today’s post includes those releases and updates that have come out since October 16, 2023.

Monitoring 85

Monitoring Open Source Scalability Database 85

Percona

DECEMBER 14, 2023

Will 2023 be called the year of Generative Artificial Intelligence (AI)? I played a bit with ChatGPT in February to see how it would respond to random database-related inquiries, and I found it pretty impressive and annoying at the same time. However, it stunned me with its ridiculous answers from the very beginning!

Database 93

Database Artificial Intelligence Servers Operating System 93

Percona

JUNE 12, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Today’s post includes those releases and updates that have come out since May 29, 2023.

Open Source 88

Open Source Servers Database Scalability 88

Percona

JANUARY 30, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Today’s post includes those releases and updates that have come out since January 9, 2023. was made available on January 23, 2023.

Open Source 91

Open Source Storage AWS Cloud 91

Percona

DECEMBER 4, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Today’s post includes those releases and updates that have come out since November 13, 2023.

Open Source 86

Open Source Azure Servers Programming 86

Percona

SEPTEMBER 18, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Today’s post includes those releases and updates that have come out since September 4, 2023.

Open Source 86

Open Source Servers Database Scalability 86

Percona

MARCH 27, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Today’s post includes those releases and updates that have come out since March 13, 2023. was released on March 23, 2023.

Open Source 83

Open Source Servers Scalability Cache 83

Percona

MAY 8, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Today’s post includes those releases and updates that have come out since April 24, 2023.

Monitoring 82

Monitoring Open Source Database Servers 82

Percona

JULY 10, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Today’s post includes those releases and updates that have come out since June 26, 2023.

Monitoring 82

Monitoring Open Source Database Scalability 82

Percona

SEPTEMBER 4, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Today’s post includes those releases and updates that have come out since August 21, 2023.

Open Source 83

Open Source Scalability Database Software 83

Percona

APRIL 10, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Today’s post includes those releases and updates that have come out since March 27, 2023. was released on March 27, 2023.

Open Source 83

Open Source Servers Database AWS 83

Percona

OCTOBER 16, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Today’s post includes those releases and updates that have come out since October 2, 2023.

Servers 80

Servers Monitoring Open Source Scalability 80

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 99

Open Source Database Strategy Hardware 99

Percona

MARCH 3, 2023

Check the database’s topology, whether one or more servers were replicating, if it was a Percona XtraDB Cluster , etc. The person who tried to run this in production did not do the following: Run some previous backups of the rows to delete. Check if the table had referential integrity, child tables. Check the size of the table.

Testing 106

Testing Database Servers Open Source 106

Percona

FEBRUARY 27, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Today’s post includes those releases and updates that have come out since February 13, 2023. was released on February 15, 2023.

Monitoring 74

Monitoring Open Source Database Software 74

Percona

MARCH 30, 2023

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

Open Source 81

Open Source Database Storage Scalability 81

Percona

OCTOBER 11, 2023

I created a test account (replica set) and loaded sample data with one click in Atlas: Create an account in Atlas. Atlas atlas-mhnnqy-shard-0 [primary] test> show dbs sample_airbnb 52.69 GiB Atlas atlas-mhnnqy-shard-0 [primary] test> An EC2 instance with PSMDB installed. Prerequisites: A MongoDB Atlas account.

Database 93

Database Open Source Testing Servers 93

Percona

FEBRUARY 16, 2023

keyring_file_data=/var/lib/mysql/keyring_file mysql> create database test; mysql> show create schema testG 1. row Database: test Create Database: CREATE DATABASE `test` /*!40100 2023-02-09T00:14:56.719170Z 1 [ERROR] [MY-012226] [InnoDB] Encryption information in datafile: /test/t1.ibd

Database 123

Database Servers Engineering Testing 123

Percona

SEPTEMBER 25, 2023

PostgreSQL is a powerful and popular open source relational database management system. Ensuring the safety of your PostgreSQL data through regular backups is an important concern for database administrators. The /etc/pgbackrest/pgbackrest.conf file contains crucial information related to our primary database server.

Database 101

Database Open Source Storage Servers 101

Dynatrace

MAY 8, 2023

In fact, the Dynatrace 2023 CIO Report found that 78% of respondents deploy software updates every 12 hours or less. The process involves monitoring various components of the software delivery pipeline, including applications, infrastructure, networks, and databases. 54% reported deploying updates every two hours or less.

DevOps 231

DevOps Efficiency Monitoring Infrastructure 231

Percona

SEPTEMBER 19, 2023

This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. Physical backups are the backups that consist of raw copies of the directories and files that store database contents. Copyright (c) 2016, 2023, Oracle and/or its affiliates. Type 'help' or '?'

C++ 112

C++ Servers Storage Speed 112

Percona

MARCH 21, 2023

Announcement I will be speaking at Percona Live 2023 about serverless PostgreSQL. In the context of databases, a tenant’s data can be logically separated from other tenants’ data in the same database so that each tenant can only access and manage their own data. Join us at this event if you are interested!

Serverless 129

Serverless Software Architecture Virtualization Database 129

Percona

OCTOBER 19, 2023

In this guide, we will demonstrate how to establish a Citus database spanning multiple nodes by using Percona Distribution for PostgreSQL. This setup empowers your database to efficiently manage increased data volumes, enhance performance, and maintain availability. 1ubuntu1~20.04.1) 1ubuntu1~20.04.1)

Scalability 91

Scalability Database Open Source Traffic 91

The Netflix TechBlog

JANUARY 10, 2024

This release candidate then went through exhaustive testing which attempted to cover as large a surface area as possible. This testing stage took about two weeks. The results are saved to a database so they can be reused. Every two weeks, a “snapshot” of all modules was taken, and promoted to be a “release candidate”.

Processing 240

Processing Media Latency Innovation 240

Percona

DECEMBER 12, 2023

In my lab, we have two test nodes with replication setup, and both servers will have Debian 11 and Percona Server for MySQL 8.0.33 (with Percona Toolkit) installed. Creating the test tables and the AFTER INSERT trigger Create the below table and trigger on PRIMARY, and it will replicate down to REPLICA.

Servers 96

Servers Database Testing Open Source 96

Percona

OCTOBER 20, 2023

You can read part one here: Scalable Solutions With Percona Distribution for PostgreSQL: Set Up Three PostgreSQL Database Instances. Citus is an open-source extension for PostgreSQL that expands its capacity to manage databases of varying scales, ranging from individual nodes to extensively distributed database clusters.

Scalability 98

Scalability Database Open Source Systems 98

Percona

MAY 15, 2023

The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. In shard-nothing, each shard can live in a totally separate logical schema instance / physical database server/data center/continent. The POC Why this POC?

Traffic 128

Traffic Scalability Database Servers 128

Percona

JULY 5, 2023

EOL is set for the end of October 2023. Long database service downtime Some queries become slow Applications stop working due to incompatibilities Data loss This is what can happen if MySQL’s major upgrade to 8.0 For example, while it is possible to test read workload, it is pretty difficult to test things write-related.

C++ 123

C++ Database Servers Testing 123

Percona

MAY 16, 2023

As a database administrator, have you ever been in a situation when your database confronted a brute force attack? Testing and monitoring the connections First terminal: Note, here we will add a minimum one-second delay and set the failed connection threshold to three. suffix for your platform as necessary. and Newer

Servers 124

Servers Database Monitoring Testing 124

HammerDB

APRIL 4, 2023

Hammerpost is a HammerDB contribution project from @dineshkumar02 that wraps HammerDB with an automated framework to rapidly prototype multiple combinations of database parameters to find the optimal configuration for any specific environment. Firstly, we will check that we can start our database. remote: Enumerating objects: 38, done.

Benchmarking 85

Benchmarking Database Metrics Code 85

Percona

JUNE 26, 2023

We have faced different levels of corruption related to databases in PostgreSQL. Though it is not at all recommended to touch the / data / base / directory and go through files under this / var / lib / postgresql / 14 / main / base / , however, sometimes it happens.

Hardware 80

Hardware C++ Database Open Source 80

HammerDB

MARCH 25, 2023

When you list the HammerDB directory you can now see a directory called “scripts” This directory contains CLI scripts to build, run, delete and query TPROC-C and TPROC-H workloads against all databases. If HammerDB is running on a separate system from the database under test then you should modify this value accordingly.

C++ 84

C++ Virtualization Benchmarking Database 84

Percona

OCTOBER 2, 2023

You can get summaries of your database servers, or you verify replication lag on MySQL and PostgreSQL servers. You get thirty-eight scripts that can do any manner of actions, and you will find them very valuable in your regular database work. And did I mention they are open source?! pt-summary --user=root [?2004l# virtual = 2.2G

Cache 106

Cache Database Virtualization Servers 106