Database Storage?

[scalebase]

Why it is important to store your database in multiple locations? and how it can be achieved in the easiest and reliable manner.

[PeejAvery]

Multiple locations are used for secure data retention. If something happens to one, then you at least have another copy.

[scalebase]

Ok, but how we can achieve this in easiest way as I think storing data in multiple locations is not an easy process and might also depends on the size of database.

[PeejAvery]

I think you're misunderstanding the implementation. You don't read from/write to both at the same time. You have an active database and one backup. At given increments you backup the active database to another location. It's basically a simple copy procedure.

[scalebase]

Thanks, PeejAvery for clarifying my doubts as now I got it.