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 77

Monitoring Open Source Database Servers 77

The Netflix TechBlog

NOVEMBER 29, 2023

By June 2023 the entire HDR catalog was optimized. Bitrate versus quality comparison HDR-VMAF is designed to be format-agnostic — it measures the perceptual quality of HDR video signal regardless of its container format, for example, Dolby Vision or HDR10. 263–1–8 (2023) [ online ] [2] A. The graphic below (Fig. Choudhury, L.

Open Source 252

Open Source Software Engineering Internet Internet 252

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 215

Strategy Artificial Intelligence Storage Cloud 215

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 77

Open Source Servers AWS Database 77

Dynatrace

MAY 9, 2023

Dynatrace plans to grow to 100 Denver-based employees by the end of May 2023. Its design fosters collaboration and innovation, providing space for up to 400 software intelligence experts in Denver’s vibrant LoDo neighborhood. The new office provides an innovative design.

Transportation 189

Transportation Innovation Storage Design 189

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

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 120

AWS Storage Database Open Source 120

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 94

Database Open Source Storage Servers 94

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 153

Database Government Games Servers 153

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 87

Hardware C++ Storage Cache 87

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 263

Database Artificial Intelligence Metrics Monitoring 263

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 110

Performance Latency Cache Virtualization 110

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 101

Metrics C++ Storage Database 101

Percona

MARCH 28, 2023

Taking backup locally with multiple repos: In this example, we have tried to create two repositories in the local backup server itself, namely pgbackrest_repo1 and pgbackrest_repo2.

Servers 82

Servers Azure AWS Cloud 82

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

C++ Database Storage Testing 79

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 199

Open Source Social Media Infrastructure Operating System 199

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 75

Open Source Database Storage Scalability 75

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 84

Programming Servers Database Hardware 84

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 100

Storage Open Source Database Efficiency 100

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

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 75

Open Source Database Scalability Software 75

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 76

Availability Open Source Strategy Storage 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

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 77

Open Source Storage Availability Processing 77

Percona

AUGUST 29, 2023

In this case, the backups should be stored on some object storage. For example, my demo - cluster configuration in 04-deploy-cr.yaml looks like this if I want to take the backups to Google Cloud Storage (GCS): pgbackrest: global: - secret: name: demo-cluster-gcs. Please use our documentation to configure backups.

Storage 94

Storage Database Media Open Source 94

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 123

Traffic Scalability Database Servers 123

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

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 78

Open Source Healthcare Social Media Database 78

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 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 82

Storage Database Performance Open Source 82

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 179

Performance DevOps Innovation Artificial Intelligence 179

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 77

Open Source Storage Performance Design 77

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 83

Availability Open Source Architecture Database 83

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

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

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. If you don’t have well-designed and small columns for this composite primary key, it could enlarge all of your secondary indexes.

Strategy 40

Strategy Storage Database Best Practices 40

Testsigma

FEBRUARY 12, 2021

The implementation of emerging technologies has helped improve the process of software development, testing, design and deployment. The latest trend in hyperautomation – Gartner projects that by the year 2023, 25% of tasks by the organisations will be able to perform autonomously and hence reducing the cost. from $12.6

Artificial Intelligence 92

Artificial Intelligence Software Software IoT 92