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/replicationTo unsubscribe:
http://lists.mysql.com/replication?unsub=lists@...
