BestHub
search
Sign in
Tag

mysql backup

0 views collected around this technical thread.

Practical DevOps Architecture
Practical DevOps Architecture
Oct 22, 2024 · Operations

Bash Scripts for Automatic DOS Attack Blocking and MySQL Database Backup

This article provides two Bash scripts: one that automatically detects and blocks IP addresses generating excessive requests to an Nginx server using iptables, and another that backs up all non‑system MySQL databases with timestamped filenames, both designed for easy server operation and maintenance.

automationbashdos attack
0 likes · 3 min read
Bash Scripts for Automatic DOS Attack Blocking and MySQL Database Backup
Practical DevOps Architecture
Practical DevOps Architecture
Dec 24, 2020 · Databases

Installing Percona XtraBackup and Performing Full and Incremental Backups on CentOS

This guide walks through downloading and installing Percona XtraBackup on a CentOS server, then demonstrates how to create full backups, remove timestamps, inspect backup contents, and execute incremental backups with detailed command examples and explanations.

CentOSDatabaseIncremental backup
0 likes · 5 min read
Installing Percona XtraBackup and Performing Full and Incremental Backups on CentOS
Practical DevOps Architecture
Practical DevOps Architecture
Dec 2, 2016 · Operations

Best Practices for Writing Safe Shell Scripts for MySQL Backup

This article explains how to make robust MySQL backup shell scripts by adding logging, usage instructions, file locking, and proper comments to avoid rogue behavior and ensure reliable operation.

file-lockingloggingmysql backup
0 likes · 5 min read
Best Practices for Writing Safe Shell Scripts for MySQL Backup