[kdepim-users] changing database backend

[Daniel Vrátil]

On Wednesday 12 of November 2014 02:17:14 René J.V. Bertin wrote:
> Hello,
> 
> I'd be interested to change from the builtin sqlite backend I'm currently
> using with the akonadiserver to using an "internal external" db server. I
> understand performance gains can be had with that, esp. if it can be
> configured to NOT do it's own form of COW since I'm running ZFS (innodb has
> such an option).
> 
> I'm by no means database savvy, so I'd like to advice concerning the best
> choice for the server and the options to run it with (knowing that I also
> use KMail on a "kick-around" 2yo netbook). Any special care to observe to
> convert an existing configuration from one db backend to the other (I'd
> hate to have to reconfigure all the other settings)? On OS X/MacPorts,
> akonadi is configured by default to use mariadb; is that a good choice?

I personally use PostgreSQL, because I find it faster and more reliable. At 
some point I'd like to see it as default backend (but that's another topic). I 
can't say how well PostgreSQL performs on OS X, and I think you will be more 
lucky with getting some support for MariaDB on OS X than PostgreSQL, but I 
might be wrong *shrug*.

Switching backends is not officially supported by Akonadi, and the recommended 
way is to remove all Akonadi  data and configuration, then configure Akonadi 
to use the new backend, and start it. Yes, this is the only case when we 
actually recommend wiping Akonadi :)

Daniel

> 
> Thanks,
> René
> _______________________________________________
> KDE PIM users mailing list
> Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users

-- 
Daniel Vrátil | dvratil at redhat.com | dvratil on #kde-devel, #kontact, #akonadi
Software Engineer - KDE Desktop Team, Red Hat Inc.

GPG Key: 0xC59D614F6F4AE348
Fingerprint: 4EC1 86E3 C54E 0B39 5FDD B5FB C59D 614F 6F4A E348
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kdepim-users/attachments/20141112/e0f978a0/attachment.sig>
-------------- next part --------------
_______________________________________________
KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users