Percona

JULY 7, 2023

HA in PostgreSQL databases delivers virtually continuous availability, fault tolerance, and disaster recovery. 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. there cannot be high availability.

Availability 88

Availability Open Source Architecture Database 88

Percona

AUGUST 15, 2023

It’s a rather new plugin build for virtual synchronous replication. wsrep patches / Galera Library This solution is virtually synchronous, which is comparable to Group Replication. Remember that semi-synchronous replication impacts performance because it needs to wait for the round trip of the actual ACK from the replica.

Servers 52

Servers Database Availability Traffic 52

Adrian Cockcroft

NOVEMBER 13, 2023

In the simplest case, you have a growing workload, and you optimize it to run more efficiently so that you don’t need to buy or rent additional hardware, so your carbon footprint stays the same, but the carbon per transaction or operation is going down.

Energy 52

Energy Cloud Traffic Transportation 52

Percona

APRIL 17, 2023

Operating System (OS) settings Swappiness Swappiness is a Linux kernel setting that influences the behavior of the Virtual Memory manager when it needs to allocate a swap, ranging from 0-100. Without further ado, let’s start with the OS settings. A setting of 100 determines it to swap aggressively to disk.

Best Practices 52

Best Practices Design Tuning Database 52

SQL Server According to Bob

JANUARY 11, 2020

This White Paper is for informational purposes only. Example 1: ​​ Hardware failure (CPU board) Battery backup on the caching controller maintained the data. Important Always consult with your hardware manufacturer for proper stable media strategies.

Servers 40

Servers Cache Media Hardware 40

Adrian Cockcroft

JUNE 21, 2022

I became the Sun UK local specialist in performance and hardware, and as Sun transitioned from a desktop workstation company to sell high end multiprocessor servers I was helping customers find and fix scalability problems. We had specializations in hardware, operating systems, databases, graphics, etc.

Tuning 52

Tuning Benchmarking Engineering C++ 52

SQL Server According to Bob

JANUARY 11, 2020

This White Paper is for informational purposes only. For ​​ more information about ​​ I/O ​​ caching requirements ​​ and SQL Server, see the following ​​ white papers on MSDN. scid=kb ; en-us;828339 ) on the Microsoft Web site.

Servers 40

Servers Cache Database Media 40