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

[ajs]

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.
... on MySQL only picturedatabase and videodatabase.
Launched import NFO files.


Log imports 509 files in attachment. Very long import ... ~50 min for ~500 nfo files ...

 

[regeszter]

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?

 

[ajs]

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

I'll try, but exports only took a couple of minutes.

What is your experiment with this feature?

Do not quite understand what you mean.

 

[regeszter]

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]

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]

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

~25min

 

[ajs]

IMHO it is necessary to make settings such settings Kodi.

  <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]

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]

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]

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.