2023, Blog, Processing and Servers - Technology Performance Pulse

The Dynatrace journey toward DORA compliance

Dynatrace

APRIL 23, 2024

DORA is a European Union (EU) regulation that took effect on January 16, 2023, with full implementation starting January 17, 2025. This blog post describes how we’re aligning our efforts with the upcoming changes. Imagine a dashboard that whispers, “Hey, there’s a vulnerability brewing in Server Room B.”

Tuning

Tuning Strategy Servers Technology

9 Best Software Tools For Web Design Solutions In 2023!

Official Blog - World Web Technology

DECEMBER 1, 2023

Considering our audience’s interest, this post examines the best software for a web design Services Company in 2023. In 2023, web designers will need tools that are both highly effective and simple to use, with the ability to both speed up the design process and foster more creative freedom.

Design

Design Software Software Website

PostgreSQL Database Security: External Server-Based Authentication

Percona

FEBRUARY 2, 2023

The authentication process is typically accomplished through usernames and passwords and includes other factors such as security tokens and one-time passwords. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server.

Database

Database Servers Testing Programming

What if the Backup Server Is Down and a Backup Is Needed? (Multi-repo Functionality of PgBackRest)

Percona

MARCH 28, 2023

Our previous blogs discussed configuring and setting up backups using the pgBackRest solution. Repository means the location/path on the server or the cloud where the actual copy of the backup will reside. Repository means the location/path on the server or the cloud where the actual copy of the backup will reside.

Servers

Servers Azure AWS Cloud

pgBackRest’s Expire and Backup With Custom Lock-Path Files

Percona

SEPTEMBER 25, 2023

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 issue tends to occur when your backup storage is located offsite, your database is quite large, and the backup process generates a lot of files.

Database

Database Open Source Storage Servers

Convert MariaDB Binary Log File and Position-Based Replication to GTID Replication

Percona

SEPTEMBER 15, 2023

At Percona Managed Services , we manage Percona Server for MySQL , Community MySQL, and MariaDB. In this blog, we’ll show you how to convert MariaDB binary log file and position-based replication to GTID replication. In my lab, we have two test nodes; both servers will have Debian 11 and MariaDB10.5.19 mariadb_repo_setup./mariadb_repo_setup

Servers

Servers C++ Processing Testing

Use Physical Backups With MySQL InnoDB Redo Log Archiving

Percona

SEPTEMBER 19, 2023

This blog post will walk you through how MySQL’s InnoDB redo log archiving uses PXB to manage the redo log files on the busiest systems and look at how a new feature released in PXB version 8.0.34-29 Enabling redo log archiving on the server requires setting a value for the innodb_redo_log_archive_dirs system variable.

C++

C++ Servers Storage Speed

What’s New in Percona Toolkit 3.5.6

Percona

DECEMBER 22, 2023

was released on December 21, 2023. This blog post covers the main changes in this release. PR-720 simplifies the build process for the Percona Toolkit. This partially happened, and we are testing Percona Toolkit with Percona Server for MySQL 5.7 2023-12-21T15:29:22 Creating triggers. Percona Toolkit 3.5.6

Operating System

Operating System Programming Open Source Testing

How to Convert PostgreSQL Streaming Replication to Logical Replication

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

Servers Open Source Database Systems

Migrate Data From Atlas to Self-Hosted MongoDB

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

Database

Database Open Source Testing Servers

Setting Up MongoDB SSL Encryption

Scalegrid

FEBRUARY 15, 2024

Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections. Preparing SSL Certificates for MongoDB The SSL certificates are necessary for our MongoDB server to establish secure SSL/TLS communications.

Servers

Servers Best Practices Government Network

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

Programming Servers Database Hardware

Scalable Solutions with Percona Distribution for PostgreSQL (Part 2): Using Citus

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 has many advantages, one of which is the “Sharding Technique” and this is what we are going to explore in this blog post. Let's download the deb.sh

Scalability

Scalability Database Open Source Systems

PostgreSQL Job Scheduler: pg_timetable

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

Open Source Database Servers Programming

How to Become a WordPress Developer in 2023

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

Development Website Ecommerce Code

Complete Walkthrough: MySQL to ClickHouse Replication Using MaterializedMySQL Engine

Percona

SEPTEMBER 14, 2023

I recommend you read our previous blog, Using ClickHouse as an Analytic Extension for MySQL , from Vadim to know more about this. In this blog post, I will show you how to replicate MySQL data in real-time to ClickHouse. The blog post contains the following topics. Both servers are running their respective databases.

Engineering

Engineering Database Servers Analytics

What Skills Are Required For WordPress Developer In 2023?

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

Development Website Ecommerce Programming

How to Monitor Online InnoDB Buffer Pool Resizing

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. This is available only for the log_error_verbosity=3.

Monitoring

Monitoring Code Open Source Cache

Is My Backup Stuck? A Quick Guide for Reviewing Percona XtraBackup Threads

Percona

JUNE 23, 2023

In order to speed up the backup process along with the compression and encryption, we can use multiple threads. 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.

Servers

Servers Processing Speed Open Source

Purging Data When the Table Is Big and Has Children Tables

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

Database Testing Servers Open Source

DevOps automation: From event-driven automation to answer-driven automation [with causal AI]

Dynatrace

JULY 24, 2023

In this blog, we will dive into the transformative power of answer-driven automation. We will also explore the evolution of DevOps automation and the significance of data-driven answers in unlocking streamlined, automated DevOps and SRE processes. Download the free 2023 CIO Report. Download now!

DevOps

DevOps Traffic Efficiency Servers

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

Percona

MARCH 27, 2023

‘ E11000 duplicate key error ’ is an error that you might have encountered during the restore process. In this blog, we will talk about in what scenario you might face this error when restoring Oplog for PITR (point-in-time recovery). sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1)

Games

Games Database Open Source C++

MySQL 8 Doesn’t Like Your Groups

Percona

APRIL 17, 2023

reaches end of life in October 2023. As a MySQL Principal Architect at Percona, I’ve had several customers over the past few months wanting to begin the upgrade process from 5.7 As a MySQL Principal Architect at Percona, I’ve had several customers over the past few months wanting to begin the upgrade process from 5.7

Open Source

Open Source Servers Scalability Database

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

Database Servers Open Source Tuning

Extend business observability: Extract business events from online databases (Part 2)

Dynatrace

SEPTEMBER 8, 2023

In part 1 of this blog series , we explored the concept of business observability, its significance, and how real-time visibility aids in making informed decisions. SQL Username: Username of the user who has permission to login on the SQL server remotely and access the database. This is used for identification purposes.

Database

Database Artificial Intelligence Metrics Monitoring

Percona Is Introducing Telemetry Mechanisms Into MySQL, PostgreSQL, and MongoDB

Percona

OCTOBER 31, 2023

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.” which is scheduled for EOL by the end of October 2023. 26-1, telemetry will be enabled by default.

Open Source

Open Source Database Operating System Programming

Want to Migrate From MariaDB 10.4 to MySQL 8.0 but Facing Hurdles? MySQL 5.7 to the Rescue!

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

Open Source Database Storage Engineering

Deploy PostgreSQL on Kubernetes Using GitOps and ArgoCD

Percona

JULY 19, 2023

In the world of modern DevOps, deployment automation tools have become essential for streamlining processes and ensuring consistent, reliable deployments. GitOps and ArgoCD are at the cutting edge of deployment automation, making it easy to deploy complex applications and reducing the risk of human error in the deployment process.

Servers

Servers Best Practices DevOps Open Source

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

Percona

FEBRUARY 16, 2023

To make the process more secure, they considered removing the local keyring_file after MySQL started. mysql> select * from t2; ERROR 3185 (HY000): Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully. Let me show you why.

Database

Database Servers Engineering Testing

The Most Important MySQL Setting

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

Tuning Cache Servers Benchmarking

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

Database

Database Traffic C++ Servers

MongoDB V4.2 EOL Is Coming: How To Upgrade Now and Watch Out for the Gotchas!

Percona

APRIL 13, 2023

EOL is set for April 30, 2023. Since Percona Server for MongoDB (PSMDB) is a fully compatible replacement for the upstream MongoDB Community Edition, we try to follow the same EOL date as the upstream vendor. That, too, will impact our upgrade process. MongoDB v4.2 Then with v6.0, But there are quite a few hops between v4.2

Servers

Servers Database Processing Systems

Dealing With “Too Many Connections” Error in MySQL 8

Percona

MARCH 8, 2023

The main objective of this blog post is to point out the new administrative connections allowed on MySQL 8, as these connections can save us from restarting the instance in case this happens. Your MySQL connection id is 144 Server version: 8.0.29-21 mysql> show grants; + --+ | Grants for admin1@% | + --+ | GRANT PROCESS ON *.*

C++

C++ Database Servers Open Source

What’s New in Percona Toolkit 3.5.5

Percona

OCTOBER 4, 2023

was released on October 3, 2023. This blog post covers the main changes in this release. We plan to make regression tests part of the release process starting from the next version. There are still a few pull requests waiting for final resolution, but we hope we will process all of them by the end of the year.

Open Source

Open Source Code Testing Systems

MySQL Backup and Recovery Best Practices: The Ultimate Guide

Percona

NOVEMBER 1, 2023

This blog was originally published in January 2021 and updated in November of 2023. In this blog, we will review all of the potential MySQL backup and restore strategies, the cornerstones of any application. on, you can use mysqlbinlog to stream binary logs from a remote server. From MySQL 5.6

Best Practices

Best Practices Storage Strategy Database

Bootstrap PostgreSQL on Kubernetes

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.

Storage

Storage Database Media Open Source

It’s All About Replication Lag in PostgreSQL

Percona

APRIL 13, 2023

In this blog, we will discuss what replication lag is, why it occurs, and how to mitigate it in PostgreSQL. A poor configuration , like setting low numbers of max_wal_senders while processing huge numbers of transaction requests. One of the common issues that can be encountered in PostgreSQL is replication lag. What is replication lag?

Latency

Latency Tuning Open Source Network

How to Install and Run PostgreSQL Using Docker

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

Database Open Source Scalability Virtualization

An Introduction to MySQL Replication: Exploring Different Types of MySQL Replication Solutions

Percona

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. MySQL replication is a process in which data from a primary MySQL database is copied and sent to one or more secondary databases, known as replicas. Set the server-id to a unique value. What is MySQL Replication? Restart the MySQL service.

Servers

Servers Database Availability Traffic

A Tutorial on MongoDB Sharding With Best Practices & When To Enable It

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. In this blog post, we will talk about MongoDB sharding and walk through the main reasons why you should start a cluster (independent of the approach you have chosen). Learn more: View our webinar on How to Scale with MongoDB.

Best Practices

Best Practices Traffic Database Servers

Is MongoDB Open Source? Is Planet Earth Flat?

Percona

APRIL 12, 2023

We’re equally convinced on both counts, but in this blog article, we’re focusing on why MongoDB is not open source. This blog article traces key developments that coincided with MongoDB’s move away from open source software, and it examines how SSPL influence might have lured others in the same direction. .”

Open Source

Open Source Programming Database Servers

How To Make Schema Changes and Not Die Trying

Percona

SEPTEMBER 12, 2023

In this blog post, I will delve into the most important things to consider while preparing a schema change. sec) Metadata locks There are several blog posts about this locking mechanism and the common problems you may encounter when executing schema changes. Quickly Troubleshoot Metadata Locks in MySQL 5.7

Database

Database Traffic Open Source Monitoring

Running A Page Speed Test: Monitoring vs. Measuring

Smashing Magazine

AUGUST 10, 2023

Measuring Running A Page Speed Test: Monitoring vs. Measuring Geoff Graham 2023-08-10T08:00:00+00:00 2023-08-10T12:35:05+00:00 This article is sponsored by DebugBear There is no shortage of ways to measure the speed of a webpage. That’s where a tool like DebugBear makes a lot of sense.

Speed

Speed Monitoring Testing Network

Best JavaScript Web Development Framework: Comparing ReactJS, NodeJS, and AngularJS!

Official Blog - World Web Technology

NOVEMBER 24, 2023

In this blog, we shall discuss the three popular JavaScript frameworks (ReactJS vs NodeJS vs AngularJS). enables the development of server-side and networked applications and has become widely popular for building scalable and real-time web applications. for server-side development, it’s not limited to that role.

Development

Development Virtualization Open Source Architecture

The Dynatrace journey toward DORA compliance

9 Best Software Tools For Web Design Solutions In 2023!

Trending Sources

PostgreSQL Database Security: External Server-Based Authentication

What if the Backup Server Is Down and a Backup Is Needed? (Multi-repo Functionality of PgBackRest)

pgBackRest’s Expire and Backup With Custom Lock-Path Files

Convert MariaDB Binary Log File and Position-Based Replication to GTID Replication

Use Physical Backups With MySQL InnoDB Redo Log Archiving

What’s New in Percona Toolkit 3.5.6

How to Convert PostgreSQL Streaming Replication to Logical Replication

Migrate Data From Atlas to Self-Hosted MongoDB

Setting Up MongoDB SSL Encryption

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

Scalable Solutions with Percona Distribution for PostgreSQL (Part 2): Using Citus

PostgreSQL Job Scheduler: pg_timetable

How to Become a WordPress Developer in 2023

Complete Walkthrough: MySQL to ClickHouse Replication Using MaterializedMySQL Engine

What Skills Are Required For WordPress Developer In 2023?

How to Monitor Online InnoDB Buffer Pool Resizing

Is My Backup Stuck? A Quick Guide for Reviewing Percona XtraBackup Threads

Purging Data When the Table Is Big and Has Children Tables

DevOps automation: From event-driven automation to answer-driven automation [with causal AI]

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

MySQL 8 Doesn’t Like Your Groups

PostgreSQL Parameters: Scope and Priority Users Should Know

Extend business observability: Extract business events from online databases (Part 2)

Percona Is Introducing Telemetry Mechanisms Into MySQL, PostgreSQL, and MongoDB

Want to Migrate From MariaDB 10.4 to MySQL 8.0 but Facing Hurdles? MySQL 5.7 to the Rescue!

Deploy PostgreSQL on Kubernetes Using GitOps and ArgoCD

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

The Most Important MySQL Setting

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

MongoDB V4.2 EOL Is Coming: How To Upgrade Now and Watch Out for the Gotchas!

Dealing With “Too Many Connections” Error in MySQL 8

What’s New in Percona Toolkit 3.5.5

MySQL Backup and Recovery Best Practices: The Ultimate Guide

Bootstrap PostgreSQL on Kubernetes

It’s All About Replication Lag in PostgreSQL

How to Install and Run PostgreSQL Using Docker

An Introduction to MySQL Replication: Exploring Different Types of MySQL Replication Solutions

A Tutorial on MongoDB Sharding With Best Practices & When To Enable It

Is MongoDB Open Source? Is Planet Earth Flat?

How To Make Schema Changes and Not Die Trying

Running A Page Speed Test: Monitoring vs. Measuring

Best JavaScript Web Development Framework: Comparing ReactJS, NodeJS, and AngularJS!

Stay Connected