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. Percona Distribution for MySQL is a single solution with the most critical enterprise components from the MySQL open source community, designed and tested to work together. Take a look!

Open Source 91

Open Source Storage AWS Cloud 91

Dynatrace

SEPTEMBER 8, 2023

To achieve this, we’ll create a Grail bucket specifically designed to retain data for a duration of 10 years (3,657 days). 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.

Database 279

Database Artificial Intelligence Metrics Monitoring 279

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 125

AWS Storage Database Open Source 125

Dynatrace

JULY 11, 2023

What the software has been designed to log is what we get. 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.

Database 168

Database Government Servers Games 168

Percona

DECEMBER 4, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Today’s post includes those releases and updates that have come out since November 13, 2023. On November 27, 2023, Percona Distribution for MySQL (PS- based variant) 8.1.0 Take a look.

Open Source 86

Open Source Azure Servers Programming 86

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 88

Open Source Servers Database Scalability 88

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. 14 On May 4, 2023, Percona Server for MongoDB 5.0.17-14 Tech preview) was released on May 4, 2023. Take a look!

Monitoring 82

Monitoring Open Source Database Servers 82

Dynatrace

JUNE 7, 2023

According to the Kubernetes in the Wild 2023 report, “Kubernetes is emerging as the operating system of the cloud.” Kubernetes also gives developers freedom of choice when selecting operating systems, container runtimes, storage engines, and other key elements for their Kubernetes environments.

Open Source 219

Open Source Social Media Infrastructure Operating System 219

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. March 29, 2023, saw the release of Percona Distribution for PostgreSQL 12.14. was released on March 31, 2023. was released on March 28, 2023. .” was released on March 28, 2023.

Open Source 83

Open Source Servers Database AWS 83

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. Combined, these factors can make the “expire” step take a long time to finish, disrupting your backup schedule and causing conflicts with new backups.

Database 101

Database Open Source Storage Servers 101

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

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 94

Hardware C++ Storage Cache 94

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

The Netflix TechBlog

SEPTEMBER 10, 2024

To support this growth, we’ve revisited Pushy’s past assumptions and design decisions with an eye towards both Pushy’s future role and future stability. 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.

Latency 233

Latency Cache Tuning Efficiency 233

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 108

Metrics C++ Database Storage 108

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 128

Traffic Scalability Database Servers 128

Percona

SEPTEMBER 27, 2023

DEFAULT ‘on’::text Because we specified ‘2’ for premake in the create_parent function, you can observe that two partitions ahead have been created, as shown in the table definition below.

Storage 106

Storage Open Source Database Efficiency 106

Dynatrace

JANUARY 23, 2024

In 2023, organizations mostly used these services as a technology disruptor and capability enabler. Edge computing brings compute and data storage closer to where data is generated to help reduce costs, boost performance, and improve customer experience. But by 2028, these cloud-based services will be a business necessity.

Performance 198

Performance DevOps Innovation Artificial Intelligence 198

Percona

MARCH 30, 2023

Further, open source databases can be modified in infinite ways, enabling institutions to meet their specific needs for data storage, retrieval, and processing. Non-relational databases: Instead of tables, non-relational (NoSQL) databases use document-based data storage, column-oriented storage, and graph databases.

Open Source 81

Open Source Database Storage Scalability 81

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. err 2023-07-10T05:26:42.521994Z 0 [System] [MY-010910] [Server] /usr/bin/mysqld: Shutdown complete (mysqld 8.0.19-10) 10-Linux.x86_64.ssl101.tar.gz

Programming 89

Programming Servers Database Systems 89

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

C++ Database Storage Testing 84

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 85

Cloud Open Source Strategy Best Practices 85

Percona

JULY 17, 2023

1 among non-relational/document-based systems ( DB-Engines, July 2023 ). Instead of the table-based structure of relational databases, MongoDB stores data in documents and collections, a design for handling large amounts of unstructured data and for real-time web applications. It ranks No. Couchbase — No.

Open Source 80

Open Source Database Scalability Software 80

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

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 81

Availability Open Source Strategy Storage 81

Percona

APRIL 10, 2023

In March 2023, we discovered an issue with physical backups, which, under certain conditions, can cause the restore to fail ( PBM-1058 ). includes this fix and was released on March 23, 2023. With PBM v2.0.0, the ability to take physical backups , in addition to logical ones, has been made Generally Available. as a technical preview.

Open Source 82

Open Source Storage Availability Processing 82

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 83

Open Source Healthcare Social Media Database 83

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 87

Storage Database Performance Open Source 87

Percona

JULY 7, 2023

Where a high availability design once worked well, it can no longer keep up with more complex requirements. The majority of SPOFs are a consequence of scale, where designs that were once adequate (excellent, even) no longer meet evolving, more complex requirements. Can you afford that recovery time?

Availability 88

Availability Open Source Architecture Database 88

Percona

DECEMBER 1, 2023

References: Performing ETL Using Inheritance in PostgreSQL PostgreSQL Partitioning Using Traditional Methods 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.

Open Source 83

Open Source Storage Performance Design 83

Brendan Gregg

FEBRUARY 28, 2023

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. It was a great privilege. The call for participation ends on March 2nd 23:59 SGT!

Performance 52

Performance Latency Cache Virtualization 52

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 99

Open Source Database Strategy Hardware 99

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

Official Blog - World Web Technology

NOVEMBER 27, 2023

You may have to put off learning web development and design. You can make a great website without coding or advanced web design skills. Anyone can use a good website builder, even if they don’t know web design. It depends on the best practices of web design. Top 5 Website Builders to Choose in 2023!

Website 59

Website Development Mobile Storage 59

Percona

JULY 15, 2023

This blog was originally published in January 2022 and was updated in July 2023. As such, index design must strike a balance between improved query speed and efficient data modification. As such, index design should consider the size of indexed columns and the potential benefits they offer. What is an Index?

Virtualization 80

Virtualization Speed Database Efficiency 80

O'Reilly

JULY 25, 2023

Here’s how I worked on it: I subscribed to ChatGPT Plus and used the GPT-4 model in ChatGPT (first the May 12, 2023 version, then the May 24 version) to help me with design and implementation. I liked how ChatGPT helped me work through the tradeoffs of these initial design decisions before diving head-first into coding.

Programming 98

Programming Code Design Benchmarking 98

Percona

JULY 1, 2023

This post was originally published in July 2018 and was updated in July 2023. With its support for MySQL and PostgreSQL, and its automated replication and backup capabilities, it’s designed to deliver high performance, scalability, and availability to meet the needs of mission-critical applications.

AWS 52

AWS Database Serverless Storage 52