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 111

Servers C++ Storage Systems 111

Percona

JULY 5, 2023

EOL is set for the end of October 2023. Long database service downtime Some queries become slow Applications stop working due to incompatibilities Data loss This is what can happen if MySQL’s major upgrade to 8.0 You cannot load a dump of the MySQL system database from MySQL 8.0 Default database: 'test'.

C++ 123

C++ Database Servers Testing 123

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

C++ Database Storage Testing 84

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 80

Hardware C++ Database Open Source 80

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 85

Servers C++ Storage Best Practices 85

Percona

FEBRUARY 16, 2023

I asked ChatGPT the question: “C an we backup and then remove the keyring file used for encryption at rest plugin after MySQL starts? ” 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

Database 123

Database Servers Engineering Testing 123

Percona

DECEMBER 29, 2023

Not everything can be addressed on the database side. Human factor: In an ideal case, there must be stringent restrictions and enforcement on what load and number of connections can be onboarded to the Database. App-Dev often demands unrestricted, uncontrolled access to the database. However, gatekeeping is not an easy job.

Servers 86

Servers Database C++ Airlines 86

Percona

OCTOBER 17, 2023

When multiple operations, such as reads and writes, attempt to access the database concurrently, WiredTiger uses tickets to ensure these operations do not conflict in a way that would compromise data integrity or performance. Bounce the database, replacing the binaries with the older release. Remove backward-incompatible features.

Metrics 108

Metrics C++ Database Storage 108

Percona

MARCH 28, 2023

Every database system has to ensure durability and reliability. wt list -c WiredTigerCheckpoint.33: In this blog post, we will dive deep into WiredTiger’s Logging and Checkpoint mechanism. MongoDB uses classic Write-Ahead-Logging (WAL) using Journals and Checkpoints. Starting with the basics, why is WAL needed in the first place?

Hardware 94

Hardware C++ Storage Cache 94

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

C++ Database Servers Open Source 100

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. Type 'c' to clear the current input statement. Type 'c' to clear the current input statement.

Servers 88

Servers C++ Database Systems 88

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 109

Database Servers Open Source Tuning 109

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 89

Programming Servers Database Systems 89

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

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. And did I mention they are open source?! pt-summary --user=root [?2004l# virtual = 2.2G

Cache 106

Cache Database Virtualization Servers 106

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. pg_partman_bgw.dbname : Required.

Storage 106

Storage Open Source Database Efficiency 106

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 80

Database Best Practices Open Source Testing 80

HammerDB

JUNE 22, 2023

Configuring the Jobs Database The base configuration is set in the xml files in the config directory with the jobs SQLite database being set in the commandline section of generic.xml by specifying the filename. Copyright (C) 2003-2023 Steve Shaw Type "help" for a list of commands Initialized new Jobs on-disk database /opt/HammerDB-4.8/DATA/hammer.db

Benchmarking 58

Benchmarking C++ Virtualization Database 58

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 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 Database Efficiency Performance 52

Percona

APRIL 17, 2023

Still, as DBA, you want to use Percona Monitoring and Management (PMM) for better database insights and maintain a common policy of Datadog as a standard alerting or high-level observability tool. We’ll use here “up” metrics for different databases to reflect database status. 1 Complete! openmetrics.d/conf.yaml

Monitoring 75

Monitoring Metrics Database Open Source 75

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 82

Database Traffic C++ Servers 82

HammerDB

MARCH 27, 2023

introduced a Dockerfile and Docker Images to pull from Docker Hub for rapid deployment of HammerDB with builds already including third-party database libraries. Copyright (C) 2003-2023 Steve Shaw Type "help" for a list of commands Initialized SQLite on-disk database /home/hammerdb/HammerDB-4.7/TMP/hammer.DB HammerDB v4.5

Benchmarking 52

Benchmarking Testing Database C++ 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

AUGUST 17, 2023

MySQL localhost:3308 ssl JS > c iroot@127.0.0.1:3308 3308 ssl JS > c iroot@127.0.0.1:3311 3311 ssl JS > c iroot@localhost:3308 MySQL localhost:3308 ssl JS > cluster1 = dba.getCluster(); MySQL localhost:3308 ssl JS > cluster1.setupRouterAccount('router_usr') Node ( 127.0.0.1:3311 3308 MySQL 127.0.0.1:3308

C++ 81

C++ Availability Processing Database 81

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. How does SOX Compliance Testing differ from other Testing Types?

Testing 81

Testing Energy Programming Government 81

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() 3309" } MySQL localhost:3309 ssl SQL > create database sbtest2; Query OK, 1 row affected (0.0055 sec) Later on, we can fix the failed instances, and they will join cluster1 again.

Traffic 82

Traffic Database Servers C++ 82

O'Reilly

DECEMBER 12, 2023

This may be too much information, but this process generally works by generating “embeddings” for the company’s documentation; storing those embeddings in a vector database; and retrieving the documents that have embeddings similar to the user’s original question. We have provenance. We’ve only seen the beginnings of what’s possible.

Artificial Intelligence 103

Artificial Intelligence Media Google Processing 103

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). What is MariaDB? Enhanced security is another advantage MariaDB.

Open Source 52

Open Source Servers Storage Scalability 52

Percona

MARCH 27, 2023

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. In this blog, we will talk about in what scenario you might face this error when restoring Oplog for PITR (point-in-time recovery).

Games 100

Games Database Open Source C++ 100

Percona

AUGUST 16, 2023

In database management, well-formatted SQL code is easier to read and a vital aspect of maintaining clean, efficient, and error-free databases. PostgreSQL developers and database administrators often deal with complex SQL queries, making code readability a critical factor for productivity.

Code 82

Code Best Practices Open Source C++ 82