(2013-04-03 06:15)ivanmmj Wrote:(2013-04-02 01:34)winestock Wrote:(2013-03-28 01:49)ivanmmj Wrote: Would you be interested in an addition to the Wiki on how to set this up in Arch with MySQL and/or MariaDB? I'm thinking of moving my server from Ubuntu to Arch as it's the only machine in the house that still runs Ubuntu and I figured I could always make a walkthrough as I do it.
I converted over not too long ago from mysql to mariadb for ALARM. Are you planning on updating: http://wiki.xbmc.org/index.php?title=HOW...ySQL/ALARM? I was planning on submitting some changes to Ned on this.
When you setup mariadb I suggest that you try out the myisam storage engine which I found was a lot faster then the default innodb storage engine for the purposes of XBMC.
The only thing I'd be afraid of with using myisam would be loss of data integrity. But then again, my server has a battery backup... Maybe I'll check it out. Have you tried any of the other storage engines?
The other storage engines I have tried is innodb and aria. Both are slower then myisam. I also have my server on battery backup. I backup the mysql data using mysqldump periodically. I also use the XBMC export to single file as another backup of the XBMC library. If I need to rebuild my XBMC library it would take me at most about 5 minutes using either of the backups.