[WiP] Centralised database in My Video, My Pictures and folder settings (4 Viewers)

ajs

Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,371
    Kyiv
    Home Country
    Ukraine Ukraine
    You may install a stand alone TvServer to the host which will be installed with right setup. You can uninstall it later.
    I can not do that. I do not like to put too much. I've already figured out myself.

    Add localnet acess permition for root, But it is bad, it is necessary to urgently make the setting for a user name and password.:D
    ... on MySQL only picturedatabase and videodatabase. :coffee:
    Launched import NFO files.
    upload_2015-2-13_21-20-29.png upload_2015-2-13_21-25-43.png

    Log imports 509 files in attachment. Very long import ... :( ~50 min for ~500 nfo files ...
    upload_2015-2-13_22-11-25.png upload_2015-2-13_22-11-42.png
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Home Country
    Hungary Hungary
    Log imports 509 files in attachment. Very long import ... :( ~50 min for ~500 nfo files ...

    Can you compare (do the same import in a clean database) in SQLite database too?

    What is your experiment with this feature? ;)
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Home Country
    Hungary Hungary
    I'll try, but exports only took a couple of minutes.

    We scan the files by mediainfo.dll to get the resolution, audio and video codec info, so the import is longer than export.

    regeszter said: ↑
    What is your experiment with this feature?
    Do not quite understand what you mean.

    Did you test it inside the MP GUI to see how it works (performance, watched status, etc) or tested it with more than one client using with same database (without database corruption).
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,371
    Kyiv
    Home Country
    Ukraine Ukraine
    Did you test it inside the MP GUI to see how it works (performance, watched status, etc) or tested it with more than one client using with same database (without database corruption).
    Unfortunately I can not move all the HTPC on MySQL, while I can only check one en.

    We scan the files by mediainfo.dll to get the resolution, audio and video codec info, so the import is longer than export.
    Then most likely speed will be the same ...
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,371
    Kyiv
    Home Country
    Ukraine Ukraine
    IMHO it is necessary to make settings such settings Kodi.
    XML:
      <videodatabase>
        <type>mysql</type>
        <host>***.***.***.***</host>
        <port>3306</port>
        <user>MediaPortal</user>
        <pass>MediaPortal</pass>
      </videodatabase>
      <musicdatabase>
        <type>mysql</type>
        <host>***.***.***.***</host>
        <port>3306</port>
        <user>MediaPortal</user>
        <pass>MediaPortal</pass>
      </musicdatabase>
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Home Country
    Hungary Hungary
    IMHO it is necessary to make settings such settings Kodi.

    Yes but I do not think we should to use different server for each databases. One is enough.

    I updated the installer. It is based on 1.11 Pre Release.
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,371
    Kyiv
    Home Country
    Ukraine Ukraine
    Yes but I do not think we should to use different server for each databases. One is enough.
    Until enough for one, but there time will tell, it is necessary to someone more servers or not.

    I updated the installer. It is based on 1.11 Pre Release.
    Changes to the database have? Music is added or not?
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Home Country
    Hungary Hungary
    Until enough for one, but there time will tell, it is necessary to someone more servers or not.

    You can try it. The installer is attached to the 1st post.

    Changes to the database have? Music is added or not?

    The music database is under construction by @hwahrmann . I can not add MySQL support until he is not finished it.
     

    Users who are viewing this thread

    Top Bottom