CentOS List schrieb:
>> For a speedy backup, could put the db on LVM. Then your procedure
>>
> would
>
>> be shutdown/freeze db, make lv snapshot, startup/unfreeze db,
>> rsync/backup data, remove snapshot.
>>
> That's what I'd suggest too, but
>> >>> For a speedy backup, could put the db on LVM. Then your procedure
would
>> >>> be shutdown/freeze db, make lv snapshot, startup/unfreeze db,
>> >>> rsync/backup data, remove snapshot.
>> >> That's what I'd suggest too, but be warned that performance on that
>> >> database (if gets to be of
On Wed, 2009-02-18 at 13:57 -0800, Scott Silva wrote:
> on 2-18-2009 1:45 PM Scott Silva spake the following:
> > on 2-18-2009 1:36 PM Ian Forde spake the following:
> >> On Wed, 2009-02-18 at 15:35 -0500, Toby Bluhm wrote:
> >>> For a speedy backup, could put the db on LVM. Then your procedure wou
on 2-18-2009 1:45 PM Scott Silva spake the following:
> on 2-18-2009 1:36 PM Ian Forde spake the following:
>> On Wed, 2009-02-18 at 15:35 -0500, Toby Bluhm wrote:
>>> For a speedy backup, could put the db on LVM. Then your procedure would
>>> be shutdown/freeze db, make lv snapshot, startup/unfre
on 2-18-2009 1:36 PM Ian Forde spake the following:
> On Wed, 2009-02-18 at 15:35 -0500, Toby Bluhm wrote:
>> For a speedy backup, could put the db on LVM. Then your procedure would
>> be shutdown/freeze db, make lv snapshot, startup/unfreeze db,
>> rsync/backup data, remove snapshot.
>
> That's
On Wed, 2009-02-18 at 15:35 -0500, Toby Bluhm wrote:
> For a speedy backup, could put the db on LVM. Then your procedure would
> be shutdown/freeze db, make lv snapshot, startup/unfreeze db,
> rsync/backup data, remove snapshot.
That's what I'd suggest too, but be warned that performance on that
Joost Waversveld wrote:
>
> 1.
> ===
> RAID IS NO BACKUP! RAID is only to survive hardware failure of the hard
> disk(s) (and only if you don't use RAID0!).
>
> Other people are mentioning the Master/Slave setup. This will do if you
> just need one up to date backup for the coincidence the co
>> Or just use a RAID array (eg software RAID in mirror mode: RAID1).
>>
>
> RAID IS NOT BACKUP
>
> To the OP:
> It would be helpful if you were more descriptive about what you are
> trying to accomplish. Are you worried about disk failures? Are you
> worried about the whole system failing?
CentOS List wrote:
> Hi,
>
> I had a cfml application running on mysql database. Can some suggest a
> realtime backup solution via ftp say every 5mins without damaging the
> database?
>
do your backups have to have some level of history ? or just one
backup as of the last snapshot interval
CentOS List wrote:
> Hi,
>
> I had a cfml application running on mysql database. Can some suggest a
> realtime backup solution via ftp say every 5mins without damaging the
> database?
Using ftp every 5 minutes implies a pretty small database, like others
have suggested I would suggest setting up a
On Wed, 18 Feb 2009, Robert Heller wrote:
>> How big and what engine is the db to be secured?
>>> every 5mins
>> Backing up that often doesn't make sense to me. If you need to have it
>> that frequently you better go for a slave or write to two backends.
I have to wonder when I see these kind o
On Wed, Feb 18, 2009 at 8:58 AM, Robert Heller wrote:
> At Wed, 18 Feb 2009 14:31:18 +0100 CentOS mailing list
> wrote:
>>
>> CentOS List wrote on Wed, 18 Feb 2009 14:30:16 +0800:
>>
>> > every 5mins
>>
>> How big and what engine is the db to be secured?
>> Backing up that often doesn't make sen
At Wed, 18 Feb 2009 14:31:18 +0100 CentOS mailing list
wrote:
>
> CentOS List wrote on Wed, 18 Feb 2009 14:30:16 +0800:
>
> > every 5mins
>
> How big and what engine is the db to be secured?
> Backing up that often doesn't make sense to me. If you need to have it
> that frequently you better
CentOS List wrote on Wed, 18 Feb 2009 14:30:16 +0800:
> every 5mins
How big and what engine is the db to be secured?
Backing up that often doesn't make sense to me. If you need to have it
that frequently you better go for a slave or write to two backends.
Kai
--
Kai Schätzl, Berlin, Germany
G
CentOS List wrote:
> Hi,
>
> I had a cfml application running on mysql database. Can some suggest a
> realtime backup solution via ftp say every 5mins without damaging the
> database?
>
> Thanks
>
> regards
>
Sorry but i see two conflicting ideas in the same sentence : 'realtime'
and 'every 5
- Original Message
> From: John Doe
> To: CentOS mailing list
> Sent: Wednesday, February 18, 2009 5:40:48 PM
> Subject: Re: [CentOS] realtime backup
>
>
> From: CentOS List
> > I had a cfml application running on mysql database. Can some suggest a
>
From: CentOS List
> I had a cfml application running on mysql database. Can some suggest a
> realtime backup solution via ftp say every 5mins without damaging the
> database?
Wouldn't a simple mysqldump work?
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
JD
__
Hi,
I had a cfml application running on mysql database. Can some suggest a
realtime backup solution via ftp say every 5mins without damaging the
database?
Thanks
regards
___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listi
18 matches
Mail list logo