Official Blog - World Web Technology

DECEMBER 1, 2023

It thereby requires access to the best available technologies. Considering our audience’s interest, this post examines the best software for a web design Services Company in 2023. When choosing your choice, keep in mind your current degree of expertise, the prerequisites of the project, and your available funds.

Design 59

Design Software Software Website 59

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

DECEMBER 22, 2023

was released on December 21, 2023. This blog post covers the main changes in this release. pt - galera - log - explainer takes raw log files, usually very verbose as the one available in the regression test suite , and makes short summary out of them: $./bin/pt-galera-log-explainer 2023-12-21T15:29:22 Creating triggers.

Operating System 96

Operating System Programming Open Source Testing 96

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

Official Blog - World Web Technology

APRIL 12, 2023

Of all websites available across the globe, WordPress powers more than 65.1%. There are more than 59,208 WordPress plugins available as of now. The number of free themes available with WordPress is 8,874+ as of now. Earlier, it was used to simply create online blogs, but WordPress has evolved since then.

Development 52

Development Website Ecommerce Programming 52

Percona

DECEMBER 12, 2023

Sometimes, the replica server might have replication errors, and the replica might be out of sync with the primary. In this case, we can use Percona Toolkit’ s pt-table-checksum and pt-table-sync to check the data drift between primary and replica servers and make the replica in sync with the primary. The print result is good.

Servers 91

Servers Database Testing Open Source 91

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 87

Monitoring Code Open Source Cache 87

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 75

Hardware C++ Database Open Source 75

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

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 86

Monitoring Servers Metrics Database 86

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 99

Database Testing Servers Open Source 99

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 120

AWS Storage Database Open Source 120

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

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

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

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 95

Database Performance C++ Engineering 95

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 102

Database Servers Open Source Tuning 102

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

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 94

Games Database Open Source C++ 94

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 66

Open Source Database Storage Engineering 66

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 277

Database Artificial Intelligence Metrics Monitoring 277

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

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 95

Open Source Traffic Tuning Database 95

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 81

Latency Tuning Open Source Network 81

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

C++ Open Source Servers Monitoring 77

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

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 70

Database Open Source Scalability Virtualization 70

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 69

Servers Database Processing Systems 69

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

NOVEMBER 1, 2023

This blog was originally published in January 2021 and updated in November of 2023. As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. on, you can use mysqlbinlog to stream binary logs from a remote server.

Best Practices 79

Best Practices Storage Strategy Database 79

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 Your MySQL connection id is 145 Server version: 8.0.29-21

C++ 94

C++ Database Servers Open Source 94

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 72

Best Practices Traffic Database Servers 72

Official Blog - World Web Technology

NOVEMBER 24, 2023

In this blog, we shall discuss the three popular JavaScript frameworks (ReactJS vs NodeJS vs AngularJS). Developers and business owners trust variant platforms globally available in the market; however, JavaScript is an exception. for server-side development, it’s not limited to that role. for server-side development.

Development 52

Development Virtualization Open Source Architecture 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