5 Data
Every entry filed under Data and its subtopics.
10 entries match these filters
- 0070 Indexes and EXPLAIN: making SQL queries fast An index is a sorted lookup structure that lets the database jump to matching rows instead of reading the whole table. EXPLAIN… Advanced · Concept · Any system Article Indexes & performance 15 Oct 2026
- 0203 Physical backups and point-in-time recovery with pg_basebackup and WAL archiving A base backup plus a continuous archive of WAL files lets you restore a PostgreSQL cluster to any moment after the backup,… Advanced · Concept · Linux Article Backup & restore · Replication & high availability 15 Oct 2026
- 0205 Set up PostgreSQL streaming replication with a hot standby Step-by-step: prepare a primary, clone it with pg_basebackup, start a read-only standby that streams WAL, check it works, and understand promotion and… Advanced · How-to · Linux Article Replication & high availability 15 Oct 2026
- 0208 Check PostgreSQL replication lag with a monitoring script A bash check that detects whether it runs on a primary or a standby, measures replication lag in bytes and seconds, and… Advanced · How-to · Linux Script Replication & high availability 15 Oct 2026
- 0217 MySQL binary logs and point-in-time recovery The binary log records every change after your last backup. Restore the backup, then replay the binary log up to just before… Advanced · Concept · Linux Article Backup & restore · Replication 15 Oct 2026
- 0218 Setting up MySQL source-replica replication with GTIDs Step by step: configure a MySQL 8.4 source and replica with GTIDs, create the replication account, copy the data, connect the replica… Advanced · How-to · Linux Article Administration · Replication 15 Oct 2026
- 0224 RMAN backup basics: ARCHIVELOG mode, a nightly backup script and restore Enable ARCHIVELOG mode, set an RMAN retention policy, run a nightly full backup with archived logs from cron, and learn the restore… Advanced · How-to · Linux Script Administration · Backup with RMAN 15 Oct 2026
- 0239 Fix: (error) NOAUTH Authentication required. (and securing Redis with ACLs) Redis requires a login and your client sent a command without one. Pass the right user and password, and use the moment… Advanced · Fix · Linux Article Administration & persistence · Security & access 15 Oct 2026
- 0242 Database security checklist: access, encryption, exposure and patching A practical checklist for hardening any database server, with MongoDB and Redis examples: no public exposure, authentication, least privilege, TLS, protected backups,… Advanced · How-to · Linux Article Database operations · Security & access 15 Oct 2026
- 0258 Build a MySQL 8.4 source-replica pair with GTIDs and rehearse a manual failover Set up GTID replication between two MySQL 8.4 servers, provision the replica with the clone plugin, then stop the source, promote the… Advanced · Tutorial · Linux Article Administration · Replication 15 Oct 2026