Percona

DECEMBER 27, 2022

Encrypting data at rest in a database management system (DBMS) refers to securing data by encrypting it when it is not being used or accessed. Several database management systems support cluster-level encryption, including Oracle, MySQL, Microsoft SQL Server, MongoDB, and Cassandra. Database-level encryption. Table-level encryption.

Database 93

Database Storage Servers Strategy 93

Percona

AUGUST 29, 2018

For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. PostgreSQL uses System V (SysV) that requires SHMMAX setting. So now it requires fewer bytes of System V shared memory. DETAIL: Failed system call was shmget(key=1, size=2072576, 03600). Until version 9.2,

Tuning 55

Tuning Database Servers Processing 55

Brendan Gregg

AUGUST 18, 2019

BPF has been extended (aka eBPF) in recent years for providing a safe way to extend kernel functionality, and has become a hot topic in systems engineering, with at least 24 talks on BPF at the last Linux Plumber's conference. hardware Hardware counter-based instrumentation. system(".") BEGIN Start of bpftrace.

Latency 68

Latency C++ Cache Programming 68

Percona

AUGUST 29, 2023

Depending on the configuration, one can tune a hardware RAID for either performance or redundancy. Can you think of a better system that can stay up without losing time initiating failovers when a node fails? Now let’s stretch our imagination and consider a second method of high availability, ala Citus. citus_columnar | 11.1-1

C++ 79

C++ Database Storage Testing 79

SQL Server According to Bob

JANUARY 11, 2020

​​ Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Servers 40

Servers Cache Database Media 40