I have a Apache Web Server running on Red Hat Linux 7.3 with MYSQL database installed. However, I have a pretty old machine.
I am planning for disater recovery and thinking of two options _
1) Adding another Hard Disk and using RAID 1 for fault tolerance and fast recovery
2) Using Backup of important filesystems including databases on to the Tape drive.
Actually, I am new to system admin and want to know about the instructions to be followed to achieve these objectives.
Secondly, how can I automate and schedule the process for taking database backups when the mysqld deamon is running ?
I am bit concerned about the system performance as data mirroring may effect the overall perforrmnce of the web server.