Is it possible to create differential backups based on LVM snapshots (or maybe a similar technique)?
I'd like to perform backups of my intranet server, which hosts multiple services, and their databases (currently using Postgres 8, Postgres 9 and MySQL). So I thought about setting up log shipping based backups (in addition to backing up the file system), but the whole thing is getting a little bit complex.
As an alternative, I'm considering LVM snapshots - but the databases are not small, and I'll need to save backup space...
It's also important, that LVM snapshots are highly safe to use while a database is constantly writing files.