Re: retrieving data

First and foremost you should consider using mirrored disks. Currently inexpensive solutions are available in off-the-shelf motherboards that provide RAID at the hardware level. This will help you if and when there is a disk crash. You can also look at Linux DRBD white-paper from MySQL where disk blocks are replicated between networked nodes.

Beyond data loss, consider a scheduled backup or archive as a next step.

If you need scalability, you should look at MySQL replication ("scale-out") solutions.

HTH,
Darpan

calypso wrote:
> Hi all,
>
> I run a travel-agency, where most of my customers are internet users.
> Lately, I experienced an increase number of online reservations through my
> website. Though I use MYSQL database to store the orders and data gathered,
> yet I have concerns about any possible loss of information.
>
> Is there any affordable solution that can prevent data loss?
>
> Regards
>
>
>

-- 
Blog: 
http://darpanetwork.blogspot.com/
Atom: 
http://darpanetwork.blogspot.com/feeds/posts/default


-- 
MySQL Replication Mailing List
For list archives: 
http://lists.mysql.com/replication
To unsubscribe:    
http://lists.mysql.com/replication?unsub=lists@pantek.com