Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Despite all its upside, PostgreSQL software presents such challenges. PostgreSQL software supports synchronous streaming replication, asynchronous streaming replication, and logical replication.

Availability 88

Availability Open Source Architecture Database 88

Percona

AUGUST 30, 2018

This is helpful, for example, if you are considering to move some of the tables to a different server and want to clearly understand how your workload will be impacted. You can see in this case it happens to match the IO activity graph, with storage taking more time to serve write requests versus read requests.

Benchmarking 49

Benchmarking Database Operating System Architecture 49

SQL Server According to Bob

JANUARY 11, 2020

This White Paper is for informational purposes only. Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication.

Servers 40

Servers Cache Database Media 40

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This White Paper is for informational purposes only.

Servers 40

Servers Cache Media Hardware 40

All Things Distributed

AUGUST 16, 2012

An apples to apples comparison of the costs associated with running various usage patterns on-premises and with AWS requires more than a simple comparison of hardware expense versus always-on utility pricing for compute and storage. This option offers 68% savings over the on-premises option.

AWS 118

AWS Hardware Traffic Best Practices 118

Percona

APRIL 17, 2023

It is common to see a value of “ 0″ ( or sometimes “10” ) on database servers, telling the kernel to prefer to swap to memory for better response times. 20-30% is a good general default for “dirty_ratio,” but on large-memory database servers, this can be a lot of memory.

Best Practices 52

Best Practices Design Tuning Database 52

Sutter's Mill

MARCH 11, 2024

To talk about C++’s current safety problems and solutions well, I need to include the context of the broad landscape of security and safety threats facing all software. Software security ” (or “cybersecurity” or similar) means making software able to protect its assets from a malicious attacker.

C++ 139

C++ Programming Code Java 139