Percona

APRIL 24, 2023

Today’s post includes those releases and updates that have come out since April 10, 2023. 24 was released on April 18, 2023. Our free, open source, enterprise-grade solution includes the high availability and security features your business requires to meet your customer expectations and business goals. Take a look!

Open Source 76

Open Source Storage Servers Database 76

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

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

The Netflix TechBlog

NOVEMBER 29, 2023

HDR was launched at Netflix in 2016 and the number of titles available in HDR has been growing ever since. By June 2023 the entire HDR catalog was optimized. In spite of reaching higher qualities than the fixed ladder, the HDR-DO ladder, on average, occupies only 58% of the storage space compared to fixed-bitrate ladder.

Open Source 252

Open Source Software Engineering Internet Internet 252

Percona

JULY 7, 2023

With the average cost of unplanned downtime running from $300,000 to $500,000 per hour , businesses are increasingly using high availability (HA) technologies to maximize application uptime. Where a high availability design once worked well, it can no longer keep up with more complex requirements. there cannot be high availability.

Availability 82

Availability Open Source Architecture Database 82

Dynatrace

APRIL 19, 2023

During a Perform 2023 panel discussion, Dynatrace colleagues Donald Ferguson, principal product manager, and Michael Plank, senior product manager, addressed how the Dynatrace platform uses data security and data privacy by design to keep data safer than storing it anywhere else. .” Why perform exclusion at two points? Encryption.

Design 197

Design Storage Programming Analytics 197

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. Programs like Open Data on AWS provide free, publicly available datasets, accelerating sustainability innovation.

AWS 52

AWS Energy IoT Best Practices 52

Dynatrace

FEBRUARY 16, 2023

In his keynote address on the first day of Perform 2023 in Las Vegas, Dynatrace Chief Technology Officer Bernd Greifeneder and his colleagues discussed how organizations struggle with this problem and how Dynatrace is meeting the moment. Grail combines the big-data storage of a data warehouse with the analytical flexibility of a data lake.

Analytics 191

Analytics Innovation Metrics Database 191

Dynatrace

MAY 6, 2024

Problem remediation is too time-consuming According to the DevOps Automation Pulse Survey 2023 , on average, a software engineer takes nine hours to remediate a problem within a production application. This way, disruptions are minimized, MTTR is significantly decreased, and DevSecOps and SREs collaborate efficiently to boost productivity.

DevOps 290

DevOps Software Engineering Games Java 290

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. On June 6, 2023, the ransomware gang Cl0p claimed responsibility for exploiting the MOVEit Transfer vulnerability starting on May 27, 2023, during the U.S.

Database 163

Database Government Games Servers 163

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 118

AWS Storage Database Open Source 118

Percona

JUNE 29, 2023

There are other options available too when using commitQuorum: “Voting Members” – This is the default behavior when an index will be created on all data-bearing voting replica set members (Default). Below is the command used to create an index using commitQuorum as the majority : db.getSiblingDB("acme").products.createIndex({

Servers 78

Servers C++ Storage Best Practices 78

Percona

MARCH 28, 2023

33: Sun Mar 26 08:35:59 2022 (size 8 KB) file-size: 8 KB, checkpoint-size: 4 KB offset, size, checksum root : 8192, 4096, 3824871989 (0xe3faea35) alloc: 12288, 4096, 4074814944 (0xf2e0bde0) discard : 0, 0, 0 (0) available : 0, 0, 0 (0) WiredTigerCheckpoint.34: . $ wt list -c WiredTigerCheckpoint.33:

Hardware 85

Hardware C++ Storage Cache 85

Percona

MARCH 28, 2023

repo1-path=/var/lib/pgbackrest_repo1 --repo2-path=/var/lib/pgbackrest_repo2 If the first repo is unavailable and the second repo is available, then, in this case, the pgBackRest will continue copying/archiving the wal files to the second repo. The example below shows that the pgBackRest is archiving the wal files into two different repos.

Servers 80

Servers Azure AWS Cloud 80

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. available only for Atlas users) , that can not be modified anymore; That change was then introduced to 7.0. Without further ado, let’s get started. After the rapid release 6.2

Metrics 98

Metrics C++ Storage Database 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++ 77

C++ Database Storage Testing 77

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 100

Servers C++ Storage Systems 100

Dynatrace

MAY 8, 2023

In fact, the Dynatrace 2023 CIO Report found that 78% of respondents deploy software updates every 12 hours or less. Application performance monitoring Application performance monitoring tracks the availability and performance of applications in the field. 54% reported deploying updates every two hours or less.

DevOps 225

DevOps Efficiency Monitoring Infrastructure 225

Dynatrace

FEBRUARY 15, 2023

Additionally, its modern architecture delivers cost-effective storage and compute. As a result, teams benefit from low-cost cloud storage that provides access to all data and doesn’t require data rehydration.

Analytics 130

Analytics Storage Cloud Code 130

Percona

MARCH 30, 2023

In simple terms, an open source database is this: It’s a database with source code that is free and available to all. Further, open source databases can be modified in infinite ways, enabling institutions to meet their specific needs for data storage, retrieval, and processing. What is an open source database?

Open Source 73

Open Source Database Storage Scalability 73

Percona

JULY 17, 2023

1 among non-relational/document-based systems ( DB-Engines, July 2023 ). MongoDB replica sets enable data redundancy and automatic failover, setting the stage (there’s that term again) for high availability. For starters, MongoDB Community lacks the advanced security features available in MongoDB Enterprise. It ranks No.

Open Source 74

Open Source Database Scalability Software 74

Dynatrace

JUNE 1, 2023

According to the 2023 Dynatrace CIO Report , 78% of respondents deploy software updates every 12 hours or less. These organizations rely heavily on performance, availability, and user satisfaction to drive sales and retain customers. Availability is typically expressed in 9’s, such as 99.9%. or 99.99% availability.

Latency 182

Latency Website Traffic Virtualization 182

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 212

Open Source Social Media Infrastructure Operating System 212

Dynatrace

FEBRUARY 15, 2023

Data storage limitations Today’s traditional monitoring tools often involve a tradeoff between storing much of the available observability, security, and business data—which is costly—and determining which data to store upfront. Four factors limit the quality and trustworthiness of traditional approaches to cloud monitoring.

Analytics 130

Analytics Storage Cloud DevOps 130

Dynatrace

SEPTEMBER 8, 2023

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 type of insight enables you to proactively manage liquidity, ensure sufficient funds are available, and make informed decisions about resource allocation.

Database 274

Database Artificial Intelligence Metrics Monitoring 274

Percona

APRIL 10, 2023

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

Open Source 75

Open Source Storage Availability Processing 75

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 97

Storage Open Source Database Efficiency 97

Dynatrace

JUNE 1, 2023

According to the 2023 Dynatrace CIO Report , 78% of respondents deploy software updates every 12 hours or less. These organizations rely heavily on performance, availability, and user satisfaction to drive sales and retain customers. Availability is typically expressed in 9’s, such as 99.9%. or 99.99% availability.

Traffic 173

Traffic Latency Website Virtualization 173

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 77

Cloud Open Source Strategy Best Practices 77

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 78

Servers Processing Speed Open Source 78

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

Percona

SEPTEMBER 14, 2023

sec) percona labs > select * from herc; + -+ + + --+ | id | name | c_time | active | + -+ + + --+ | 1 | ab | 2023-08-19 01:28:32 | 1 | | 2 | cd | 2023-08-19 01:28:36 | 1 | | 3 | ef | 2023-08-19 01:28:39 | 1 | | 4 | gh | 2023-08-19 01:28:42 | 1 | | 5 | ij | 2023-08-19 01:28:45 | 1 | + -+ + + --+ 5 rows in set (0.00

Engineering 85

Engineering Database Servers Analytics 85

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. How-to documentation is readily available.

Open Source 76

Open Source Healthcare Social Media Database 76

Dynatrace

DECEMBER 18, 2023

According to the 2023 Kubernetes in the Wild report , 65% of organizations use Prometheus. But often, we use additional services and solutions within our environment for backups, storage, networking, and more. Our goal was to filter for metrics that deliver the data we need while minimizing storage costs.

Metrics 183

Metrics Engineering Energy Tuning 183

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. The C++ community has not done so. best effort” analysis).

C++ 139

C++ Programming Code Java 139

Percona

JUNE 6, 2023

This blog was originally published in January 2012 and was updated in June 2023. When it comes to backups, there are multiple types available, each with its own advantages and limitations. This results in smaller backup sets, reducing storage requirements, time to take the backup, and network usage, as compared to full backups.

Storage 67

Storage Strategy Network Efficiency 67

Percona

NOVEMBER 1, 2023

This blog was originally published in January 2021 and updated in November of 2023. As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. This adds more time when you need to restore a backup but it keeps your data safe.

Best Practices 78

Best Practices Storage Strategy Database 78