Percona

MARCH 13, 2023

Announcement I will be speaking at Percona Live 2023 about serverless PostgreSQL. Basically, you can view this as a PostgreSQL instance but without a storage layer Storage Broker Storage Broker is a coordination component between WAL Service and Pageserver. Join us at this event if you are interested! 50051 2.

Serverless 116

Serverless C++ Storage Latency 116

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory. The call for participation ends on March 2nd 23:59 SGT!

Performance 110

Performance Latency Cache Virtualization 110

Percona

AUGUST 18, 2023

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. 2023-05-12T08:10:39.374389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.

Open Source 65

Open Source Database Storage Engineering 65

Dynatrace

SEPTEMBER 8, 2023

SQL Username: Username of the user who has permission to login on the SQL server remotely and access the database. In the below query, we’re specifically searching for pending deposit transactions greater than $8,000 that occurred between 10:00:04 AM and 12:00:00 AM on August 21, 2023. This is used for identification purposes.

Database 269

Database Artificial Intelligence Metrics Monitoring 269

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 76

Cloud Open Source Strategy Best Practices 76

Brendan Gregg

JULY 4, 2021

AWS Graviton2); for memory with the arrival of DDR5 and High Bandwidth Memory (HBM) on-processor; for storage including new uses for 3D Xpoint as a 3D NAND accelerator; for networking with the rise of QUIC and eXpress Data Path (XDP); and so on.

Performance 140

Performance Latency Hardware Storage 140

Percona

AUGUST 17, 2023

In another survey, using multiple metrics for overall popularity, PostgreSQL ranks as the fourth most popular database management system ( DB-Engines, March 2023 ). Craig Kerstiens, crunchydata, August 2023 ) That evolution has created lots of reasons for its expanding popularity.

Open Source 76

Open Source Healthcare Social Media Database 76

Percona

JULY 24, 2023

PBM) introduced a GA version of incremental physical backups , which can greatly impact both the recovery time and the cost of backup (considering storage and data transfer cost). Snapshot backup/restore Technical Preview As already promised during Percona Live 2023, it’s my pleasure to deliver on that promise.

Availability 74

Availability Open Source Strategy Storage 74

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory. It was a great privilege.

Performance 52

Performance Latency Cache Virtualization 52

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.

Open Source 52

Open Source Servers Storage Scalability 52

Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. Reduced Resource Usage Optimizing resource-intensive queries and configurations can lead to a reduced burden on your server. An improperly configured server may not allocate sufficient resources or be optimized for the specific workload.

Tuning 52

Tuning Database Performance Hardware 52

Brendan Gregg

JULY 4, 2021

AWS Graviton2); for memory with the arrival of DDR5 and High Bandwidth Memory (HBM) on-processor; for storage including new uses for 3D Xpoint as a 3D NAND accelerator; for networking with the rise of QUIC and eXpress Data Path (XDP); and so on.

Performance 52

Performance Latency Hardware Storage 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 81

Open Source Servers Database Scalability 81

KeyCDN

FEBRUARY 22, 2023

Here is a roundup of frontend web development trends to keep an eye on in 2023. Another benefit is cost savings associated with server and data center setup and maintenance. If you have a large database of user information stored on your servers, consider introducing multi-factor identification.

Artificial Intelligence 111

Artificial Intelligence Development Serverless Website 111

Dynatrace

JANUARY 17, 2024

AI requires more compute and storage. Training AI data is resource-intensive and costly, again, because of increased computational and storage requirements. As a result, AI observability supports cloud FinOps efforts by identifying how AI adoption spikes costs because of increased usage of storage and compute resources.

Strategy 222

Strategy Artificial Intelligence Storage Cloud 222

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. was released on May 4, 2023. Release highlights include bug fixes and improvements provided by MongoDB and included in Percona Server for MongoDB 5.0.17-14,

Monitoring 75

Monitoring Open Source Database Servers 75

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. Hardware optimization : You need to ensure that the CPU, memory, and storage components meet the performance requirements of the database workload. In the case of a server crash, data might be lost even though the client received a success message on commit.

Tuning 52

Tuning Efficiency Database Performance 52

Percona

JANUARY 30, 2023

Today’s post includes those releases and updates that have come out since January 9, 2023. was made available on January 23, 2023. This update to the release of Percona Distribution for MySQL using the Percona Server for MySQL includes a new version of Percona Toolkit 3.5.1 was released on January 23, 2023.

Open Source 81

Open Source Storage AWS Cloud 81

Percona

SEPTEMBER 25, 2023

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. The /etc/pgbackrest/pgbackrest.conf file contains crucial information related to our primary database server. These files play distinct roles in our backup and expiration processes.

Database 90

Database Open Source Storage Servers 90

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 84

Engineering Database Servers Analytics 84

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 158

Database Government Games Servers 158

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

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

Percona

FEBRUARY 23, 2023

It is a common practice that before a backup can be stored in the cloud or on a dedicated backup server, it has to be prepared first locally and later copied to the destination. Fortunately, there are ways to skip the local storage entirely and stream MongoDB backups directly to the destination. 0 document(s) failed to restore. %H-%M)/db2.zst

AWS 118

AWS Storage Database Open Source 118

Sutter's Mill

MARCH 11, 2024

And in all recent years including 2023 (see figures 1’s four highlighted rows, and figure 2), these four constitute the bulk of those oft-quoted 70% of CVEs (Common [Security] Vulnerabilities and Exposures) related to language memory unsafety. Kubernetes Secrets on public GitHub repos), misconfigured servers (e.g.,

C++ 139

C++ Programming Code Java 139

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

Dynatrace

MAY 8, 2023

In fact, the Dynatrace 2023 CIO Report found that 78% of respondents deploy software updates every 12 hours or less. Infrastructure monitoring Infrastructure monitoring reviews servers, storage, network connections, virtual machines, and other data center elements that support applications.

DevOps 220

DevOps Efficiency Monitoring Infrastructure 220

Percona

JULY 17, 2023

1 among non-relational/document-based systems ( DB-Engines, July 2023 ). Those problems (some with shared elements) include: High cost and complicated pricing structure : Many companies say MongoDB has an expensive and complicated pricing structure ( Cloud Zero, January 2023 ). It ranks No. Couchbase — No.

Open Source 74

Open Source Database Scalability Software 74

Percona

JULY 5, 2023

EOL is set for the end of October 2023. dump ERROR 1273 (HY000) at line 24: Unknown collation: 'utf8mb4_0900_ai_ci' ERROR 1726 (HY000) at line 35: Storage engine 'InnoDB' does not support system tables. Checking server version. Upgrading to MySQL version 8.0 is a hot topic since version 5.7 turns out not as you hoped for.

C++ 114

C++ Database Servers Testing 114

Percona

MAY 15, 2023

This operation is quite expensive but our database can run it in a few milliseconds or less, thanks to several optimizations that allow the node to execute most of them in memory with no or little access to mass storage. The key factor is that the whole data structure resides in the same location (node), facilitating the operations.

Traffic 121

Traffic Scalability Database Servers 121

Percona

OCTOBER 17, 2023

Dynamic WiredTiger tickets As a brief recap, WiredTiger tickets in MongoDB serve as the concurrency control mechanism within the WiredTiger storage engine. Without further ado, let’s get started. These tickets are categorized into Read tickets and Write tickets. 7001 closed percona> exit /opt/mongo/6.0.6-5/bin/mongod

Metrics 97

Metrics C++ Storage Database 97

Percona

JUNE 23, 2023

It is a good practice to compress the backups to save costs on storage and to encrypt the backups so those can’t be used if the files are compromised as long as you keep your encryption keys safe! If you have multiple CPUs on the server, you can increase the number of threads for each operation.

Servers 78

Servers Processing Speed Open Source 78

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. The speed of backup also depends on allocated IOPS and type of storage since lots of read/writes would be happening during this process. In today’s data-driven world, losing critical data can be catastrophic for any organization.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

NOVEMBER 1, 2023

This blog was originally published in January 2021 and updated in November of 2023. on, you can use mysqlbinlog to stream binary logs from a remote server. A good approach is to keep 1-7 days locally on the backup server in case a fast recovery is needed, and this depends on your business regulations. From MySQL 5.6

Best Practices 77

Best Practices Storage Strategy Database 77

Percona

AUGUST 29, 2023

A single command to deploy the operator would be: kubectl apply -f [link] --server-side Init SQL script Init SQL allows the creation of the database cluster with some initial data in it. In this case, the backups should be stored on some object storage. Please follow our installation instructions and use your favorite way.

Storage 90

Storage Database Media Open Source 90

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 134

Tuning Cache Servers Benchmarking 134

Percona

OCTOBER 18, 2023

The findings from our 2023 Open Source Database Report highlight that a substantial 42% of all database instances are now licensed through community-supported open source models, and GitHub reports that over 30% of Fortune 100 companies have established open source program offices (OSPO) to coordinate and manage their open source initiatives.

Open Source 89

Open Source Database Hardware Strategy 89