5 Data
Every entry filed under Data and its subtopics.
What kind of help
Works on
What do these mean?
- Beginner
- You are new to this topic.
- Intermediate
- You use it, and want to get better.
- Advanced
- You know it well and need the details.
- Guided project
- Build something small from start to finish, step by step.
- Explains an idea
- Plain words on how something works and why.
- Step by step
- Numbered steps to get one task done.
- Cheat sheet
- Commands and options in a table, to look up fast.
- Fixes an error
- An error message, what it means, and how to solve it.
8 entries match these filters
- 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 · Fixes an error · 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 · Step by step · 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 · Guided project · Linux Article Administration · Replication 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 · Explains an idea · 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 · Step by step · Linux Article 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 · Explains an idea · 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 · Step by step · Linux Article Administration · Replication 15 Oct 2026
- 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 · Explains an idea · Any system Article Indexes & performance 15 Oct 2026