RE: retrieving data

"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@gmail.com]
> Sent: Monday, July 23, 2007 5:10 PM
> To: calypso
> Cc: replication@lists.mysql.com
> 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@yahoo-inc.com
>
>

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