Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. Key areas include: Configuration parameter tuning : This tuning involves altering variables such as memory allocation, disk I/O settings, and concurrent connections based on specific hardware and requirements.

Tuning 52

Tuning Efficiency Database Performance 52

KeyCDN

FEBRUARY 22, 2023

Here is a roundup of frontend web development trends to keep an eye on in 2023. The goal of WebAssembly is to execute at native speeds by taking advantage of common hardware features available on a variety of platforms. Staying on top of the latest web development trends could eventually help you land a job that doesn't exist yet.

Artificial Intelligence 111

Artificial Intelligence Development Serverless Website 111

Percona

MARCH 28, 2023

” This acts as a step to ensure durability by recovering lost data from the same journal files in case of crashes, power, and hardware failures between the checkpoints (see below) Here’s what the process looks like. So, what happens when there’s an unexpected crash or hardware failure?

Hardware 84

Hardware C++ Storage Cache 84

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 18, 2023

The original motivation for FB was due to different hardware generations, especially between regions/data centers. 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. AFAIK Facebook does this.

Programming 82

Programming Servers Database Hardware 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++ 77

C++ Database Storage Testing 77

Percona

NOVEMBER 1, 2023

This blog was originally published in January 2021 and updated in November of 2023. MySQL backups play a pivotal role in safeguarding the integrity of your data, providing defense against various unforeseen calamities, hardware malfunctions, data loss, corruption, and inadvertent deletions. Why Do MySQL Backups Matter?

Best Practices 77

Best Practices Storage Strategy Database 77

Percona

JULY 1, 2023

This post was originally published in July 2018 and was updated in July 2023. Understanding DBaaS DBaaS cloud services allow users to use databases without configuring physical hardware and infrastructure or installing software. What are the differences between Aurora and RDS? How do I choose which one to use?

AWS 52

AWS Database Serverless Storage 52

Percona

JULY 7, 2023

Also, in general terms, a high availability PostgreSQL solution must cover four key areas: Infrastructure: This is the physical or virtual hardware database systems rely on to run. Can you afford the necessary hardware, software, and operational costs of maintaining a PostgreSQL HA solution? there cannot be high availability.

Availability 81

Availability Open Source Architecture Database 81

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 October 2017 and was updated in September 2023. Vertical scaling is also often discussed, which involves increasing the resources of a single server, which can have limitations in hardware capabilities and become costly as demands grow. An example is running MongoDB on Mesos.

Best Practices 69

Best Practices Traffic Database Servers 69