Re: Akonadi-MySQL Issues
On Monday 15 March 2010, George Kiagiadakis wrote:
> On Sun, Mar 14, 2010 at 2:28 PM, Dominik Schulz <lkml@ds.gauner.org>
wrote:
> > 2.) Akonadi backup
> > Another issue is also related to MySQL. Since MySQL/InnoDB is used
> > as an Akonadi backend, it troubles me how to properly backup user
> > profiles in a multi-user setup. Right now I'm just backing up the
> > users homedirs which covers most personal data and applicatin
> > profiles, but with InnoDB this becomes difficult w/o LVM Snapshots
> > (which aren't available on all systems right now). How is the
> > akonadi db supposed to be backed up? Or is the information in the
> > db no vital to akonadi and shouldn't backed up at all? The akonadi
> > documentation seems to point this way, but I'm not sure.
>
> Well, since akonadi's database is stored in ~/.local, if you backup
> the whole home dir, akonadi's db should be backed up too.
That, unfortunately, is a misconception. If you just copy the database
files while akonadi is running, you're in no way guaranteed to get a
consistent snapshot. The clean way to backup a database is to
transactionally dump its contents.
> The only
> problem is that the database is huge; it's at least 100MB (!!!) when
> it's created for the first time and keeps growing.... (On my
> university's lab the admins have disabled akonadi just because of
> that, to save space)
On a personal computer, I don't see the size itself as a problem.
However, regarding backups, there's no way to make small, incremental
backups. Tools such as rsnapshot (that keep hardlinks to unchanged files
in a snapshot) are thwarted, too.
BTW, it's not just akonadi that's affected by this problem, amarok has
started to use an embedded MySQL engine, too.
Michael
--
Michael Schuerig
mailto:michael@schuerig.de
http://www.schuerig.de/michael/
Reply to: