It is important to back up your data in case of an accident

Solution

let us consider the first case word press blog that gets 100 visitors a day. the content of the blog is usually stored in the database. whenever the request is made by the user to the server, the server retrieves the data from the database and displays it to the user.As the blog is read only(ie we can comment but we cannot modify the content) a master-slave system is preferred here. master dedicated to write access where the blogger can write the content to his blog. slave provides the read access to the users. Thre 100 users can only read the content and comment it. The master here can be backed up everyday ie daily backup can be applied to this scenario for week days and continue with weekly backup. Now let us consider there is a crash in the master system which created a loss.A slave system which is a replica of master can be made as master with some modifications in the permissions. If a slave fails then it is easy to construct another slave system from the master. If both fails then a master is constructed with the last backed up system and copy master to slave.

Note: there is some loss of data in any case. how much loss, depends on the importance of the data.