1 views collected around this technical thread.
This article provides a step‑by‑step tutorial for DBAs to design a reliable MySQL backup strategy, write a Bash automation script, schedule it with cron, and perform restoration drills using Docker containers, while covering directory planning, command checks, cleanup, and common troubleshooting.
This guide explains how to set up an automated MySQL backup solution on AlmaLinux using Docker containers, a Bash script, and crontab, covering environment preparation, script creation, command checks, logging, error handling, and optional enhancements such as email notifications and security best practices.
This article explains how Java developers can replace thousands of individual UPDATE statements with a single PostgreSQL stored procedure call, covering the motivation, procedure creation, Java invocation, scheduling with shell scripts, performance benchmarks, and common pitfalls.
This guide explains how to access Android SQLite databases via adb shell sqlite3, create and run complex shell scripts, and manage app permissions and users through ADB commands, providing practical examples for debugging and automation.
This article introduces a comprehensive set of shell scripts that automate system initialization across dozens of Linux distributions, detailing supported features, version‑specific updates, usage instructions, and code examples for network, security, package management, and more.
This article explains how to run a Shell script within a Jenkins pipeline, capture its output, and present it through the Input step as a multi‑line text field for approval, illustrating the process with complete pipeline examples.
This guide explains how to use mysqldump to back up a single MySQL database, multiple databases, or all databases, includes options for specific tables, compression with gzip, adding drop statements, exporting only schema, and provides restore procedures and a sample automated backup script.
This article explains how to configure Maven profiles for different environments, use the maven‑assembly‑plugin and maven‑jar‑plugin to create a zip deployment package for a Spring Boot application, and provides a reusable shell script (shenniu_publish.sh) for extracting, starting, stopping, and restarting the service on Linux.
This guide walks through why nginx logs need daily rotation, demonstrates manual log splitting, provides a complete shell script for automated daily log rotation, explains logrotate configuration, and shows how to test and schedule the process with cron, ensuring clean and manageable log files.
This guide explains how to use the Linux md5sum command to generate checksums, compare files, store checksum data, and employ verification options like -c, --quiet, and --status for reliable file integrity checks in scripts and system operations.
This article explains how to package a Spring Boot application using Maven profiles and the assembly plugin, generate a zip deployment bundle, and deploy it on Linux with a custom shell script that supports start, stop, restart, and unzip operations.
This article provides step-by-step Bash scripts for automating daily MySQL database backups, compressing tables, cleaning old archives, and configuring master‑master replication, including detailed commands for dumping databases, creating tar.gz packages, and setting up replication parameters on Linux servers.
This guide provides Bash scripts that let you retrieve detailed information about Linux processes by PID or name, query user account details, and apply a series of system hardening tweaks such as password policies, login restrictions, and file attribute protections.
This article walks through a real‑world incident where a data‑platform server showed near‑100% CPU usage, explains step‑by‑step investigation using top, pwdx, and jstack, identifies a time‑conversion utility as the root cause, and presents a streamlined script‑based solution that reduced CPU load by thirtyfold.
This guide explains how to create a shell script that checks SSL certificate expiration dates and integrates it with Zabbix by configuring a user parameter, testing the script, and setting up monitoring items, triggers, graphs, and alerts to ensure services remain available.
This article explains how to configure Husky Git hooks, especially pre‑commit and commit‑msg, to run custom shell scripts for code style checks, unit tests, and commit‑message validation, and shows how to reuse these scripts in CI pipelines for consistent code quality.
This article explains how to identify and extract large MySQL transactions from binary log files by monitoring binlog size, parsing GTID information, and using shell scripts to retrieve transaction details, timestamps, positions, and DML statistics, with optional use of the my2sql tool.
This article explains how to use Maven profiles and the Maven Assembly Plugin to create environment‑specific Spring Boot zip packages and provides a reusable shell script (shenniu_publish.sh) for extracting, starting, stopping, and restarting the packaged JAR on Linux, improving deployment efficiency.
This guide explains how to install lm_sensors, write a Bash script to retrieve CPU temperature, configure a Zabbix agent UserParameter, restart the agent, and set up a corresponding monitoring item on the Zabbix server, enabling automated CPU temperature monitoring.
This article explains how to migrate a 240 GB MongoDB replica set by performing a full backup with oplog, extracting the incremental oplog timestamp, and then applying incremental backup and restore scripts to minimize downtime, while providing detailed shell commands and precautionary tips.