Percona

FEBRUARY 2, 2023

PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server. The pg_hba.conf file is used to configure the authentication methods the PostgreSQL server uses and can specify different methods for different types of connections.

Database 124

Database Servers Testing Programming 124

Percona

SEPTEMBER 25, 2023

PostgreSQL is a powerful and popular open source relational database management system. In this blog post, we’ll explore a technique to help your backup strategy: running pgBackRest’s expire and backup processes in parallel while utilizing custom lock-file paths. This lock-path is utilized during backup operations.

Database 94

Database Open Source Storage Servers 94

Percona

OCTOBER 3, 2023

In this blog, we are going to highlight some of the main features, installation, and some use cases of pg_timetable. Main features of pg_timetable Fully database-driven configuration Cron-style scheduling at the PostgreSQL server time zone Built-in tasks such as sending emails, etc. psql psql (12.16) Type "help" for help.

Open Source 78

Open Source Database Servers Programming 78

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. Steps to convert streaming replication to logical replication: The lab setup includes two servers: primary (172.31.46.28) and standby (172.31.39.50), currently configured with streaming replication.

Servers 77

Servers Open Source Database Systems 77

Percona

OCTOBER 11, 2023

In this blog post, we will discuss how we can migrate data from MongoDB Atlas to self-hosted MongoDB. There are a couple of third-party tools in the market to migrate data from Atlas to Pecona Server for MongoDB (PSMDB), like MongoPush, Hummingbird, and MongoShake.

Database 87

Database Open Source Testing Servers 87

Percona

SEPTEMBER 19, 2023

Now, since backup speed and compactness are important for busy, important databases, Percona’s open source physical backup solution – Percona XtraBackup (PXB) , takes into account all these aspects and benefits MySQL world with its exceptional capabilities! Copyright (c) 2016, 2023, Oracle and/or its affiliates.

C++ 105

C++ Servers Storage Speed 105

Percona

DECEMBER 22, 2023

was released on December 21, 2023. This blog post covers the main changes in this release. Quality improvements In my last Percona Toolkit release blog, What’s New in Percona Toolkit 3.5.5 , I wrote about how we plan to make regression tests part of the release process. 2023-12-21T15:29:22 Creating triggers.

Operating System 96

Operating System Programming Open Source Testing 96

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. 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 92

Scalability Database Open Source Systems 92

Percona

JUNE 26, 2023

To restore, we can follow either of below approaches: If the standby server is there and the issue does not persist on that, then we can fix the issue by taking logical backup from the standby server, dropping the table on primary, and recreating it using the backup taken. Download Percona Distribution for PostgreSQL Today!

Hardware 75

Hardware C++ Database Open Source 75

Percona

DECEMBER 12, 2023

Sometimes, the replica server might have replication errors, and the replica might be out of sync with the primary. In this case, we can use Percona Toolkit’ s pt-table-checksum and pt-table-sync to check the data drift between primary and replica servers and make the replica in sync with the primary. The print result is good.

Servers 91

Servers Database Testing Open Source 91

Percona

JULY 17, 2023

In this blog, we’ll examine the reasons why people would seek an alternative to MongoDB Enterprise, and we’ll identify some of the most popular NoSQL alternatives. First, some stage-setting for this blog article. 1 among non-relational/document-based systems ( DB-Engines, July 2023 ). It ranks No.

Open Source 76

Open Source Database Scalability Software 76

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. I recommend you read our previous blog, Using ClickHouse as an Analytic Extension for MySQL , from Vadim to know more about this. The blog post contains the following topics.

Engineering 88

Engineering Database Servers Analytics 88

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. zst 2023-02-07T19:33:58.138+0100 writing db2.products products to archive on stdout 2023-02-07T19:33:58.140+0100 writing db2.people

AWS 120

AWS Storage Database Open Source 120

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 87

Monitoring Code Open Source Cache 87

Percona

AUGUST 18, 2023

This blog describes how to configure systemd for multiple instances of MySQL. Why do you need multiple instances on the same server? 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. AFAIK Facebook does this.

Programming 85

Programming Servers Database Hardware 85

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 89

Open Source Database Operating System Programming 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. The post What Skills Are Required For WordPress Developer In 2023?

Development 52

Development Website Ecommerce Programming 52

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 74

Open Source Servers Scalability Database 74

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). ‘ E11000 duplicate key error ’ is an error that you might have encountered during the restore process. sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1)

Games 94

Games Database Open Source C++ 94

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. Promtail will be in charge of reading the log files and sending new information to the Loki server.

Monitoring 86

Monitoring Servers Metrics Database 86

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. 23] (Slave_delay: 0) This means the following: A primary server, with Percona Server for MySQL installed (in Read/Write mode) version 8.0.31-23.

Database 99

Database Testing Servers Open Source 99

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

JUNE 23, 2023

I won’t get into the details about how those should be configured as that depends on every scenario, but generally, we could use as many threads as CPUs on the server. If you have multiple CPUs on the server, you can increase the number of threads for each operation. dbxxxx/tb1.ibd

Servers 81

Servers Processing Speed Open Source 81

Percona

OCTOBER 10, 2023

In this blog post, I’ll provide some thoughts on how schema changes can be performed when running MySQL on Kubernetes I won’t focus on DIRECT ALTERs as it is pretty straightforward to apply them. Your MySQL connection id is 256 Server version: 8.0.32-24.2 2023-07-26T12:22:43 Copying approximately 4 rows. email`, NEW.`birthdate`,

Database 95

Database Performance C++ Engineering 95

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. One of the common issues that can be encountered in PostgreSQL is replication lag.

Latency 81

Latency Tuning Open Source Network 81

Percona

OCTOBER 4, 2023

was released on October 3, 2023. This blog post covers the main changes in this release. They include more vulnerabilities than Open Source tools that we use, can find, and help us improve the quality of Go-based tools. Percona Toolkit 3.5.5 Quality control is not only about code fixes but also about testing.

Open Source 100

Open Source Code Testing Systems 100

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. The most common parameter used by the PostgreSQL server (postmaster) will be PGDATA, which sets the parameter data_directory. 2023-08-04 06:53:09.637 UTC [5787] LOG: starting PostgreSQL 15.3 20150623 (Red Hat 4.8.5-44),

Database 102

Database Servers Open Source Tuning 102

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Therefore, DBAs must take a piecemeal approach to achieve HA with PostgreSQL, bringing together open source extensions and tools from multiple sources. there cannot be high availability.

Availability 84

Availability Open Source Architecture Database 84

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). MariaDB Server, on the other hand, is a fork of MySQL 5.5. What is MariaDB? Contact us to learn more!

Open Source 52

Open Source Servers Storage Scalability 52

Percona

JULY 19, 2023

In this blog post, we will explore how to deploy the Percona Operator for PostgreSQL v2 using GitOps and ArgoCD. I did the following: kubectl create namespace argocd kubectl apply -n argocd -f [link] Expose the ArgoCD server. Server Side sync Percona relies on OpenAPI v3.0 ArgoCD supports Server-Side apply.

Servers 79

Servers Best Practices DevOps Open Source 79

Percona

JUNE 28, 2023

This blog post is a warning tale, an invitation to try yourself and break stuff (not in production, right?). First error to notice: 2023-06-22T08:00:48.322148Z 0 [ERROR] [MY-000000] [Galera] It may not be safe to bootstrap the cluster from this node. sandbox server started At this point, notice that from node1, you have: $./sandboxes/pxc_msb_8_0_31/node1/use

C++ 77

C++ Open Source Servers Monitoring 77

Official Blog - World Web Technology

NOVEMBER 24, 2023

In this blog, we shall discuss the three popular JavaScript frameworks (ReactJS vs NodeJS vs AngularJS). It is a JavaScript library that is open-source and popularly used to construct user interfaces (UIs) for the development of web applications. is an open-source, cross-platform with runtime environment of JavaScript.

Development 52

Development Virtualization Open Source Architecture 52

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. 2023-11-08 05:31:06.030 UTC [108718] LOG: listening on IPv4 address "0.0.0.0", port 5433.

Database 77

Database Traffic C++ Servers 77

Brendan Gregg

JULY 4, 2021

I summarized these topics and more as a plenary conference talk, including my own predictions (as a senior performance engineer) for the future of computing performance, with a focus on back-end servers. This was a chance to talk about other things I've been working on, such as the present and future of hardware performance.

Performance 140

Performance Latency Hardware Storage 140

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

If we were to select the most important MySQL setting, if we were given a freshly installed MySQL or Percona Server for MySQL and could only tune a single MySQL variable, which one would it be? Sysbench ran on a third server, which I’ll refer to as the application server (APP).

Tuning 136

Tuning Cache Servers Benchmarking 136

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. Interested?

Storage 94

Storage Database Media Open Source 94