2023, Blog and Database - Technology Performance Pulse

RSA Guide 2023: Cloud application security remains core challenge for organizations

Dynatrace

APRIL 11, 2023

Read on to learn more about the ways observability and security are converging and how this affects vulnerability management, real-time response, and the rise of DevSecOps in our RSA 2023 guide. And why runtime vulnerability detection makes the difference – blog Vulnerability management is an essential part of securing IT operations.

Cloud

Cloud DevOps Open Source Retail

Using Jobs to Perform Schema Changes Against MySQL Databases on K8s

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. Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Database

Database Performance C++ Engineering

What To Do When a Data File in PostgreSQL Goes Missing

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

Hardware C++ Database Open Source

Use Physical Backups With MySQL InnoDB Redo Log Archiving

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. Press ^C to stop.

C++

C++ Servers Storage Speed

Data Redundancy With the PostgreSQL Citus Extension

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

C++ Database Storage Testing

Streaming MongoDB Backups Directly to S3

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

AWS Storage Database Open Source

CommitQuorum in Index Creation From Percona Server for MongoDB 4.4

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

Servers C++ Storage Best Practices

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

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

Tuning Efficiency Database Performance

How To Fix Oplog Restore Error: E11000 Duplicate Key Error Collection Using Percona Backup for MongoDB

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

Games Database Open Source C++

How To Use systemd in Linux to Configure and Manage Multiple MySQL Instances

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.

Programming

Programming Servers Database Hardware

WiredTiger Logging and Checkpoint Mechanism

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. wt list -c WiredTigerCheckpoint.33: MongoDB uses classic Write-Ahead-Logging (WAL) using Journals and Checkpoints. These checkpoints are stored in WiredTiger.wt

Hardware

Hardware C++ Storage Cache

Dealing With “Too Many Connections” Error in MySQL 8

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

C++ Database Servers Open Source

PostgreSQL Parameters: Scope and Priority Users Should Know

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

Database Servers Open Source Tuning

The Magic of PITR, pg_upgrade, and Logical Replication When Used Together for PostgreSQL Version Upgrades

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

Database Traffic C++ Servers

MongoDB Database Backup: Best Practices & Expert Tips

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

Best Practices Database Storage Servers

ChatGPT Won’t Replace MySQL DBA – An Example of a Question About Encryption at Rest

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

Database Servers Engineering Testing

Unleashing the Power of PostgreSQL Event-Based Triggers

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

Database Best Practices Open Source C++

PostgreSQL Partitioning Made Easy Using pg_partman (TimeBased)

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

Storage Open Source Database Efficiency

Percona Monitoring and Management and Datadog Integration

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

Monitoring Metrics Database Open Source

Setting Up MongoDB SSL Encryption

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

Servers Best Practices Government Network

Platform Engineering Teams Done Right…

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

Engineering Serverless Lambda AWS

InnoDB ClusterSet Deployment With MySQLRouter

Percona

AUGUST 17, 2023

This blog post will cover the basic setup of the InnoDB ClusterSet environment, which provides disaster tolerance for InnoDB Cluster deployments by associating a primary InnoDB Cluster with one or more replicas in alternate locations/different data centers. MySQL localhost:3308 ssl JS > c iroot@127.0.0.1:3308 Node ( 127.0.0.1:3311

C++

C++ Availability Processing Database

MariaDB vs MySQL: Key Differences and Use Cases

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 ). What is MariaDB? In addition, MariaDB provides optimal scalability options, making it ideal for growing workloads.

Open Source

Open Source Servers Storage Scalability

What is SOX Compliance Testing?

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. appeared first on TestLodge Blog. The post What is SOX Compliance Testing?

Testing

Testing Energy Programming Government

Failover and Recovery Scenarios in InnoDB Cluster and ClusterSet

Percona

AUGUST 25, 2023

This blog post will focus on failover and recovery scenarios inside the InnoDB Cluster and ClusterSet environment. 3308 ssl JS > c root@localhost:3308 MySQL localhost:3308 ssl JS > cluster1=dba.getCluster() MySQL localhost:3308 ssl JS > cluster1.status() MySQL 127.0.0.1:3308 3308": { "address": "127.0.0.1:3308",

Traffic

Traffic Database C++ Servers

Technology Performance Pulse

RSA Guide 2023: Cloud application security remains core challenge for organizations

Using Jobs to Perform Schema Changes Against MySQL Databases on K8s

Trending Sources

What To Do When a Data File in PostgreSQL Goes Missing

Use Physical Backups With MySQL InnoDB Redo Log Archiving

Data Redundancy With the PostgreSQL Citus Extension

Streaming MongoDB Backups Directly to S3

CommitQuorum in Index Creation From Percona Server for MongoDB 4.4

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

How To Fix Oplog Restore Error: E11000 Duplicate Key Error Collection Using Percona Backup for MongoDB

How To Use systemd in Linux to Configure and Manage Multiple MySQL Instances

WiredTiger Logging and Checkpoint Mechanism

Dealing With “Too Many Connections” Error in MySQL 8

PostgreSQL Parameters: Scope and Priority Users Should Know

The Magic of PITR, pg_upgrade, and Logical Replication When Used Together for PostgreSQL Version Upgrades

MongoDB Database Backup: Best Practices & Expert Tips

ChatGPT Won’t Replace MySQL DBA – An Example of a Question About Encryption at Rest

Unleashing the Power of PostgreSQL Event-Based Triggers

PostgreSQL Partitioning Made Easy Using pg_partman (TimeBased)

Percona Monitoring and Management and Datadog Integration

Setting Up MongoDB SSL Encryption

Platform Engineering Teams Done Right…

InnoDB ClusterSet Deployment With MySQLRouter

MariaDB vs MySQL: Key Differences and Use Cases

What is SOX Compliance Testing?

Failover and Recovery Scenarios in InnoDB Cluster and ClusterSet

Stay Connected