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 97

Database Open Source Storage Servers 97

Percona

OCTOBER 11, 2023

In this blog post, we will discuss how we can migrate data from MongoDB Atlas to self-hosted MongoDB. Below is the sample log when you start MongoShake: [2023/09/25 21:09:13 UTC] [INFO] New session to mongodb+srv://gautam: @cluster0.teeeayh.mongodb.net/

Database 89

Database Open Source Testing Servers 89

Percona

OCTOBER 20, 2023

This blog post is part two of a multi-post series about using the Citus extension with Percona Distribution for PostgreSQL. You can read part one here: Scalable Solutions With Percona Distribution for PostgreSQL: Set Up Three PostgreSQL Database Instances. Citus maintains seamless integration with PostgreSQL. 1ubuntu1~20.04.1)

Scalability 94

Scalability Database Open Source Systems 94

Percona

OCTOBER 3, 2023

In database management, job scheduling has always played an important role. However, there is another job scheduler called pg_timetable, which is completely database-driven and provides a couple of advanced concepts. In this blog, we are going to highlight some of the main features, installation, and some use cases of pg_timetable.

Open Source 80

Open Source Database Servers Programming 80

Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. The auditing plugin overview has been explained in the blog post Percona’s MySQL Audit Log Plugin – An Enterprise Feature at a Community Price. How does it work? The drop events are listed below. The drop events are listed below.

Servers 86

Servers Database Open Source Scalability 86

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 77

Hardware C++ Database Open Source 77

Percona

NOVEMBER 30, 2023

This blog describes how to encrypt the pgBackRest repository. pgBackRest is the backup tool used to perform Postgres database backup, restoration, and point-in-time recovery (PITR). HINT: backup.info cannot be opened and is required to perform a backup. The repository is where pgBackRest stores backups and archives WAL segments.

Open Source 81

Open Source Database Processing Performance 81

Percona

JULY 17, 2023

MongoDB Community Edition software might set the stage for achieving your high-volume database goals, but you quickly learn that its features fall short of your enterprise needs. First, some stage-setting for this blog article. The popularity of MongoDB MongoDB has emerged as a popular database platform. It ranks No.

Open Source 77

Open Source Database Scalability Software 77

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 122

AWS Storage Database Open Source 122

Percona

DECEMBER 14, 2023

In this blog post, we will look into the steps of transforming an existing PostgreSQL streaming replication node into a logical replication node. Create a logical replication slot on the primary node. In the below log file, the LSN is 0/7000640. s, system: 0.01 s, elapsed: 1638.50 In the below log file, the LSN is 0/7000640. s, system: 0.01

Servers 79

Servers Open Source Database Systems 79

Percona

OCTOBER 31, 2023

Percona has a mission to provide the best open source database software, support, and services so our users can innovate freely. The feedback from users was that “backup management is a must ” and “we need something that allows us to manage all of our database backups in one place, not server by server.”

Open Source 91

Open Source Database Operating System Programming 91

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++ 107

C++ Servers Storage Speed 107

Percona

DECEMBER 12, 2023

This blog gives you some ideas on using pt-table-sync for replica tables with triggers. sec) mysql> select * from test_tab; select * from test_tab_log; + -+ --+ + | id | test_data | op_time | + -+ --+ + | 1 | lt1 | 2023-11-26 09:59:19 | + -+ --+ + 1 row in set (0.00 We have two tables: test_tab and test_tab_log.

Servers 93

Servers Database Testing Open Source 93

Percona

MARCH 27, 2023

In this blog, we will talk about in what scenario you might face this error when restoring Oplog for PITR (point-in-time recovery). You might wonder why this error will come during PITR as the operations in the Oplog are idempotent, meaning they always result in the same change to the database no matter how many times they’re performed.

Games 96

Games Database Open Source C++ 96

Percona

SEPTEMBER 14, 2023

MySQL is an outstanding open source transactional database used by most web-based applications and is very good at handling OLTP workloads. ClickHouse is a columnar database that handles analytical workloads quickly. In this blog post, I will show you how to replicate MySQL data in real-time to ClickHouse.

Engineering 90

Engineering Database Servers Analytics 90

Percona

DECEMBER 20, 2023

In this blog post, we will go through the process of InnoDB buffer pool resizing online, covering why it is important to monitor its progress and how to monitor it. 2023-12-05T16:51:29.610886Z 65 [Note] [MY-012398] [InnoDB] Requested to resize buffer pool. Importance of monitoring the InnoDB buffer pool resize Since MySQL 5.7.5,

Monitoring 90

Monitoring Code Open Source Cache 90

Percona

APRIL 13, 2023

PostgreSQL is a popular open source relational database management system that is widely used for storing and managing data. In this blog, we will discuss what replication lag is, why it occurs, and how to mitigate it in PostgreSQL. Various factors, such as the distance between the databases, network congestion, etc.,

Latency 83

Latency Tuning Open Source Network 83

Percona

AUGUST 18, 2023

This blog describes how to configure systemd for multiple instances of MySQL. Why not just create another database on the same instance? You can have a host with two or three instances configured as a delayed replica of the source server with SQL Delay of, let’s say, 24hr, 12hr, and 6/3hrs. Version: '8.0.19-10'

Programming 86

Programming Servers Database Hardware 86

Official Blog - World Web Technology

APRIL 12, 2023

Earlier, it was used to simply create online blogs, but WordPress has evolved since then. Also, WordPress development is simple like the blogs you used to create on it. When you click on Publish, you will see a webpage and not a blog. MySQL MySQL is a database that every WordPress developer should know of.

Development 52

Development Website Ecommerce Programming 52

Percona

MARCH 28, 2023

Our previous blogs discussed configuring and setting up backups using the pgBackRest solution. To briefly explain pgBackRest, it is an open source backup tool that takes FULL Backup, Incremental Backup, and Differential Backup for PostgreSQL databases. Let’s discuss a few scenarios one by one.

Servers 84

Servers Azure AWS Cloud 84

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. It has default settings for all of the database parameters. It has default settings for all of the database parameters. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload.

Tuning 52

Tuning Efficiency Database Performance 52

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

SEPTEMBER 27, 2023

PostgreSQL Partition Manager — ‘pg_partman’ — is an open source extension freely available, widely supported, and actively maintained by the PostgreSQL community. Installation of pg_partman on the database I recommend creating the schema before creating the extension to install the extension’s objects.

Storage 102

Storage Open Source Database Efficiency 102

Percona

AUGUST 18, 2023

This blog will explore the hurdles encountered during the upgrade process and the innovative solution that saved the day. 2023-05-12T08:10:38.946611Z 1 [ERROR] [MY-013894] [InnoDB] Found redo log file./ib_logfile0 2023-05-12T08:10:38.946683Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.

Open Source 67

Open Source Database Storage Engineering 67

Percona

AUGUST 30, 2023

In this blog, I am trying to list the options available for users and list them in increasing order of priority. This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. 2023-08-04 06:53:09.637 UTC [5787] LOG: starting PostgreSQL 15.3 And there could be conflicts.

Database 105

Database Servers Open Source Tuning 105

Percona

MARCH 3, 2023

And this is how this blog originates so that if you find yourself in the same situation, proceed similarly or at least consider some of the practices used to meet the objective. Check the database’s topology, whether one or more servers were replicating, if it was a Percona XtraDB Cluster , etc. Check the size of the table.

Database 102

Database Testing Servers Open Source 102

Percona

APRIL 17, 2023

reaches end of life in October 2023. Reserved keyword – Groups Most notably, and the issue my customers are facing (and the primary reason for this blog post), is the addition of GROUPS as a reserved keyword. You can read more about reserved keywords in a previous blog, MySQL 5.7 Upgrading to MySQL 8 from 5.7

Open Source 75

Open Source Servers Scalability Database 75

Adrian Cockcroft

FEBRUARY 9, 2023

Picture by Adrian — Ka’anapali sunset 2023 There’s been a lot of discussion about platforms recently, I talked about why I think it’s a current hot meme on the WTF Podcast with Charles Humble recently, and Sam Newman just wrote a blog post “ Don’t call it a platform ”.

Engineering 137

Engineering Serverless Lambda AWS 137

Percona

AUGUST 29, 2023

In this blog post, we will explore the immense value of provisioning PostgreSQL clusters with Percona Operator by using bootstrap capabilities: Start the cluster with init SQL script Bootstrap the cluster from the existing cluster or backup Getting started You need to have the Percona Operator for PostgreSQL deployed.

Storage 97

Storage Database Media Open Source 97

Percona

JUNE 7, 2023

Triggers on Data Definition Language (DDL) events are a powerful feature of PostgreSQL that allows you to perform additional actions in response to changes to the database schema. DDL events include operations such as CREATE, ALTER, and DROP statements on tables, indexes, and other database objects.

Database 77

Database Best Practices Open Source C++ 77

Percona

AUGUST 29, 2023

Data redundancy, a database version of a RAID Pondering the case of high availability and redundancy, one replicates data by creating a replica via streaming replication. Extension citus has been created in database db01. Now let’s stretch our imagination and consider a second method of high availability, ala Citus.

C++ 81

C++ Database Storage Testing 81

Percona

APRIL 6, 2023

In this blog post, we’ll check how to integrate Percona Monitoring and Management (PMM) with Loki to be able to get not only metrics and queries from our database servers but also text-based information like logs. Mar 15 19:02:59 ps promtail[2318]: level=info ts=2023-03-15T19:02:59.437567482Z caller=filetargetmanager.go:352

Monitoring 87

Monitoring Servers Metrics Database 87

Dynatrace

DECEMBER 18, 2023

According to the 2023 Kubernetes in the Wild report , 65% of organizations use Prometheus. Another source reported a 43% overall increase in Prometheus adoption for the last six months of 2021. To set the stage, let’s have a quick recap of what Prometheus is and what it does. What is Prometheus? Please stay tuned!

Metrics 175

Metrics Engineering Energy Tuning 175

Percona

DECEMBER 19, 2023

In this blog post, we will talk about the steps to configure alerts for some well-known communication platforms like Telegram , Slack , and WebHook. Percona Monitoring and Management is a best-of-breed open source database monitoring solution. Please note that I am not covering the basic alerting and configuration setup.

Monitoring 92

Monitoring Database Open Source Java 92

Percona

JULY 1, 2023

This post was originally published in July 2018 and was updated in July 2023. Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? What are the differences between Aurora and RDS?

AWS 52

AWS Database Serverless Storage 52

Percona

JUNE 29, 2023

When all data-bearing replica set members are available, and the index is created with default commitQuorum , below are the details from the Primary and the Secondary nodes. Status of nodes: rs1:PRIMARY> rs.status().members.forEach(function members.forEach(function (d) {print(d.name) + " " + print(d.stateStr)}); 127.0.0.1:27017

Servers 82

Servers C++ Storage Best Practices 82

Percona

JULY 6, 2023

Performance is one of the essential aspects of a database management system. One way to verify a column’s number of distinct values is by querying the pg_stats view in our database. One of the most effective ways to tackle performance improvement is having the proper indexes for the table columns.

Best Practices 92

Best Practices Tuning Database Testing 92