Percona

JUNE 15, 2023

The reason might be application requirements, compatibility issues, or MySQL bug fixes, or we want the same MySQL version to be installed on all database instances in the cluster, regardless of what actually is the latest version available. Processing triggers for man-db (2.9.4-2) Processing triggers for man-db (2.9.4-2).

Servers 85

Servers C++ Database Systems 85

Percona

MARCH 27, 2023

‘ E11000 duplicate key error ’ is an error that you might have encountered during the restore process. 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

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 is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. What is PostgreSQL performance tuning?

Tuning 52

Tuning Efficiency Database Performance 52

Percona

MARCH 28, 2023

Every database system has to ensure durability and reliability. Journal It’s a process where every write operation gets written (appended) from Memory to a Journal file, AKA transaction log that exists on disk at a specific interval configured using “ journalCommitIntervalMs.” wt list -c WiredTigerCheckpoint.33:

Hardware 90

Hardware C++ Storage Cache 90

Percona

MARCH 13, 2023

On the replica mysql8 server, run: [root@mysql8 ~]# nc -l -p 2222 | unpigz -c | xbstream -x -C /var/lib/mysql The above command would be there to receive the backup until the stream copy was done. for this database. 2023-03-01T04:28:38.397836Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-23)

Servers 106

Servers C++ Storage Systems 106

Percona

AUGUST 18, 2023

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. So you put multiple MySQL servers on a single machine instead of multiple databases inside one MySQL instance.

Programming 86

Programming Servers Database Hardware 86

Percona

AUGUST 30, 2023

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 Database level setting All options discussed so far have a global scope. But another database might be an OLAP system. 20150623 (Red Hat 4.8.5-44),

Database 105

Database Servers Open Source Tuning 105

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

C++ Database Servers Open Source 96

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. mm_perc+ # Notable Processes ########################################## PID OOM COMMAND ?

Cache 101

Cache Database Virtualization Servers 101

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

DECEMBER 5, 2023

Inspired by David’s insights, I embarked on a journey to explore logical replication from a different perspective – within the realm of on-premises server databases. Also, it is a helpful method for version upgrades since the target database can run on a different (minor or major) PostgreSQL version. to PostgreSQL v15.4.

Database 78

Database Traffic C++ Servers 78

Percona

FEBRUARY 16, 2023

To make the process more secure, they considered removing the local keyring_file after MySQL started. I asked ChatGPT the question: “C an we backup and then remove the keyring file used for encryption at rest plugin after MySQL starts? ” row Database: test Create Database: CREATE DATABASE `test` /*!40100

Database 119

Database Servers Engineering Testing 119

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

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 102

Storage Open Source Database Efficiency 102

Percona

AUGUST 17, 2023

3309 has restarted, waiting for clone to finish. ** Stage RESTART: Completed * Clone process has finished: 73.66 3310 has restarted, waiting for clone to finish. ** Stage RESTART: Completed * Clone process has finished: 73.66 MySQL localhost:3308 ssl JS > c iroot@127.0.0.1:3308 3308 ssl JS > c iroot@127.0.0.1:3311

C++ 78

C++ Availability Processing Database 78

Testlodge

JULY 19, 2023

J-SOX and C-SOX are the Japanese and Canadian equivalents, respectively. Australia has initiated the Corporate Law Economic Reform Program Act (CLERP 9), and a United Kingdom version, UK SOx, is anticipated to roll out towards the end of 2023. The process can sometimes be more complex, especially at a company’s year-end.

Testing 81

Testing Energy Programming Government 81

O'Reilly

DECEMBER 12, 2023

But reading texts has been part of the human learning process as long as reading has existed; and, while we pay to buy books, we don’t pay to learn from them. The same process is used to generate output, and it’s important to understand why that process makes copyright problematic. Where did the word “or” come from?

Artificial Intelligence 101

Artificial Intelligence Media Google Processing 101

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

Percona

AUGUST 25, 2023

3308 ssl JS > c root@localhost:3308 MySQL localhost:3308 ssl JS > cluster1=dba.getCluster() MySQL localhost:3308 ssl JS > cluster1.status() In case a cluster loses the quorum, it can no longer process any write transactions within the cluster or change the cluster’s topology. MySQL 127.0.0.1:3308 MySQL 127.0.0.1:3308

Traffic 78

Traffic Database C++ Servers 78