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 52

Development Website Ecommerce Code 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. This is available only for the log_error_verbosity=3. 2023-12-05T16:51:29.610886Z 65 [Note] [MY-012398] [InnoDB] Requested to resize buffer pool.

Monitoring 88

Monitoring Code Open Source Cache 88

Percona

APRIL 6, 2023

In this blog post, we’ll check how to integrate Percona Monitoring and Management (PMM) with Loki to be able to get not only metrics and queries from our database servers but also text-based information like logs. Promtail will be in charge of reading the log files and sending new information to the Loki server.

Monitoring 87

Monitoring Servers Metrics Database 87

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 130

Servers Best Practices Government Network 130

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

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. Your MySQL connection id is 256 Server version: 8.0.32-24.2 Commands end with ; or g. drop_triggers:10000:0.25,copy_rows:10000:0.25,swap_tables:10000:0.25,update_foreign_keys:10000:0.25,analyze_table:10000:0.25

Database 96

Database Performance C++ Engineering 96

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

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

JUNE 2, 2023

WordPress, the ubiquitous publishing platform that launched millions of blogs and websites, turned 20 on May 27th. WordPress arrived on the scene as blogging was becoming a mainstream trend and helped launch, literally, millions of blogs. And if your blog got Slashdotted or just a high level of traffic in general?

Open Source 96

Open Source Traffic Tuning Database 96

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. Let’s start with this: MongoDB is accurately referred to as source-available software. To be clear, we are rock-solid in our stance that MongoDB is not open source.

Open Source 82

Open Source Programming Database Servers 82

Percona

JUNE 28, 2023

This blog post is a warning tale, an invitation to try yourself and break stuff (not in production, right?). First error to notice: 2023-06-22T08:00:48.322148Z 0 [ERROR] [MY-000000] [Galera] It may not be safe to bootstrap the cluster from this node. sandbox server started At this point, notice that from node1, you have: $./sandboxes/pxc_msb_8_0_31/node1/use

C++ 78

C++ Open Source Servers Monitoring 78

Percona

OCTOBER 4, 2023

was released on October 3, 2023. This blog post covers the main changes in this release. Fix for PT-2168 adds checks for these situations and, depending on the option -- fail - on - stopped - replication , either dies or continues waiting when the replica is available again. Percona Toolkit 3.5.5 Download Percona Toolkit

Open Source 100

Open Source Code Testing Systems 100

Percona

APRIL 17, 2023

In this blog post, I’ll show you a simple example of collecting all rich data about databases using PMM and a way to send some of it to Datadog for general dashboards with main metrics to monitor. Preparing Datadog side: You can find a complete list of Available Datadog agents for different OS inside the user account.

Monitoring 71

Monitoring Metrics Database Open Source 71

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 ). MariaDB Server, on the other hand, is a fork of MySQL 5.5. Get the reliable MySQL support you need.

Open Source 52

Open Source Servers Storage Scalability 52

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

ACM Sigarch

MAY 31, 2023

To understand the current status, needs, and challenges in HCM, the first workshop for Heterogeneous and Composable Memory was held with HPCA’23 on Feb 26, 2023. Memory disaggregation separates memory pools from traditional server boxes, enabling more flexible resource allocation and potentially reducing costs. Using emulation (e.g.

Latency 52

Latency Hardware Cache Architecture 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

JUNE 12, 2023

Today’s post includes those releases and updates that have come out since May 29, 2023. On June 5, 2023, we released Percona Monitoring and Management 2.37.1 , which includes a critical CVE fix. We have identified and fixed CVE-2023-34409: PMM-12182 : PMM authentication bypass vulnerability. was released on June 5, 2023.

Open Source 84

Open Source Servers Database Scalability 84

Percona

FEBRUARY 2, 2023

PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server. The pg_hba.conf file is used to configure the authentication methods the PostgreSQL server uses and can specify different methods for different types of connections.

Database 124

Database Servers Testing Programming 124

Percona

MAY 8, 2023

Today’s post includes those releases and updates that have come out since April 24, 2023. On May 2, 2023, Percona Monitoring and Management 2.37 (PMM) was released. For more in-depth information, check out Roma Novikov’s blog covering all things Percona Monitoring and Management 2.37. was released on May 4, 2023.

Monitoring 78

Monitoring Open Source Database Servers 78

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

JULY 7, 2023

With the average cost of unplanned downtime running from $300,000 to $500,000 per hour , businesses are increasingly using high availability (HA) technologies to maximize application uptime. Where a high availability design once worked well, it can no longer keep up with more complex requirements.

Availability 84

Availability Open Source Architecture Database 84

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.

Database 87

Database Open Source Testing Servers 87

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). ‘ E11000 duplicate key error ’ is an error that you might have encountered during the restore process. sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1)

Games 95

Games Database Open Source C++ 95

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

JULY 17, 2023

In this blog, we’ll examine the reasons why people would seek an alternative to MongoDB Enterprise, and we’ll identify some of the most popular NoSQL alternatives. First, some stage-setting for this blog article. 1 among non-relational/document-based systems ( DB-Engines, July 2023 ). It ranks No.

Open Source 76

Open Source Database Scalability Software 76

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

Database 103

Database Servers Open Source Tuning 103

Percona

JUNE 26, 2023

So we need to check whether this base / 16384 / 16391 file is available in / base location. We have faced different levels of corruption related to databases in PostgreSQL. In case of hardware failure, first, we need to fix the hardware issue or migrate our database to new hardware and then perform a restore, as mentioned below.

Hardware 76

Hardware C++ Database Open Source 76

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. zst 2023-02-07T19:33:58.138+0100 writing db2.products products to archive on stdout 2023-02-07T19:33:58.140+0100 writing db2.people

AWS 121

AWS Storage Database Open Source 121

Percona

APRIL 17, 2023

reaches end of life in October 2023. Reserved keyword – Groups Most notably, and the issue my customers are facing (and the primary reason for this blog post), is the addition of GROUPS as a reserved keyword. You can read more about reserved keywords in a previous blog, MySQL 5.7 Upgrading to MySQL 8 from 5.7

Open Source 74

Open Source Servers Scalability Database 74

Percona

JUNE 23, 2023

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. If you have multiple CPUs on the server, you can increase the number of threads for each operation. dbxxxx/tb1.ibd

Servers 81

Servers Processing Speed Open Source 81

Percona

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. The idea is to use secondary servers on your infrastructure for either reads or other administrative solutions. Network Connectivity: Establish a reliable network connection between the primary and replica servers.

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. If we asked whether their companies were using databases or web servers, no doubt 100% of the respondents would have said “yes.” of users and 3.9%

Open Source 106

Open Source Artificial Intelligence Google Infrastructure 106

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. You ALWAYS want to upgrade MongoDB to the latest version available – well, after checking the bug list, of course.

Servers 70

Servers Database Processing Systems 70

Brendan Gregg

MARCH 16, 2024

This technique saves two instructions in the prologue and epilogue and makes one additional general-purpose register (%rbp) available." 2005-2023: The winter of broken profilers However, the change was then applied to x86-64 (64-bit) as well, which had sixteen registers and didn't benefit so much from a seventeenth.

Java 145

Java Cache Google Hardware 145

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

APRIL 13, 2023

In this blog, we will discuss what replication lag is, why it occurs, and how to mitigate it in PostgreSQL. Replication lag can have serious consequences in high-availability systems where standby databases are used for failover. 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