[mythtv-users] MythTV with MariaDB

Kevon mythtv at reidsresidence.com
Tue Mar 26 03:55:22 UTC 2013


On 03/25/2013 10:20 PM, Gary Buhrmaster wrote:
> On Tue, Mar 26, 2013 at 2:00 AM, Kevon <mythtv at reidsresidence.com> wrote:
>> Anyone running mythtv with mariadb? I'm about to replace mysql on my
>> myth box. Wanted to know if there are any gotchas.
> 
> On a devel box I am running MariaDB (and InnoDB tables with
> the barracuda format)(*).  No observed problems at this point (of
> course I had to perform approriate DB tuning(**)).  Note that neither
> MariaDB nor InnoDB is a supported configuration, so if it fails,
> it is all on me, and I will not be asking for assistance (and given
> the very small numbers of people running such unsupported
> configurations, you should expect little help if things break in
> bad ways).  As with all else, when touching a database, backup,
> backup, backup, and test the backup (just because it says the
> backup worked does not mean it actually did).
> 
> Gary
> 
> (*) My distro of preference will be using MariaDB as the
> default at the next release, so I decided to get ahead of
> that.
> 
> (**) In various previous lives, I have played a DB Admin,
> so have some experience, but a good start can be found
> on the wiki at: http://www.mythtv.org/wiki/Tune_MySQL
> if you are new at the game.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
> 

Gary,
Thanks for the pointers. I have not yet switch mysql to InnoDB. All my
databases were created before the default switch to InnoDB (5.5 I
think). I never had a problem with MyISAM so didn't see the need to
switch. Do I need to switch over to InnoDB before installing MariaDB?

My distro of choice is also making the switch to MariaDB. I very
comfortable with databases so I'm not worried about fixing things if
they break. I also have multiple backups which I know are recoverable.
I'll have to give my upgrade more thoughts as I don't have a test box
and it is already difficult enough to get small outage windows to make
minor changes.


More information about the mythtv-users mailing list