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

Dynatrace

JUNE 1, 2023

According to the 2023 Dynatrace CIO Report , 78% of respondents deploy software updates every 12 hours or less. Response time Response time refers to the total time it takes for a system to process a request or complete an operation. or above for the checkout process. Latency primarily focuses on the time spent in transit.

Traffic 173

Traffic Latency Website Virtualization 173

Dynatrace

JANUARY 23, 2024

The following resources provide more information on how to get the most out of your AI investment, the importance of data quality for business success, and automating manual IT processes to prioritize innovation. Teams face siloed processes and toolsets, vast volumes of data, and redundant manual tasks.

Performance 182

Performance DevOps Innovation Artificial Intelligence 182

Percona

JUNE 6, 2023

This blog was originally published in January 2012 and was updated in June 2023. In order to implement effective full backups of your database, you must follow some best practices. This results in smaller backup sets, reducing storage requirements, time to take the backup, and network usage, as compared to full backups.

Storage 68

Storage Strategy Network Efficiency 68

Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. A finely tuned database processes queries more efficiently, leading to swifter results. Inefficient query design, such as utilizing SELECT * instead of specifying necessary columns, can escalate data transfer and processing overhead.

Tuning 52

Tuning Database Performance Hardware 52

Percona

OCTOBER 18, 2023

It’s a complex process involving various factors and meticulous planning. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier. Look closely at your current infrastructure (hardware, storage, networks, etc.)

Open Source 91

Open Source Database Hardware Strategy 91

Percona

MAY 15, 2023

In both cases, when using virtually-synchronous replication, the process will require certification from each node and local (by node) write; as such, the number of writes is NOT distributed across multiple nodes but duplicated. Because the solutions still rely on writing in one single node that works as Primary.

Traffic 123

Traffic Scalability Database Servers 123

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

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. This method distributes data evenly across partitions to achieve balanced storage and optimal query performance.

Strategy 40

Strategy Storage Database Best Practices 40

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. This conversion ensures that the data appears correctly to users and can be processed and displayed as intended.

Performance 52

Performance Storage Social Media Database 52

Official Blog - World Web Technology

NOVEMBER 27, 2023

It depends on the best practices of web design. Choice and Range of Themes Using the premade templates a website builder provides is the first step in the design process. A drag-and-drop interface, as previously noted, simplifies the process. Top 5 Website Builders to Choose in 2023!

Website 59

Website Development Mobile Storage 59

Percona

JULY 7, 2023

Backup and continuous archiving: PostgreSQL asynchronous replication relies on the write-ahead log (WAL) stream, and it’s vital to have centralized storage that all nodes can access. PostgreSQL ranks as the fourth most popular database management system ( DB-Engines, March 2023 ).

Availability 83

Availability Open Source Architecture Database 83

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. The checkpoint process flushes the data into the data files. What is PostgreSQL performance tuning?

Tuning 52

Tuning Efficiency Database Performance 52

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. And since this setup process was so new to me, I had a hard time thinking about how to phrase my questions.

Programming 98

Programming Code Design Benchmarking 98