Percona

MARCH 13, 2023

to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 server with Percona XtraBackup. In my lab, we have two test nodes: PRIMARY: mysql57 (192.168.56.111) with Percona Server 5.7 server instances are ready for an upgrade. On primary server mysql5.7,

Servers 100

Servers C++ Storage Systems 100

Percona

JUNE 15, 2023

Sometimes we might need to install/upgrade Percona Server for MySQL /MySQL 8 to a particular version in a test or production environment. Install Percona Server for MySQL 8 specific version packages via repository. Download specific Percona Server for MySQL 8 tarball packages and install them manually. Setting up curl (7.74.0-1.3+deb11u7).

Servers 82

Servers C++ Database Systems 82

Percona

MARCH 27, 2023

Today’s post includes those releases and updates that have come out since March 13, 2023. was released on March 23, 2023. On March 15, 2023, Percona Distribution for MySQL (Percona XtraDB Cluster-based variant) 8.0.31 Percona Distribution for MySQL (Percona Server for MySQL-based variation) 8.0.32 Take a look!

Open Source 76

Open Source Servers Scalability Cache 76

Percona

APRIL 10, 2023

Today’s post includes those releases and updates that have come out since March 27, 2023. was released on March 27, 2023. Release highlights include: Added a new extension pgpool – a middleware between PostgreSQL server and client for high availability, connection pooling, and load balancing. Take a look!

Open Source 75

Open Source Servers AWS Database 75

Percona

MAY 29, 2023

Today’s post includes those releases and updates that have come out since May 8, 2023. On May 22, 2023, we released updates to Percona Distribution for PostgreSQL versions 15.2, On May 25, 2023, Percona Distribution for MongoDB 6.0.6 On Tuesday, May 9, 2023, we released Percona Distribution for MongoDB 4.4.21.

Open Source 75

Open Source Servers Scalability Database 75

Dynatrace

MARCH 18, 2024

Yet, in 2023, 82% of cloud decision makers reported that managing cloud spend was their top challenge, according to one source. Are there rogue servers running in the environment where ITOps, CloudOps, or another team can’t assign or identify who’s financially responsible for it? ” But Dynatrace goes further.

Best Practices 238

Best Practices Strategy Cloud AWS 238

Percona

JULY 24, 2023

Today’s post includes those releases and updates that have come out since July 10, 2023. PMM) was released on July 13, 2023. fixed critical security CVE-2023-3128 by changing the authentication mechanism to rely solely on the user’s unique ID provided by the identity provider. was released on July 19, 2023.

Open Source 71

Open Source Scalability Database Monitoring 71

Percona

DECEMBER 6, 2023

The PMM Dump performs a logical backup of the performance metrics collected by the PMM Server and imports them into a different PMM Server instance. PMM Dump allows you to share monitoring data collected by your PMM server securely with the Percona Support team. 2023-01-05T20:01:33+03:00 INF Processing 1/49 chunk.

Monitoring 93

Monitoring Metrics Analytics Open Source 93

Percona

FEBRUARY 27, 2023

Today’s post includes those releases and updates that have come out since February 13, 2023. Percona Monitoring and Management 2.35 (PMM) was released on February 24, 2023. Update to the release of Percona Distribution for MySQL (Percona Server for MySQL-based variant) 8.0.31 was released on February 15, 2023.

Monitoring 68

Monitoring Open Source Database Software 68

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 59

Design Software Software Website 59

Percona

MARCH 28, 2023

Repository means the location/path on the server or the cloud where the actual copy of the backup will reside. This attribute helps take the redundant copies of the databases at multiple locations remotely on different servers or locally on the same server. Let’s discuss a few scenarios one by one. Scenarios: 1.

Servers 80

Servers Azure AWS Cloud 80

Dynatrace

JANUARY 23, 2024

In May 2023 the critical vulnerability CVE-2020-36641 in the Java library aXMLRPC was published in the National Vulnerability Database (NVD). XML external entity (XXE) exploit The aXMLRPC library allows its users to connect to a server and perform RPC calls using the XML-RPC protocol over HTTP. xml version="1.0"?> > <!DOCTYPE

Java 211

Java Servers Code Software 211

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 121

Database Servers Testing Programming 121

Percona

SEPTEMBER 15, 2023

At Percona Managed Services , we manage Percona Server for MySQL , Community MySQL, and MariaDB. In my lab, we have two test nodes; both servers will have Debian 11 and MariaDB10.5.19 In my lab, we have two test nodes; both servers will have Debian 11 and MariaDB10.5.19 mariadb.list.old_1 # [info] MariaDB Server version 10.5.19

Servers 97

Servers C++ Processing Testing 97

Percona

SEPTEMBER 19, 2023

This issue most often occurs when there is significant MySQL server activity during the backup operation, and the redo log file storage media operates faster than the backup storage media. Enabling redo log archiving on the server requires setting a value for the innodb_redo_log_archive_dirs system variable. Type 'help' or '?'

C++ 101

C++ Servers Storage Speed 101

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 91

Database Open Source Storage Servers 91

Dynatrace

JULY 11, 2023

The MOVEit vulnerability is a critical SQL injection flaw in the web application MOVEit Transfer , which MITRE published as CVE-2023-34362 on May 31, 2023. When exploiting the vulnerability, attackers can gain remote code injection capabilities in the MOVEit server and modify or steal sensitive data from its database.

Database 163

Database Government Games Servers 163

Percona

DECEMBER 14, 2023

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. On the primary server, advance the logical replication slot created in step two. Ensure all tables have a replica identity set.

Servers 75

Servers Open Source Database Systems 75

Percona

DECEMBER 22, 2023

was released on December 21, 2023. PR-720 simplifies the build process for the Percona Toolkit. 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 93

Operating System Programming Open Source Testing 93

Percona

OCTOBER 11, 2023

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. Once you have installed MongoShake, you need to configure it for the migration process. NOTE : These tools are not officially supported by Percona. cd MongoShake.

Database 84

Database Open Source Testing Servers 84

Dynatrace

JANUARY 31, 2024

With PowerConnect, collecting data from SAP systems and fueling the Dynatrace platform, Dynatrace automatically uncovers the topology model of the SAP landscape, providing a clear and comprehensive view of the relationships and dependencies among different systems, servers, databases, applications, and interfaces. Architectural overview.

Java 194

Java Analytics Best Practices Monitoring 194

Percona

AUGUST 18, 2023

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. You can run multiple instances on a server to test your backups with the correct version and configs.

Programming 83

Programming Servers Database Hardware 83

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

OCTOBER 3, 2023

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. Create a new job to refresh the materialized view each night at 12:00 Postgres server time zone. psql psql (12.16) Type "help" for help.

Open Source 76

Open Source Database Servers Programming 76

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 78

Servers Processing Speed Open Source 78

Percona

DECEMBER 29, 2023

These connections can accumulate, eventually exhausting server resources and causing the system to become unresponsive. Pressure builds up, and DBAs give up in most cases and allow settings that the database server cannot accommodate. It goes back to “idle” when the processing is over. Attempting reset: Succeeded.

Servers 78

Servers Database C++ Airlines 78

Percona

MARCH 3, 2023

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. Check the database’s topology, whether one or more servers were replicating, if it was a Percona XtraDB Cluster , etc. mysqlserver01=127.0.0.2 [RW] RW] [ver: 8.0.31-23]

Database 96

Database Testing Servers Open Source 96

Percona

DECEMBER 14, 2023

Will 2023 be called the year of Generative Artificial Intelligence (AI)? This streamlined process reduces the risk of errors and simplifies the downgrade procedure. implemented improved data integrity checks during the downgrade process. In summary, the downgrade process in MongoDB 7.0 Server: Stop the MongoDB 7.0

Database 84

Database Artificial Intelligence Servers Operating System 84

Dynatrace

MAY 8, 2023

In fact, the Dynatrace 2023 CIO Report found that 78% of respondents deploy software updates every 12 hours or less. But when and how does DevOps monitoring fit into the process? The process involves monitoring various components of the software delivery pipeline, including applications, infrastructure, networks, and databases.

DevOps 225

DevOps Efficiency Monitoring Infrastructure 225

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 84

Monitoring Code Open Source Cache 84

Percona

SEPTEMBER 14, 2023

Once we configured the setup, the ClickHouse server will act as a replica. sec) From the ClickHouse end Make sure you have MySQL port access from the ClickHouse server to the MySQL server. file: /etc/clickhouse-server/users.xml) #vi /etc/clickhouse-server/users.xml <profiles> <default> <!--

Engineering 85

Engineering Database Servers Analytics 85

Official Blog - World Web Technology

JUNE 13, 2023

It includes downloading and setting up the software on a server, database configuration, and theme and plugin installation. He should be able to resolve all types of errors such as conflicts between WordPress themes and plugins, web server issues, hosting issues, fixing errors and bugs in custom code, etc. It offers many benefits.

Development 52

Development Website Ecommerce Code 52

Dynatrace

JULY 24, 2023

We will also explore the evolution of DevOps automation and the significance of data-driven answers in unlocking streamlined, automated DevOps and SRE processes. Business process automation Business process automation is the foundation for improving operational efficiency. Download the free 2023 CIO Report. Download now!

DevOps 225

DevOps Traffic Efficiency Servers 225

Percona

OCTOBER 20, 2023

This is how Citus defines sharding: “Sharding is a technique used in database systems and distributed computing to horizontally partition data across multiple servers or nodes. Add Citus as a PostgreSQL library Once Citus is installed, we will add “citus” as a shared library to preload when the PostgreSQL server starts.

Scalability 90

Scalability Database Open Source Systems 90

Percona

MAY 2, 2023

out" INFO[2023-04-22 06:54:10] Running pt-stalk --no-stalk --iterations=2 --sleep=30 --host=localhost --dest=/home/vagrant/pt/ --port=3306 --user=root --password= ** INFO[2023-04-22 06:55:42] Creating output file "/home/vagrant/pt/pt-summary_2023-04-22_06_55_42.out" 6032: connect: connection refused" source="exporter.go:169"

Database 89

Database Systems Open Source Engineering 89

Official Blog - World Web Technology

APRIL 12, 2023

For payment processes, SEO, ecommerce, content forms, page building, security, and other features, you will get multiple plugins to choose from. JavaScript is a server-side programming language and is also known as a scripting language as well. The post What Skills Are Required For WordPress Developer In 2023?

Development 52

Development Website Ecommerce Programming 52

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 92

Games Database Open Source C++ 92