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

[Stephen Worthington]

On Fri, 26 Aug 2016 07:29:14 -0400, you wrote:

>
>
>On 08/25/2016 12:03 PM, Stephen Worthington wrote:
>> On Thu, 25 Aug 2016 11:16:40 -0400, you wrote:
>>
>>>
>>> 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
>> As I said - I need the readline library.  MySQL now uses editline,
>> which does not work for me.
>Can I assume that if I'm only using this computer to run mythbuntu, 
>mostly as the backend for the house that I do not need to worry about 
>whatever readline library is and the differences between MySQL and MariaDB??

Yes.  You only need readline if you are using the command line
utilities.  I do a lot of database access via the mysql command line,
and I found using editline was a pain, where readline does what I
need.