Percona

AUGUST 15, 2023

In this blog post, I provide an in-depth introduction to MySQL Replication, answering what it is, how it works , its benefits and challenges, as well as reviewing some of the MySQL replication concepts that are part of the MySQL environment (and Percona Server for MySQL specifically). Set the server-id to a unique value.

Servers 52

Servers Database Availability Traffic 52

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

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. 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

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

Sutter's Mill

MARCH 11, 2024

The main improvement MSLs give is that a program data race will not corrupt the language’s own virtual machine (whereas in C++ a data race is currently all-bets-are-off undefined behavior). Kubernetes Secrets on public GitHub repos), misconfigured servers (e.g., I think that makes it a valuable strategy to pursue.

C++ 143

C++ Programming Code Java 143