Freaks City

Creating Backup Directories Begin by establishing a dedicated directory for backups: mkdir -p /home/apps/backup/mysqllive Securing Database Credentials For enhanced security, store database credentials in a configuration file instead of embedding them in scripts. Create and edit the MySQL dump configuration file: sudo vim /etc/mysql/conf.d/mys ...

Traditional MySQL backup utilities like mysqldump operate using a single-threaded model, processing tables sequentially. This limitation often results in extended backup windows for large datasets. To address this, mydumper was developed as a multi-threaded logical backup tool. It allows for concurrent data extraction from tables and simultaneo ...

Prerequisites Before installing Confluence, ensure the following components are ready on your server: Java Development Kit (JDK) 8 or later MySQL 5.7+ or another supported database JDK Setup # Extract JDK archive to /opt/java cd /opt tar xzf jdk-8u231-linux-x64.tar.gz # Set environment variables in /etc/profile export JAVA_HOME=/opt/java/jdk ...

Automtaed GitLab Backups Using Cron To automate GitLab backups, you can use cron jobs to execute backup scripts at scheduled intervals. Schedule a Daily Backup Edit the crontab file: crontab -e Add the following line to run a backup script daily at 2 AM: 0 2 * * * /opt/scripts/gitlab_backup.sh Backup Script Content The script should include c ...

Installation Dependencies dnf install -y cmake gcc gcc-c++ git make Downloading and Installing MyDumper wget https://github.com/mydumper/mydumper/releases/download/v0.14.1-1/mydumper-0.14.1-1.el9.x86_64.rpm dnf install mydumper-0.14.1-1.el9.x86_64.rpm -y MyDumper Configuration Options mydumper --help Displays comprehensive options for con ...

Overview of RMAN RMAN (Recovery Manager) performs physical backups and supports point-in-time recovery. It operates in two database modes: Archivelog mode: Allows both offfline (cold) and online (hot) backups. Noarchivelog mode: Only offline backups are permitted. Using RMAN Connect to the target database from the server: rman target / # or w ...

Backup Tools The mysqldump utility can be used on both the client and server sides. The SELECT INTO OUTFILE command is limited to writing data directly to the server side. Backup by Table a. Backing up a single table mysqldump -uusername -p database table1 >tableback.sql mysql> select * into outfile 'D:/someBookes/mysql/pracitce/mysql_ ...

Configuring Backup Repository Navigate to the elasticsearch-6.2.2\config directory and modify the elasticsearch.yml configuration file. Add the following line at the end to specify the backup storage path: path.repo: ["D:/backup_storage/elastic_backup"] Create the designated folder at the specified location if it doesn't exist. Crea ...

Mastering Rsync for Efficient Data Synchronization Introduction to Rsync Rsync is a powerful open-source utility designed for rapid, versatile file synchronization between systems. It excels at performing both full and incremental data transfers across local and remote systems, supporting multiple platforms including Unix, Linux, and Windows. ...

Easysearch includes native support for S3 storage, enabling users to create and restore snapshots directly to Amazon S3-compatible services without installing external plugins. This integration streamlines the backup and migration workflow for data managed within the cluster. Prerequisite: Object Storage Setup A compatible S3 service is require ...