Database Security – ITFROMZERO

Deploying PostgreSQL on Fedora Server: Securing with SELinux and Firewalld

By admin June 14, 2026

A guide to installing production-ready PostgreSQL on Fedora Server. Focuses on SELinux security, Firewalld configuration, and performance optimization tips from real-world experience.

MySQL

Configuring Transparent Data Encryption (TDE) in MySQL 8: Protecting Sensitive Data at the Storage Layer (At-Rest)

By admin June 13, 2026

TDE (Transparent Data Encryption) in MySQL 8 encrypts data at the storage layer, protecting .ibd tablespace files from being read directly — with no application code changes required. This guide walks through the full setup: installing the keyring component, encrypting tables and tablespaces, rotating the master key on a schedule, and verifying and monitoring real-world effectiveness.

Database

PostgreSQL Dynamic Data Masking: Stop Leaking Customer Data in Dev/Test

By admin May 31, 2026

Forget manual UPDATE scripts! Learn how to use postgresql_anonymizer to professionally and safely mask sensitive data in PostgreSQL for Dev/Test environments.

MySQL

Professional Database Monitoring with MySQL Audit Log Plugin

By admin May 19, 2026

A detailed guide on installing and optimizing the Percona MySQL Audit Log Plugin. This solution tracks all user actions, protects sensitive data, and meets security standards for production systems.

MySQL

MySQL SSL/TLS: Don’t Let Your Data Go “Naked” in Transit (mTLS Configuration Guide)

By admin May 9, 2026

Don't let your MySQL data be intercepted. Here is a detailed guide on configuring SSL/TLS and mTLS for maximum security between your application and database server.

Database

PostgreSQL Row Level Security (RLS): Securing Multi-tenant Data at the Core

By admin April 27, 2026

Learn how to configure PostgreSQL Row Level Security (RLS) for fine-grained data protection. An optimal solution for Multi-tenant/SaaS applications with real-world performance optimization tips.