Percona

NOVEMBER 30, 2023

Encryption is the process of turning data into an unrecognizable format unless the necessary password (also known as passphrase) or decryption key is provided. This blog describes how to encrypt the pgBackRest repository. The repository is where pgBackRest stores backups and archives WAL segments.

Open Source 79

Open Source Database Processing Performance 79

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 77

Servers Open Source Database Systems 77

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 78

Open Source Database Servers Programming 78

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

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 '?' X, but got no.

C++ 105

C++ Servers Storage Speed 105

Percona

MARCH 27, 2023

‘ E11000 duplicate key error ’ is an error that you might have encountered during the restore process. In this blog, we will talk about in what scenario you might face this error when restoring Oplog for PITR (point-in-time recovery). sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1)

Games 94

Games Database Open Source C++ 94

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? We split databases by function/team to give each team full autonomy over their schema, And if someone screws up, it breaks their cluster, not all databases. Version: '8.0.19-10'

Programming 84

Programming Servers Database Hardware 84

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. No manual work!

Engineering 89

Engineering Database Servers Analytics 89

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

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. This is available only for the log_error_verbosity=3.

Monitoring 88

Monitoring Code Open Source Cache 88

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 100

Database Testing Servers Open Source 100

Official Blog - World Web Technology

JUNE 13, 2023

It is the most popular CMS that was earlier used to create personal blogs. However, dedicated WordPress theme developers have made the platform so advanced that businesses look up to WordPress when they want to develop a wide range of web applications such as ecommerce websites, business websites, personal blogs, web applications, etc.

Development 52

Development Website Ecommerce Code 52

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 103

Database Servers Open Source Tuning 103

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 90

Open Source Database Operating System Programming 90

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

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 123

Serverless Software Architecture Virtualization Database 123

Percona

JUNE 23, 2023

In Percona Managed Services , one key aspect of managing the databases is configuring backups. Percona XtraBackup is one of the best tools for performing physical database backups. In order to speed up the backup process along with the compression and encryption, we can use multiple threads.

Servers 80

Servers Processing Speed Open Source 80

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. >pgBackRest is installed and configured on a dedicated backup and database host.

Servers 82

Servers Azure AWS Cloud 82

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

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 66

Open Source Database Storage Engineering 66

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 95

Storage Database Media Open Source 95

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 90

Best Practices Tuning Database Testing 90

Scalegrid

FEBRUARY 15, 2024

In a world where data security is essential, enabling MongoDB SSL is critical in fortifying your database. Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections. Direct net.ssl.PEMKeyFile to the path of your.pem file.

Servers 130

Servers Best Practices Government Network 130

Percona

FEBRUARY 16, 2023

To make the process more secure, they considered removing the local keyring_file after MySQL started. 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 Let me show you why.

Database 117

Database Servers Engineering Testing 117

Percona

DECEMBER 5, 2023

Recently, I was reading a brilliant blog by Perconian David Gonzalez titled The 1-2-3 for PostgreSQL Logical Replication Using an RDS Snapshot , exploring the intricacies of setting up logical replication on Amazon RDS using RDS snapshots. and then set up a PostgreSQL logical replication between a PostgreSQL v12.16 and a v15.4.

Database 77

Database Traffic C++ Servers 77

Percona

MARCH 28, 2023

In this blog post, we will dive deep into WiredTiger’s Logging and Checkpoint mechanism. Every database system has to ensure durability and reliability. Although both the processes (involving disk) might look the same, they have different purposes. Let’s take a look at the process when we start mongod.

Hardware 88

Hardware C++ Storage Cache 88

Percona

SEPTEMBER 27, 2023

First, we will need to install the OS with the necessary control files for the appropriate PostgreSQL version for installing pg_partman on the database. Installation of pg_partman on the database I recommend creating the schema before creating the extension to install the extension’s objects.

Storage 101

Storage Open Source Database Efficiency 101

Percona

APRIL 17, 2023

reaches end of life in October 2023. As a MySQL Principal Architect at Percona, I’ve had several customers over the past few months wanting to begin the upgrade process from 5.7 As a MySQL Principal Architect at Percona, I’ve had several customers over the past few months wanting to begin the upgrade process from 5.7

Open Source 73

Open Source Servers Scalability Database 73

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 81

Latency Tuning Open Source Network 81

Dynatrace

DECEMBER 18, 2023

According to the 2023 Kubernetes in the Wild report , 65% of organizations use Prometheus. An essential observability engineering tool Prometheus is an open-source telemetry database service that records and stores custom software metrics and provides a standardized interface to pull (in Prometheus terms, “scrape”) data using HTTP requests.

Metrics 175

Metrics Engineering Energy Tuning 175

Percona

MARCH 8, 2023

Over the years of being a DBA, I had to deal with all kinds of problems in the database. Still, the users keep falling into this trap, maybe because of a poorly configured database, a change in the application components, or just because of a sudden increase of connections in the application. A lot has been written about this error.

C++ 94

C++ Database Servers Open Source 94

Percona

NOVEMBER 2, 2023

This blog was originally published in Sept 2021 and was updated in November 2023. Following the series of blogs started by Peter Zaitsev in Installing MySQL with Docker , on deploying Docker containers running open source databases, in this article, I’ll demonstrate how to install and run PostgreSQL using Docker.

Database 70

Database Open Source Scalability Virtualization 70

Percona

APRIL 7, 2023

I’ve used a fourth instance to host a PMM server to monitor servers A and B and used the data collected by the PMM agents installed on the database servers to compare performance. That’s a heritage of the LAMP model when the same server would host both the database and the web server. dissecting it a few years ago.

Tuning 135

Tuning Cache Servers Benchmarking 135

Percona

SEPTEMBER 12, 2023

If the changes are not made considering the necessary precautions, you may face unwanted outages on the database that can cause serious problems to your business. In this blog post, I will delve into the most important things to consider while preparing a schema change. Quickly Troubleshoot Metadata Locks in MySQL 5.7

Database 87

Database Traffic Open Source Monitoring 87

Percona

NOVEMBER 1, 2023

This blog was originally published in January 2021 and updated in November of 2023. As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. What is the Recovery Time Objective? ” What is the Recovery Point Objective?

Best Practices 80

Best Practices Storage Strategy Database 80

Percona

JULY 2, 2023

This blog was originally written in September 2018 and was updated in June 2023. The size of the database and your database environment—if it is on colo or cloud—matters. As discussed in the introductory blog post , we highlight important aspects an enterprise should consider for its PostgreSQL environments.

Strategy 52

Strategy Database Storage Open Source 52

Percona

JULY 15, 2023

This blog was originally published in January 2022 and was updated in July 2023. One very common problem when trying to optimize a database environment is index usage. Introduction to MySQL Indexes Indexes in MySQL are database structures used to optimize data retrieval speed and efficiency. Check out this blog here !

Virtualization 78

Virtualization Speed Database Efficiency 78