retrieving data

[calypso]

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

[Darpan Dinker]

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@...

[Rick James]

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

[johntalbot]

I own a money transfer company, which is considered to be a small firm. We have around 10-15 computers on our network. I am currently using a backup software called Safeguard.
It basically works unattended i.e you create the backup program once by determining all the data you want to backup then you schedule it according to how often you want the backup to occur. It also acts as an archiving and versioning system as a result of the database found in it, allowing you to retrieve all versions of your files immediately.

You can download a free version on this website: http://www.epsam.com

[Luis Torres-4]

Hi,

I personally like using replication to have a "hot spare" of my main DB. That way if you have some bad hardware failure on the DB you at least have a working copy of the data on an already configured server.

On that replicated copy (slave as we call them here) you can make backups at your convenience since in that server you can lock all tables, make a clean copy/backup of the DB and then resume replication.

IMO, if you can afford even a small server to handle those tasks you should go for it. It's really worth it and let's you keep your valuable data in more than 1 location.

Regards,

Luis

----- Original Message ----
From: calypso <feedback@...>
To: replication@...
Sent: Monday, July 23, 2007 3:58:32 AM
Subject: retrieving data



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


--
View this message in context: http://www.nabble.com/retrieving-data-tf4128347.html#a11740038
Sent from the MySQL - Replication mailing list archive at Nabble.com.


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








       
____________________________________________________________________________________
Moody friends. Drama queens. Your life? Nope! - their life, your story. Play Sims Stories at Yahoo! Games.
http://sims.yahoo.com/