MySQL Support

  • Oh OK, I do that on my server, which seems the "right" place for it.


    This might be a good thing to do via docker, as mysql is kinda big to include as standard practice, when a playback machine is perhaps not the best place for this functionality.

  • It could be built in (we already build MySQL for the client which Kodi needs) but there are sub-zero plans to include it. The core OS is "client" focussed and the collective opinion is that DB's belong on a NAS box. That said, as long as you're not on a WeTek device with an ancient kernel you can load the docker add-on and then add a MySQL or MariaDB container.

  • Thanks, haven't heard of/used docker add-on before.
    Will look into it & see if it works.
    Would like MySQL to be on same HTPC running LE, just make things easier from a management point of view.

  • In my LAMP addon I have mysql server also. But addoin was not build for LE yet. If there is interest I can do.

    Gone...


  • In my LAMP addon I have mysql server also. But addoin was not build for LE yet. If there is interest I can do.


    Would be interested in this, although I came across your add-on on OE but seemed like its developement was dead or not working anymore.


  • I came across your add-on on OE but seemed like its developement was dead or not working anymore


    I updated it not so long back. And it was working including owncloud.


    But probably better to wait for a docker.

    Gone...


  • It was newer there - it is unofficial unofficial semi supported.


    Quote


    NOT WORKING CURRENTLY, THIS NEEDS CHANGES IN OPENELEC BOOT SCRIPTS


    Thats why never tried it. Hope you can fix it

  • There is nothing to fix - it is working on openelec.
    For libreelec I should only rebuild it (some RPi users already use it!). But now we are way to offtopic :D

    Gone...

  • Just got home..
    - Placed LE Update files in Update folder
    - Updated smoothly without a hitch
    - Installed Docker Add-On


    After some research found Docker MySQL
    Is this correct for getting MySQL up & running?

  • won't work, currently there is a problem with the docker add-on that make it so that docker comes up after kodi, so the mysql server won't be started in time and kodi would have to be restarted after the mysql server comes up

  • Thats the reason why I did OpenWrting to my cheap router (TP LINK 842ND). Stripped and light mysql with querry cache and innodb support works quite well with not big database and 2 home RPi clients (and it has only around 2,5MB binary, so not robust at all).


    Always hoped for that oportunity within ELEC, but this chicken-egg problem.. :)

    2x VIM3L, 3x X96 Air P3, 6x C2; 6x RPi2; 3x Win7 Kodi + vPeter's mariaDB plugin as Library DB

  • Instead of putting the mysql database on devices that aren't meant for it, like routers or media players, I would suggest to buy a cheap RPi and turn it into a dedicated database server.


  • Always hoped for that oportunity within ELEC, but this chicken-egg problem.


    There is oportunity to the same thing on openelec for almost 2 years now (I mean running mysql server on it).

    Gone...

    Edited once, last by vpeter ().