Percona

JULY 24, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. PMM) was released on July 13, 2023. was released on July 19, 2023.

Open Source 72

Open Source Scalability Database Monitoring 72

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 103

Servers C++ Storage Systems 103

Percona

FEBRUARY 27, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Today’s post includes those releases and updates that have come out since February 13, 2023. Take a look! was released.

Monitoring 69

Monitoring Open Source Database Software 69

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 83

Servers C++ Database Systems 83

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 96

Monitoring Metrics Analytics Open Source 96

Percona

SEPTEMBER 25, 2023

PostgreSQL is a powerful and popular open source relational database management system. 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. Percona and PostgreSQL work better together.

Database 93

Database Open Source Storage Servers 93

Percona

SEPTEMBER 19, 2023

Now, since backup speed and compactness are important for busy, important databases, Percona’s open source physical backup solution – Percona XtraBackup (PXB) , takes into account all these aspects and benefits MySQL world with its exceptional capabilities! Copyright (c) 2016, 2023, Oracle and/or its affiliates.

C++ 104

C++ Servers Storage Speed 104

Dynatrace

JUNE 15, 2023

Cloud application security is a combination of policies, processes, and controls that aim to reduce the risk of exposing cloud-based applications to compromise or failure from external or internal threats. However, open source software is often a vector for security vulnerabilities. What is cloud application security?

Cloud 173

Cloud Open Source Architecture Monitoring 173

Percona

MARCH 28, 2023

To briefly explain pgBackRest, it is an open source backup tool that takes FULL Backup, Incremental Backup, and Differential Backup for PostgreSQL databases. Repository means the location/path on the server or the cloud where the actual copy of the backup will reside. Let’s discuss a few scenarios one by one. Scenarios: 1.

Servers 82

Servers Azure AWS Cloud 82

Percona

DECEMBER 27, 2023

As we at Percona wind down 2023 and look into what the next year holds, our attention is drawn to the cloud-native landscape and how it is maturing, growing, and evolving. KubeCon NA 2023 recap The theme for KubeCon NA was very clear — AI and Large Language Models (LLMs). We expect that number to rise higher in 2024.

Cloud 79

Cloud Open Source Strategy Best Practices 79

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 123

Database Servers Testing Programming 123

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 77

Servers Open Source Database Systems 77

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 86

Database Open Source Testing Servers 86

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 77

Open Source Database Servers Programming 77

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 95

Operating System Programming Open Source Testing 95

Percona

OCTOBER 20, 2023

Citus is an open-source extension for PostgreSQL that expands its capacity to manage databases of varying scales, ranging from individual nodes to extensively distributed database clusters. This process ensures that rows with similar ID values are distributed across multiple shards in a way that attempts to distribute the data evenly.

Scalability 92

Scalability Database Open Source Systems 92

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 84

Programming Servers Database Hardware 84

Percona

OCTOBER 31, 2023

Percona has a mission to provide the best open source database software, support, and services so our users can innovate freely. 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.”

Open Source 88

Open Source Database Operating System Programming 88

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 86

Monitoring Code Open Source Cache 86

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 86

Database Artificial Intelligence Servers Operating System 86

Percona

DECEMBER 29, 2023

Inadequate application-side pooling: Suboptimal application-side pooling can lead to opening a large number of connections, and they may remain open and unused, consuming valuable resources. These connections can accumulate, eventually exhausting server resources and causing the system to become unresponsive.

Servers 80

Servers Database C++ Airlines 80

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 91

Database Systems Open Source Engineering 91

Dynatrace

MAY 17, 2023

When software runs in a monolithic stack on on-site servers, observability is manageable enough. OpenTelemetry, the open source observability tool, has emerged as an industry-standard solution for instrumenting application telemetry data to make it observable. OpenTelemetry is a free and open source take on observability.

Metrics 177

Metrics Open Source Traffic Cache 177

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 93

Games Database Open Source C++ 93

Percona

SEPTEMBER 14, 2023

MySQL is an outstanding open source transactional database used by most web-based applications and is very good at handling OLTP workloads. 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.

Engineering 87

Engineering Database Servers Analytics 87

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 80

Servers Processing Speed Open Source 80

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 98

Database Testing Servers Open Source 98

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. In another survey, using multiple metrics for overall popularity, PostgreSQL ranks as the fourth most popular database management system ( DB-Engines, March 2023 ). It has evolved steadily, however, during 25 years as an open source project.

Open Source 78

Open Source Healthcare Social Media Database 78

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 73

Open Source Servers Scalability Database 73

Percona

OCTOBER 2, 2023

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. And did I mention they are open source?!

Cache 98

Cache Database Virtualization Servers 98

Percona

OCTOBER 17, 2023

That’s very welcome after upgrade/downgrade processes when metadata is touched after FCV change. In previous releases, the downgrade process was relatively simple: Have a valid backup. It performs a series of consistency checks ( 13 checks ) on sharding metadata and indexes (not default), looking for inconsistencies.

Metrics 100

Metrics C++ Storage Database 100

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

Official Blog - World Web Technology

APRIL 12, 2023

Here are the benefits of WordPress: It is a free, open-source CMS and can be used by anyone who wants to develop a website. For payment processes, SEO, ecommerce, content forms, page building, security, and other features, you will get multiple plugins to choose from. Take your time and choose the best one.

Development 52

Development Website Ecommerce Programming 52

Percona

AUGUST 30, 2023

The most common parameter used by the PostgreSQL server (postmaster) will be PGDATA, which sets the parameter data_directory. Here is an example: $ export PGDATA=/home/postgres/data $ export PGPORT=5434 $ pg_ctl start waiting for server to start.2023-08-04 2023-08-04 06:53:09.637 UTC [5787] LOG: starting PostgreSQL 15.3

Database 101

Database Servers Open Source Tuning 101

Percona

OCTOBER 4, 2023

was released on October 3, 2023. We plan to make regression tests part of the release process starting from the next version. They include more vulnerabilities than Open Source tools that we use, can find, and help us improve the quality of Go-based tools. Percona Toolkit 3.5.5 Download Percona Toolkit

Open Source 99

Open Source Code Testing Systems 99

Percona

APRIL 10, 2023

Percona Backup for MongoDB (PBM) is an open source, distributed, and low-impact solution for consistent backups of MongoDB sharded clusters and replica sets. In March 2023, we discovered an issue with physical backups, which, under certain conditions, can cause the restore to fail ( PBM-1058 ). With PBM v2.0.0, wt Am I affected?

Open Source 76

Open Source Storage Availability Processing 76

Percona

OCTOBER 19, 2023

sudo percona-release setup ppg-15 # Install "percona-ppg-server-15" package sudo apt install percona-ppg-server-15 Now, let’s verify if the service is operating correctly. Node main on port 5432 ubuntu@ip-172-31-88-41:~$ ss -tuln Netid State Recv-Q Send-Q Local Address:Port Peer Address:Port Process tcp LISTEN 0 244 172.31.88.41:5432

Scalability 84

Scalability Database Open Source Traffic 84