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 74

Open Source Servers AWS Database 74

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 79

Servers Azure AWS Cloud 79

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. The problem with the IIS server access logs was the headers.

Database 159

Database Government Games Servers 159

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 89

Database Open Source Storage Servers 89

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 117

AWS Storage Database Open Source 117

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 82

Programming Servers Database Hardware 82

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

Dynatrace

SEPTEMBER 8, 2023

SQL Username: Username of the user who has permission to login on the SQL server remotely and access the database. To achieve this, we’ll create a Grail bucket specifically designed to retain data for a duration of 10 years (3,657 days). Configuration details Database configuration Endpoint name: Any label to identify this connection.

Database 270

Database Artificial Intelligence Metrics Monitoring 270

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 73

Open Source Database Scalability Software 73

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

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 96

Metrics C++ Storage Database 96

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

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

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

Percona

JULY 7, 2023

Where a high availability design once worked well, it can no longer keep up with more complex requirements. In general terms, to achieve HA in PostgreSQL, there must be: Redundancy: To ensure data redundancy and provide continuous performance when a primary server fails, multiple copies of the database reside in replica servers.

Availability 81

Availability Open Source Architecture Database 81

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

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

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

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 75

Open Source Storage Availability Processing 75

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

JULY 3, 2023

However, a rule of thumb is that the size of the table should exceed the physical memory of the database server. The exact point at which a table will benefit from partitioning depends on the application.

Storage 80

Storage Database Performance Open Source 80

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

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

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. These issues often arise from suboptimal query design, missing or ineffective indexes, or dealing with large datasets.

Tuning 52

Tuning Database Performance Hardware 52

Percona

JULY 2, 2023

This blog was originally written in September 2018 and was updated in June 2023. Having a backup strategy in place that takes regular backups and has secure storage is essential to protect the database in an enterprise-grade environment to ensure its availability in the event of failures or disasters.

Strategy 52

Strategy Database Storage Open Source 52

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. To address these challenges, architects must design robust and scalable MongoDB databases and adopt appropriate sharding strategies that can efficiently handle increasing workloads while ensuring continuous availability. What is sharding in MongoDB?

Best Practices 69

Best Practices Traffic Database Servers 69

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

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 88

Open Source Database Hardware Strategy 88

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

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 75

Virtualization Speed Database Efficiency 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. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload.

Tuning 52

Tuning Efficiency Database Performance 52

Speed Curve

FEBRUARY 25, 2024

Heatmap of the most popular pages and their Web Vitals metrics I then typically switch to the RUM > Design dashboard and use the list of popular interaction elements to determine which ones I want to investigate further. Guest profiles also start with empty caches, empty cookie stores, empty browser storage, etc.

Analytics 91

Analytics Processing Google Mobile 91

Enprowess

JANUARY 12, 2022

Offers Easy Navigation & Seamless User Experience: Single page app has a simple design, and it delivers an experience like a desktop or mobile app. Other benefits: It has other benefits like a Quicker launch to the market, Easier distribution, saving device power and storage, seamless maintenance, and updating. Dark Mode.

Blockchain 59

Blockchain IoT Development Serverless 59

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