Re: [BackupPC-users] mysql addon or plugin?
2011-03-26 13:58:28
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 that otherwise there would be data
inconsistencies - e.g. this table's been updated but that one hasn't
yet completed.
Probably less important for mailstores.
On Sat, Mar 26, 2011 at 6:57 PM, Doug Lytle <support AT drdos DOT info> wrote:
> hansbkk AT gmail DOT 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, just before the snapshot. No shutting down the
> service is needed.
>
> Doug
------------------------------------------------------------------------------
Enable your software for Intel(R) Active Management Technology to meet the
growing manageability and security demands of your customers. Businesses
are taking advantage of Intel(R) vPro (TM) technology - will your software
be a part of the solution? Download the Intel(R) Manageability Checker
today! http://p.sf.net/sfu/intel-dev2devmar
_______________________________________________
BackupPC-users mailing list
BackupPC-users AT lists.sourceforge DOT net
List: https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki: http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [BackupPC-users] mysql addon or plugin?, Lord Sporkton
- Re: [BackupPC-users] mysql addon or plugin?, hansbkk
- Re: [BackupPC-users] mysql addon or plugin?, Doug Lytle
- [BackupPC-users] moved server, now stuck in chkdsk, Chris Baker
- Re: [BackupPC-users] moved server, now stuck in chkdsk, Les Mikesell
- Re: [BackupPC-users] moved server, now stuck in chkdsk, Tyler J. Wagner
- Re: [BackupPC-users] moved server, now stuck in chkdsk, Holger Parplies
- Re: [BackupPC-users] moved server, now stuck in chkdsk, Chris Baker
Re: [BackupPC-users] mysql addon or plugin?, Igor Sverkos
|
|
|