Percona

SEPTEMBER 25, 2023

pgBackRest is a highly efficient and versatile tool for managing PostgreSQL backups. 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. This way, they won’t interfere with each other, enabling efficient parallel execution.

Database 97

Database Open Source Storage Servers 97

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 266

Database Artificial Intelligence Metrics Monitoring 266

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!) However, I find zstd way more efficient, so I’ll use it in the examples.

AWS 122

AWS Storage Database Open Source 122

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

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 203

Open Source Social Media Infrastructure Operating System 203

Dynatrace

JANUARY 23, 2024

AI-enabled chatbots can help service teams triage customer issues more efficiently. Deriving business value with AI, IT automation, and data reliability When it comes to increasing business efficiency, boosting productivity, and speeding innovation, artificial intelligence takes center stage. What is explainable AI?

Performance 182

Performance DevOps Innovation Artificial Intelligence 182

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 82

Cloud Open Source Strategy Best Practices 82

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

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 102

Storage Open Source Database Efficiency 102

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 77

Open Source Database Storage Scalability 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 97

Storage Database Media Open Source 97

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 125

Traffic Scalability Database Servers 125

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 80

Open Source Healthcare Social Media Database 80

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

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database. A finely tuned database processes queries more efficiently, leading to swifter results.

Tuning 52

Tuning Database Performance Hardware 52

Percona

SEPTEMBER 1, 2023

This blog was originally published in February 2019 and was updated in September 2023. Character encoding refers to the method used to represent characters as binary data for storage and transmission. The choice of character set and encoding impacts not only efficiency but also how the data appears to users.

Performance 52

Performance Storage Social Media Database 52

Percona

JULY 3, 2023

Hash keys are used effectively and efficiently in cases where ranges are not applicable, like employee number, product ID, etc. What if the data is out of range or list? For this purpose, we use default partitions on range and list partitioned tables.

Storage 84

Storage Database Performance Open Source 84

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. Introduction to MySQL Indexes Indexes in MySQL are database structures used to optimize data retrieval speed and efficiency. As such, index design must strike a balance between improved query speed and efficient data modification.

Virtualization 78

Virtualization Speed Database Efficiency 78

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 94

Open Source Database Hardware Strategy 94

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

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.

Artificial Intelligence 92

Artificial Intelligence Software Software IoT 92

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.

Best Practices 73

Best Practices Traffic Database Servers 73

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

Open Source 52

Open Source Servers Storage Scalability 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 92

Analytics Processing Google Mobile 92

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