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 126

Database Servers Testing Programming 126

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. Web Design Solutions Made Easy!

Design 59

Design Software Software Website 59

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 103

Servers C++ Processing Testing 103

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

C++ Servers Storage Speed 107

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 80

Servers Open Source Database Systems 80

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 93

Servers Database Testing Open Source 93

Percona

DECEMBER 22, 2023

was released on December 21, 2023. This blog post covers the main changes in this release. Quality improvements In my last Percona Toolkit release blog, What’s New in Percona Toolkit 3.5.5 , I wrote about how we plan to make regression tests part of the release process. 2023-12-21T15:29:22 Creating triggers.

Operating System 99

Operating System Programming Open Source Testing 99

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. The /etc/pgbackrest/pgbackrest.conf file contains crucial information related to our primary database server.

Database 97

Database Open Source Storage Servers 97

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 89

Database Open Source Testing Servers 89

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 91

Engineering Database Servers Analytics 91

Percona

OCTOBER 31, 2023

persons`(`personid`, `lastname`, `firstname`, `address`, `city`, `insert_timestamp`) VALUES ('1', 'Iglesias', 'Par', 'IND', 'Jaipur', '2023-07-27 07:10:10') /*percona-toolkit src_db:foo src_tbl:persons src_dsn:P=3306,h=192.168.0.14 This will help identify any discrepancies and ensure data consistency between both primary servers. $

Database 104

Database Servers Efficiency Performance 104

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

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 80

Open Source Database Servers Programming 80

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

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 87

Programming Servers Database Hardware 87

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 94

Scalability Database Open Source Systems 94

Percona

JUNE 26, 2023

To restore, we can follow either of below approaches: If the standby server is there and the issue does not persist on that, then we can fix the issue by taking logical backup from the standby server, dropping the table on primary, and recreating it using the backup taken.

Hardware 78

Hardware C++ Database Open Source 78

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. Importance of monitoring the InnoDB buffer pool resize Since MySQL 5.7.5,

Monitoring 90

Monitoring Code Open Source Cache 90

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 123

AWS Storage Database Open Source 123

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 102

Database Testing Servers Open Source 102

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 89

Monitoring Servers Metrics Database 89

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

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 83

Servers Processing Speed Open Source 83

Dynatrace

JUNE 8, 2022

Windows: Windows Server 2004. Linux: SUSE Linux Enterprise Server 11.4. Windows: Windows Server 20H2. The following operating systems will no longer be supported starting 01 January 2023. Linux: SUSE Linux Enterprise Server 12.3. JBoss Application Server 6, 7 for Java. Windows: Windows Server 1909.

Java 157

Java Operating System Lambda Serverless 157

Percona

MAY 16, 2023

The connection control plugin library allows administrators to introduce an increasing delay in the server response to connections after a designated number of consecutive unsuccessful login attempts. The idea behind using a connection control plugin is to configure a MySQL server so that the server will delay its response.

Servers 122

Servers Database Monitoring Testing 122

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 97

Games Database Open Source C++ 97

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 2023-07-26T12:22:43 Copying approximately 4 rows. email`, NEW.`birthdate`,

Database 98

Database Performance C++ Engineering 98

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 76

Open Source Servers Scalability Database 76

Percona

MARCH 13, 2023

Announcement I will be speaking at Percona Live 2023 about serverless PostgreSQL. I prefer to test a distributed deployment where each component is placed on different servers or virtual machines, that’s why I do not put it into docker-compose. The assumption is that I use a reachable server with IP address 172.16.0.9.

Serverless 121

Serverless C++ Storage Latency 121

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 105

Database Servers Open Source Tuning 105

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 68

Open Source Database Storage Engineering 68

Dynatrace

JULY 24, 2023

In this blog, we will dive into the transformative power of answer-driven automation. When a server experiences an outage, the system promptly triggers an alert and initiates actions like restarting a server or redirecting traffic to a redundant server. Download the free 2023 CIO Report. Download now!

DevOps 222

DevOps Traffic Efficiency Servers 222

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 78

Open Source Database Scalability Software 78

Percona

FEBRUARY 16, 2023

[ec2-user@ip-172-31-32-242 ~]$ sudo systemctl stop mysql [ec2-user@ip-172-31-32-242 ~]$ sudo systemctl start mysql [ec2-user@ip-172-31-32-242 ~]$ mysql -u root -p mysql> select * from t1; ERROR 3185 (HY000): Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.

Database 120

Database Servers Engineering Testing 120

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 92

Open Source Database Operating System Programming 92

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 272

Database Artificial Intelligence Metrics Monitoring 272

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 98

Open Source Traffic Tuning Database 98