"Replication is not just for scale-out". It also provides backup.
The problem with preventing "data loss" is that many things can go wrong.
No single solution solves all problems.
'natural disaster' - need _remote_ backup
24/7 - need several things
disk crash - RAID or slave
network failure - sol
data corruption - delayed slave
hacker - firewalls, passwords, etc
software errors - sol
controller / motherboard failure - RAID won't help
etc.
If it is within your budget, replication (especially if not on the same
site) may cover the most situations.
> -----Original Message-----
> From: Darpan Dinker [mailto:
darpandinker@...]
> Sent: Monday, July 23, 2007 5:10 PM
> To: calypso
> Cc:
replication@...
> Subject: 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=rjames@...>
>
--
MySQL Replication Mailing List
For list archives:
http://lists.mysql.com/replicationTo unsubscribe:
http://lists.mysql.com/replication?unsub=lists@...