0 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 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 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.
This article explains how to use Maven profiles and the maven‑assembly‑plugin to create a zip package for a Spring Boot application, and provides a reusable shell script (shenniu_publish.sh) for deploying, starting, stopping, and managing the service on Linux.
This article explains how to use Shell scripts together with Excel VLOOKUP to extract OceanBase cluster Parameters, Variables, and ProxyConfig values, compare them against default or DBA‑tuned settings, and generate a report that highlights unexpected configurations for manual verification.
The article details how a midnight interface timeout in Vivo’s e‑commerce activity system was traced to a logging bottleneck: a synchronous Log4j call blocked all threads while a cron‑driven log‑rotation script copied a 2.6 GB file, and the issue was resolved by switching to asynchronous logging with a non‑blocking appender.