Percona

JANUARY 30, 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 January 9, 2023. was released on January 23, 2023.

Open Source 111

Open Source Storage AWS Cloud 111

Percona

DECEMBER 4, 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. On November 27, 2023, Percona Distribution for MySQL (PS- based variant) 8.1.0

Open Source 110

Open Source Azure Servers Programming 110

Percona

MAY 8, 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. On May 2, 2023, Percona Monitoring and Management 2.37 (PMM) was released.

Monitoring 103

Monitoring Open Source Database Servers 103

KeyCDN

FEBRUARY 22, 2023

Here is a roundup of frontend web development trends to keep an eye on in 2023. Each of these platforms offers a wide range of services and tools for web application development and deployment, including storage, databases, and serverless computing.

Artificial Intelligence 111

Artificial Intelligence Development Serverless Website 111

Percona

APRIL 10, 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 March 27, 2023. was released on March 27, 2023.

Open Source 107

Open Source Servers Database AWS 107

Dynatrace

AUGUST 21, 2023

OpenTelemetry is an open source framework that provides agents, APIs, and SDKs that automatically instrument, generate, and gather telemetry data. It also provides tools and integrations with popular open source projects, including Kubernetes, Apache Kafka, Jaeger, and Prometheus, among others. What is OpenTelemetry?

Open Source 246

Open Source Analytics Lambda Metrics 246

Percona

APRIL 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. 24 was released on April 18, 2023. 24 (2023-03-20) release notes. Take a look!

Open Source 98

Open Source Storage Servers Database 98

Percona

JUNE 12, 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. was released on June 5, 2023. was announced on June 5, 2023. Take a look!

Open Source 98

Open Source Servers Database Scalability 98

Percona

FEBRUARY 23, 2023

Fortunately, there are ways to skip the local storage entirely and stream MongoDB backups directly to the destination. At the same time, the common goal is to save both the network bandwidth and storage space (cost savings!) zst 2023-02-07T19:33:58.138+0100 writing db2.products people 16.0MB 2023-02-08T00:42:43.217+0100 db2.products

AWS 142

AWS Storage Database Open Source 142

Dynatrace

DECEMBER 18, 2023

According to the 2023 Kubernetes in the Wild report , 65% of organizations use Prometheus. Another source reported a 43% overall increase in Prometheus adoption for the last six months of 2021. But often, we use additional services and solutions within our environment for backups, storage, networking, and more.

Metrics 245

Metrics Engineering Energy Tuning 245

Percona

SEPTEMBER 25, 2023

PostgreSQL is a powerful and popular open source relational database management system. 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. pgBackRest is a highly efficient and versatile tool for managing PostgreSQL backups.

Database 117

Database Open Source Servers Storage 117

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 113

Cloud Open Source Strategy Best Practices 113

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

C++ Servers Storage Speed 124

Percona

MARCH 13, 2023

First, let’s try streaming copy from mysql57 to mysql8 server as this does not need additional storage. 23) initializing of server in progress as process 6660 2023-03-01T02:38:23.939215Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. Prepare the backup on MySQL 8 with Percona XtraBackup 8.0, for this database.

Servers 122

Servers C++ Storage Systems 122

Percona

MARCH 28, 2023

MongoD attempts to go into crash recovery and looks for anything there in the Journal files. The trimmed output would look something like the one below in the “mongod log” files. {"t":{"$date":"2023-03-27T11:22:48.360+00:00"},"s":"I", Download Percona Distribution for MongoDB Today!

Hardware 111

Hardware C++ Storage Cache 111

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.

Open Source 98

Open Source Database Scalability Software 98

Percona

JUNE 29, 2023

When all data-bearing replica set members are available, and the index is created with default commitQuorum , below are the details from the Primary and the Secondary nodes. Status of nodes: rs1:PRIMARY> rs.status().members.forEach(function members.forEach(function (d) {print(d.name) + " " + print(d.stateStr)}); 127.0.0.1:27017

Servers 98

Servers C++ Storage Best Practices 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 98

Open Source Healthcare Social Media Database 98

Percona

SEPTEMBER 27, 2023

PostgreSQL Partition Manager — ‘pg_partman’ — is an open source extension freely available, widely supported, and actively maintained by the PostgreSQL community. pg_partman creates and manages both time-based and serial-based table partition sets.

Storage 114

Storage Open Source Database Efficiency 114

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,

Open Source 98

Open Source Storage Availability Processing 98

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. Download Percona Distribution for MongoDB Today!

Metrics 120

Metrics C++ Database Storage 120

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 121

Performance Latency Hardware Storage 121

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. 40100 WITH CONSISTENT SNAPSHOT */ 2023-08-19T14:14:38.575577Z 12 Query SELECT TABLE_NAME AS table_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE != Elapsed: 0.004 sec.

Engineering 114

Engineering Database Servers Analytics 114

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 98

Availability Open Source Strategy Storage 98

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! ibd.qp.xbcrypt 2023-04-21T00:27:14.875316-00:00 24 [Note] [MY-011825] [Xtrabackup] Compressing and encrypting. dbxxxx/tb1.ibd

Servers 103

Servers Processing Speed Open Source 103

The Netflix TechBlog

SEPTEMBER 10, 2024

Since the rewrite was completed in mid-2023, the message processor component has been completely zero touch, happily automated and running reliably on its own. KeyValue is an abstraction over the storage engine itself, which allows us to choose the best storage engine that meets our SLO needs.

Latency 234

Latency Cache Tuning Efficiency 234

Percona

AUGUST 18, 2023

And I agree that in the modern age of cloud and huge flash storage, the vast majority of companies will never need to consider doing this in prod, but there is always a chance of its need. er tail: cannot open ‘/data/mysql/prod3306.er’ er tail: cannot open ‘/data/mysql/prod3306.er’ 10-Linux.x86_64.ssl101.tar.gz

Programming 98

Programming Servers Database Open Source 98

Percona

AUGUST 29, 2023

Among its many capabilities, a Citus cluster can: Create distributed tables that are sharded across a cluster of PostgreSQL nodes to combine their CPU, memory, storage, and I/O capacity. Columnar storage of tables can compress data, speeding up scans and supporting fast projections, both on regular and distributed tables.

C++ 98

C++ Database Storage Testing 98

Brendan Gregg

FEBRUARY 28, 2023

It was a great privilege. ## SREcon 2023 CFP Tech moves fast, however, and I have little time to reflect on 2022 when there's 2023 to plan! I'm now program co-chair for SREcon 2023 APAC, and our 2023 conference is June 14-16 in Singapore. The call for participation ends on March 2nd 23:59 SGT!

Performance 103

Performance Latency Cache Virtualization 103

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. In the MySQL open source ecosystem, we have only two consolidated ways to perform sharding — Vitess and ProxySQL.

Traffic 144

Traffic Scalability Database Servers 144

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Therefore, DBAs must take a piecemeal approach to achieve HA with PostgreSQL, bringing together open source extensions and tools from multiple sources.

Availability 98

Availability Open Source Architecture Database 98

Adrian Cockcroft

NOVEMBER 26, 2023

In their annual sustainability report in July 2023 AWS did update their list of sustainable regions to highlight 19 regions that are 100% sustainable — using an annual local market methodology for scope 1 and 2. Google Cloud and Microsoft Azure released Scope 3 data in 2021.

AWS 52

AWS Energy IoT Best Practices 52

Percona

DECEMBER 1, 2023

The PostgreSQL partition manager pg_partman is an open source extension widely supported and actively maintained by the PostgreSQL community. pg_partman is an extension that streamlines the creation and management of table partition sets, supporting both time-based and serial-based partitioning approaches.

Open Source 103

Open Source Storage Performance Design 103

Percona

JULY 3, 2023

Also, please find below the related blogs for reference: PostgreSQL Sharding: An Overview and MongoDB Comparison Performing ETL Using Inheritance in PostgreSQL Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open-source community in a single distribution, designed and tested to work together.

Storage 98

Storage Database Performance Open Source 98

Percona

APRIL 7, 2023

In MySQL, considering the standard storage engine, InnoDB , the data cache is called Buffer Pool. Percona Monitoring and Management is a best-of-breed open source database monitoring solution. In PostgreSQL, it is called shared buffers.

Tuning 145

Tuning Cache Servers Benchmarking 145

Percona

JUNE 6, 2023

This blog was originally published in January 2012 and was updated in June 2023. Increased Storage Requirements : One of the disadvantages of full backups is the increased storage requirements due to the fact that they capture a complete copy of all data and files. What is an incremental backup? What is an incremental backup?

Storage 70

Storage Strategy Network Efficiency 70

Percona

NOVEMBER 1, 2023

This blog was originally published in January 2021 and updated in November of 2023. Offsite Storage It’s highly recommended to copy all the backup methods to another place, like the cloud or an external file server, so in case of host failure or data center failure, you have another copy.

Best Practices 81

Best Practices Storage Strategy Database 81