[mythtv-users] Mythbuntu change from MySQL to MariaDB?

[Jim Abernathy]

On 08/25/2016 10:16 AM, Stephen Worthington wrote:
> On Thu, 25 Aug 2016 05:33:28 -0400, you wrote:
>
>>
>> On 08/24/2016 10:41 PM, Stephen Worthington wrote:
>>> On Wed, 24 Aug 2016 17:16:22 -0400, you wrote:
>>>
>>>> On 08/24/2016 04:59 PM, nospam312 wrote:
>>>>> On 22 August 2016 at 12:08, Jim Abernathy <jfabernathy at outlook.com
>>>>> <mailto:jfabernathy at outlook.com>> wrote:
>>>>>
>>>>>
>>>>>       http://www.mythbuntu.org/downloads
>>>>>       <http://www.mythbuntu.org/downloads>
>>>>>
>>>>>
>>>>> Thanks for your replies but I do not know if you are trying to wind me
>>>>> up or not.
>>>>>
>>>>> I can see no reference to a MariaDB version on that page just the
>>>>> standard Mythbuntu download?
>>>>>
>>>>> Can you help with a specific download for the ISO with MariaDB used
>>>>> instead of MySQL?
>>>>>
>>>>> To get a clean install would be worth the effort instead a more than
>>>>> perfect removal of MySQL and then install of MariaDB.
>>>>>
>>>> I'm not smart enough to know MySQL from MariaDB.  I just downloaded
>>>> mythbuntu from the download site, burn it to a CDROM or USB key and
>>>> install it.  The database always takes care of itself.  I only rebuild
>>>> when I have all my recordings archived to a NAS and my database is
>>>> basically empty.  I rebuild it before the fall TV season starts.  So now
>>>> I'm committed to Mythbuntu 14.04.4 until next year because of issues I'm
>>>> having with 16.04.  I can get 16.04 working except for 2 issues that are
>>>> not DB related.  Just related to my TV and A/V receiver.  There is also
>>>> a bug with mythtranscode that has not been fixed so I'm staying on
>>>> mythtv 0.27
>>>>
>>>> So even though I've tested a lot on 0.28, and 16.04, I still have no
>>>> idea why you are worried about MySQL vs. MariaDB.  I still use mysql
>>>> commands on 16.04.  So I'm unaware of any changes in that area.
>>>>
>>>> I have to mottoes to live by.
>>>> 1.  if it ain't broke don't fix it and
>>>> 2.  You can't drink all day if you don't start in the morning.
>>>>
>>>> Jim A
>>> I am converting to using MariaDB in 16.04 due to MySQL changing from
>>> using the readline library to editline.  Editline does not work for me
>>> in bringing back SQL commands from history, which I find extremely
>>> aggravating since readline works very well and I use the history all
>>> the time.  Apparently Oracle do not want readline's GPL or LGPL
>>> licensing as part of MySQL, so they switched to editline because its
>>> licensing is more what they want.  I find that a problem also, as it
>>> may indicate that Oracle are trying to make MySQL proprietary somehow
>>> instead of freeware.
>>>
>>> MariaDB is extremely compatible with MySQL and it is actually hard to
>>> tell which one is installed without looking hard.  The MariaDB
>>> packages directly replace the MySQL ones (using the same executable
>>> names) and provide all the same commands and services.  The only
>>> difference that I found that I had to deal with was that MariaDB has
>>> some config files that belong to it only and are separate from the
>>> normal MySQL config files.  Doing that, combined with how the MythTV
>>> packages do their MySQL config and how I had overridden some default
>>> settings in the MythTV MySQL config did not work with MariaDB as the
>>> config files ended up being loaded in a different order, so my
>>> overrides were not being loaded last.  That resulted in the IP address
>>> for accessing the database not being set to my MythTV box's external
>>> IP address and it was defaulting to localhost.  It was easy enough to
>>> fix once I worked out what was happening.
>>> ___
>> So If you do a standard Mythbuntu 16.04 install from CDROM, which
>> database are you using?
>>
>> MCC still has a MySQL section
>>
>> Jim A
> The default install uses MySQL.  You have to install MariaDB yourself
> after installing Ubuntu.  That will uninstall MySQL and install
> MariaDB in place of it.  MCC should not be able to tell the difference
> - MariaDB is almost indistinguishable from MySQL to any program that
> is using a MySQL database.

Ok, I got it, but why would someone know to uninstall MySQL and install 
MariaDB?  If Ubuntu uses MySQL by default and Mythtv still works with 
it, why would you change?

Jim A

> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org