Intermediate
142 entries match these filters
- 0216 MySQL vs MariaDB: what actually differs MariaDB started as a fork of MySQL and still speaks the same client protocol, but GTIDs, JSON storage, authentication and tooling have… Intermediate · Explains an idea · Linux Article Choosing a database · MySQL & MariaDB 15 Oct 2026
- 0219 mysqldump nightly backup with rotation (bash) A cron-ready bash script that dumps each MySQL or MariaDB database to its own compressed file with --single-transaction, verifies it and deletes… Intermediate · Step by step · Linux Script Administration · Backup & restore 15 Oct 2026
- 0222 Connecting to Oracle: SQL*Plus, SQLcl, EZConnect, tnsnames.ora and the listener Clients reach an Oracle database through the listener, using an Easy Connect string or a tnsnames.ora alias. Here are the formats, the… Intermediate · Cheat sheet · Linux, macOS, Windows Article Administration · Concepts & tools 15 Oct 2026
- 0185 Ansible ad-hoc commands cheat sheet One-line ansible commands for quick jobs across many servers: ping hosts, run a command, copy files, manage packages, users and services, gather… Intermediate · Cheat sheet · Linux, macOS Article Ansible 15 Oct 2026
- 0186 Fix: Ansible UNREACHABLE! Failed to connect to the host via ssh Ansible could not open an SSH session to the host, so no task ran. The text after the colon tells you why:… Intermediate · Fixes an error · Linux, macOS Article Ansible · SSH & servers 15 Oct 2026
- 0188 First Terraform configuration: variables, a module and outputs (no cloud needed) A complete Terraform project that writes local files with the hashicorp/local provider, so you can practice init, plan, apply, modules and destroy… Intermediate · Step by step · Any system Script Terraform 15 Oct 2026
- 0191 Prometheus concepts: pull model, exporters, node_exporter and PromQL basics Prometheus scrapes numeric metrics from your systems over HTTP and stores them as time series. Learn the pull model, metric types, node_exporter,… Intermediate · Explains an idea · Linux Article Prometheus & Grafana 15 Oct 2026
- 0192 Grafana basics: connect Prometheus, build a dashboard and set up an alert Connect Grafana to Prometheus, build a dashboard for your servers with PromQL panels and a host selector, and create an alert rule… Intermediate · Step by step · Linux Article Prometheus & Grafana 15 Oct 2026
- 0193 Linux logs reference: journalctl, journald storage, logrotate and centralized logging Read and filter systemd journal logs, keep their disk use in check, rotate classic log files with logrotate, and understand when to… Intermediate · Cheat sheet · Linux Article Linux administration · Logs 15 Oct 2026
- 0200 PostgreSQL roles, privileges and default privileges Create login and group roles, grant access to databases, schemas and tables, and use ALTER DEFAULT PRIVILEGES so tables created later get… Intermediate · Step by step · Linux Article Roles & administration · Security & access 15 Oct 2026