Re: [BackupPC-users] mysql addon or plugin?

2011-03-26 Thread Les Mikesell
On 3/26/11 12:56 PM, hans...@gmail.com wrote: > I may be wrong here, more reading than experience in this particular > area, but my understanding is that it would still recommend making > sure nothing's writing to the database while the dump is taken. > > For a heavily used transactional systems wi

Re: [BackupPC-users] mysql addon or plugin?

2011-03-26 Thread hansbkk
I may be wrong here, more reading than experience in this particular area, but my understanding is that it would still recommend making sure nothing's writing to the database while the dump is taken. For a heavily used transactional systems with complex relational structures, IMO it's possible tha

Re: [BackupPC-users] backend to nfs nas share

2011-03-26 Thread Les Mikesell
On 3/25/11 11:47 PM, Lord Sporkton wrote: > I was planning to make my backend storage box with zfs which as i > understand it support easy expansion to multiple new disks. Then run > either iSCSI or NFS between the backend storage box and the front end > BPC box You might like nexentastor for that

Re: [BackupPC-users] mysql addon or plugin?

2011-03-26 Thread Doug Lytle
hans...@gmail.com wrote: > If you want > to really minimize the downtime, then using LVM snapshotting is a good > option. > > 1. shut down the service > 2 take the snapshot > Just an addition to this, If using the XFS file system, snapshotting will cause LVM to preform an file system freeze,