MYSQL help

[ludespeedny]

I have mysql configured for the 2 pi’s I want to use. I am trying to get artwork, and sources working correctly.
I have on my main pi:
advanced settings options for mysql pointing to 127.0.0.1 and my sources are just the local usb drive connected.

on the secondary pi I have the advanced options pointing to the main pi’s ip: we’ll say it is 10.10.10.10

How do I set up the sources on the 2nd pi to get everything working? (movies, music, and artwork)
Should I have set the main pi’s sources as it’s ip path to the usb drive folders and not just set content from the attached usb drive?

[fzinken]

A quick search would have shown you this thread

Path to samba shared device

Ok, when adding stuff to the library you are using the Kodi smb client which access the files without mounting them as a drive. If you really have an interest to have it mounted as a drive you would need to do so manually via fstab. But there is no need to do so, you just could do it all within Kodi. If you want to change e.g. the location for the thumbnail checkout example 2 of path substitution. http://kodi.wiki/view/Path_substitution

Read up pathsubstitution on the kodi.wiki that should answer most of your questions

[ludespeedny]

If I set the paths for sources and mysql in the main pi to point back to it’s own ip, will it be noticably slower?

[fzinken]

Should not have a huge impact but path substitution should allow you to use on each device the most optimal connection path,

[ludespeedny]

would it be better to set up both libraries to hit the ip path for the media files and redirect the main pi through substitution to the local drive, or would it be better to set up the main pi’s sources, and just redirect that path on the 2nd pi to hit the ip?