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
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
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
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,