Sample Header Ad - 728x90

Is it good idea to use RAID 1 mirroring to back up database content

0 votes
2 answers
1163 views
I'm working on web hosting project. The planned system structure is going to be like this: - one main hard-drive will contain the binary of mysql. - A second hard-drive will contain the datadir - the third hard-drive should contain a backup of this mentioned datadir. I can only think of two options here either replication using 2 instances of MySQL servers or just using RAID 1 mirroring only the datadir. I would go with mirroring but I'm kind of suspicious of using this method and my main frightening thought is what if I lost the main hard-drive that contain the binary of mysql does setting new version will cause my a problem .. any ideas suggestions will be great full thanks I should mention that using INNODB is a constraint
Asked by Abdulla aleid (1 rep)
Feb 22, 2016, 01:41 PM
Last activity: May 6, 2020, 12:37 AM