Percona

JUNE 29, 2023

Before Percona Server for MongoDB 4.4 PSMDB), the best practice to create an index was doing it in a rolling manner. Many folks used to create directly on Primary, resulting in the first index being created successfully on Primary and then replicated to Secondary nodes. Starting from PSMDB 4.4, Status of nodes: rs1:PRIMARY> rs.status().members.forEach(function

Servers 80

Servers C++ Storage Best Practices 80

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 94

Database Open Source Storage Servers 94

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 86

Database Open Source Testing Servers 86

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

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

C++ Servers Storage Speed 104

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 92

Scalability Database Open Source Systems 92

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 77

Open Source Database Servers Programming 77

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

Servers 90

Servers Database Testing Open Source 90

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 87

Engineering Database Servers Analytics 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? Why not just create another database on the same instance? You can run multiple instances on a server to test your backups with the correct version and configs. AFAIK Facebook does this.

Programming 84

Programming Servers Database Hardware 84

Percona

OCTOBER 31, 2023

Therefore, we executed the pt-table-checksum in the following way: $ pt-table-checksum h=192.168.0.14 --port=3306 --no-check-binlog-format --no-check-replication-filters --replicate percona.checksums --recursion-method=hosts --max-load Threads_running=50 --max-lag=100 --databases=foo --tables=persons Checking if all tables can be checksummed.

Database 101

Database Servers Efficiency Performance 101

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 120

AWS Storage Database Open Source 120

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

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.

Servers 130

Servers Best Practices Government Network 130

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

MAY 16, 2023

As a database administrator, have you ever been in a situation when your database confronted a brute force attack? The connection control plugin library allows administrators to introduce an increasing delay in the server response to connections after a designated number of consecutive unsuccessful login attempts.

Servers 118

Servers Database Monitoring Testing 118

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 102

Database Servers Open Source Tuning 102

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

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

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

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

JUNE 2, 2023

WordPress, the ubiquitous publishing platform that launched millions of blogs and websites, turned 20 on May 27th. WordPress also benefited from and popularized MySQL, introducing the LAMP stack – and open source – to an audience that might never have touched a database before or had any intro to open source.

Open Source 95

Open Source Traffic Tuning Database 95

Dynatrace

JUNE 8, 2022

Added deeper insight into IBM DB2 database calls by fetching the full SQL statements from the DB2 catalog. Windows: Windows Server 2004. Linux: SUSE Linux Enterprise Server 11.4. Windows: Windows Server 20H2. The following operating systems will no longer be supported starting 01 January 2023. Announcements.

Java 152

Java Operating System Lambda Serverless 152

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.719139Z 1 [ERROR] [MY-012657] [InnoDB] Encryption can't find master key, please check the keyring is loaded.

Database 117

Database Servers Engineering Testing 117

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

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 75

Open Source Database Scalability Software 75

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

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

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. If you have multiple CPUs on the server, you can increase the number of threads for each operation.

Servers 80

Servers Processing Speed Open Source 80

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.

Database 76

Database Traffic C++ Servers 76

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 73

Open Source Servers Scalability Database 73

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 135

Tuning Cache Servers Benchmarking 135

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

C++ Database Servers Open Source 93

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