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 52

Development Website Ecommerce Programming 52

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 88

Monitoring Code Open Source Cache 88

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 100

Database Testing Servers Open Source 100

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 278

Database Artificial Intelligence Metrics Monitoring 278

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 90

Open Source Database Operating System Programming 90

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 67

Open Source Database Storage Engineering 67

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 118

Database Servers Engineering Testing 118

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 100

Open Source Code Testing Systems 100

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 82

Open Source Programming Database Servers 82

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 87

Database Traffic Open Source Monitoring 87

Percona

NOVEMBER 1, 2023

This blog was originally published in August of 2021 and updated in November of 2023. Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker. docker-entrypoint."

Scalability 59

Scalability Best Practices Servers Database 59

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 ). Percona Server for MySQL side-by-side to better inform the decision making process.

Open Source 52

Open Source Servers Storage Scalability 52

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. In this blog post, we will delve into the world of PostgreSQL performance tuning and establish some basic guidelines for setting database parameters to enhance the performance of your PostgreSQL database, based on the workload.

Tuning 52

Tuning Efficiency Database Performance 52

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 124

Database Servers Testing Programming 124

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 88

Engineering Database Servers Analytics 88

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 95

Database Open Source Storage Servers 95

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 87

Database Open Source Testing Servers 87

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 95

Games Database Open Source C++ 95

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 78

Servers Open Source Database Systems 78

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 93

Scalability Database Open Source Systems 93

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 228

DevOps Traffic Efficiency Servers 228

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 83

Servers Azure AWS Cloud 83

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 78

Open Source Database Servers Programming 78

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 85

Programming Servers Database Hardware 85

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 103

Database Servers Open Source Tuning 103

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 81

Servers Processing Speed Open Source 81

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 74

Open Source Servers Scalability Database 74

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 77

Database Traffic C++ Servers 77

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 70

Servers Database Processing Systems 70

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 79

Servers Best Practices DevOps Open Source 79

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 52

Servers Database Availability Traffic 52

O'Reilly

NOVEMBER 28, 2023

Generative AI has been the biggest technology story of 2023. As of November 2023: Two-thirds (67%) of our survey respondents report that their companies are using generative AI. Users and Nonusers AI adoption is in the process of becoming widespread, but it’s still not universal. Is generative AI at the top of the hype curve?

Open Source 106

Open Source Artificial Intelligence Google Infrastructure 106

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 136

Tuning Cache Servers Benchmarking 136

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

C++ Database Servers Open Source 94

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 81

Speed Monitoring Testing Network 81

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 79

Best Practices Storage Strategy Database 79

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 82

Latency Tuning Open Source Network 82