TLS Certificate is important to keep MySQL replication running over SSL connection. We should check and update TLS certificate when it gets any corruption due to any reason. When TLS Certificate changes for a any reason, MySQL replication will stop when you reboot Master server as the certificate changes take effect after the rebooting process. …
Why it is Important to Run a Backup on Ubuntu? You will never feel the importance of the backup on Ubuntu unless you lose important content. Do you know that before developing our exclusive method to create a robust backup on Ubuntu, we lost an important data by mistake! Therefore, we learned a lesson not …
WinSCP is a free and open-source Microsoft Windows tool that transfers files between Ubuntu server and local computer via SSH file transfer protocol a. Download and Install WinSCP (8 steps) b. Create Ubuntu WinSCP User (4 steps) Ignore Permission Errors c. Save Remote and Local Sessions (6 steps) Run WinSCP Sync Between Ubuntu and PC It’s highly …
You might need to add new database while the replication is running. This can be done easily but you need to follow the right sequence in order to avoid inconsistency. If you haven’t created MySQL Master Slave Replication system yet, you should follow our super easy article to create it quickly here: MySQL Master Slave …
We will show you here how to restore MySQL on the destination server easily from the backup that we synced via Rsync and iNotifyWait utilities by running a simple bash script. a. Create Restore Script b. Restore All MySQL Databases via restore_db.sh Bash Script c. Single Database Restoration via restore_db.sh Bash Script d. Single Database …
With MySQL master slave replication, we will sync the database between the source and destination servers in real time. We will have master (source) and slave (destination). The backup will move in one direction from the master to the slave. a. Configure Master (8 steps) List All Databases Open 50-server.cnf File Enable Binary Log and …
iNotifyWait will sync the folders between two servers in real time. We will create an iNotifyWait bash scripts on the source server to check for any changes on the synced folders to send the change to the destination server. That is to say, iNotifyWait will perform a real time sync on the synced folders. 1. …
We need to get a Linux backup server (destination server) to run the backup process flawlessly. For this purpose, we recommend Digital Ocean as a great Linux backup server provider which offers robust service and a SUPER DEAL! $100 FREE Credit if you join via this link: $100 Free Credit For the backup server, we …
Before starting the backup process between two servers via Rsync utility, we need to create a unique Linux user for the Rsync utility for security purposes. Sync Backup Directory Between Source and Destination Servers 1. [Destination server] We need to create a unique Linux user for Rsync utility on the destination server, run the below …
We will generate zipped backup files to backup MySQL database and site files for every website by running a simple Bash script. In order to backup MySQL and site files for any website, we need to create a Bash script to do all these tasks. In this article, we will show you how to do …
