Quick tip for setting up multiple computers to a single database

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
PatientZro Offline
Junior Member
Posts: 3
Joined: Jan 2012
Reputation: 0
Post: #1
I'm setting up multiple computers to connect to a single MySQL database (following the LH instructions) and thought of a nice quick tip that may help others.

Instead of creating the advancedsettings.xml file on every computer I'm setting up (4 in total) I created a master file hosted on my file server and created symbolic links on each of the computers to this master file.

This ensures that there's no spelling mistakes in each file, and as I add to the file for new centralized functions, all the remote computers automatically pick up the changes.
find quote
Mondo Offline
Junior Member
Posts: 2
Joined: Nov 2011
Reputation: 0
Post: #2
I have my two installations sync'd and it's working as far as watched items is concerned. Now I'm trying to sync Icefilms favorites (just created a thread about it) are you doing this as well? If so, how?
find quote
GavinCampbell Offline
Junior Member
Posts: 40
Joined: Jan 2012
Reputation: 0
Post: #3
I was looking to do this as well. Where did u out the symbolic links? What did it redirect?

Does it also centralize the plugins and settings?
find quote
PatientZro Offline
Junior Member
Posts: 3
Joined: Jan 2012
Reputation: 0
Post: #4
I'm not doing any plugin synchronization....yet.

Once I get my library rebuilt and a bit of free time, maybe I'll look at plugin sync.

As for where to put the symbolic link and file.

My file server is running Windows, as is my regular PC, so I opened a dos window, navigate to the <user>\appdata\roaming\xbmc\userdata folder and used the following command:

mklink advancedsettings.xml \\<server>\mediaShare\advancedsettings.xml

I'm guessing that since this location isn't stored in the MySQL database, I could have just as easily mapped a drive to \\<server>\<share> then had the link point to drive:\advancedsettings.xml.
find quote
GavinCampbell Offline
Junior Member
Posts: 40
Joined: Jan 2012
Reputation: 0
Post: #5
PatientZro Wrote:I'm not doing any plugin synchronization....yet.

Once I get my library rebuilt and a bit of free time, maybe I'll look at plugin sync.

As for where to put the symbolic link and file.

My file server is running Windows, as is my regular PC, so I opened a dos window, navigate to the <user>\appdata\roaming\xbmc\userdata folder and used the following command:

mklink advancedsettings.xml \\<server>\mediaShare\advancedsettings.xml

I'm guessing that since this location isn't stored in the MySQL database, I could have just as easily mapped a drive to \\<server>\<share> then had the link point to drive:\advancedsettings.xml.

Thanks for the info. I have atv2's as my front ends to the mysql database so I guess it would be different. I'm going to search around and see if this is possible on the atv2. Would make things easier to manage.
find quote
PatientZro Offline
Junior Member
Posts: 3
Joined: Jan 2012
Reputation: 0
Post: #6
If I understand correct, atv's use a custom build of Linux as an OS for XBMC, so you should still be able to do symlinks.

After thinking about the plugins, I am thinking that since XBMC can be run from USB, it should be able to symlink the entire folder structure...something for me to look into.
find quote
hömma Offline
Junior Member
Posts: 6
Joined: Jul 2011
Reputation: 0
Post: #7
I'm using a NAS Server where I can't install MySQL. Would it be possible to share the whole Database between different Windows-builds on the NAS via symlink? Or would I brick it when accessing the DB from 2 XBMCs at the same time?
(This post was last modified: 2012-01-30 15:19 by hömma.)
find quote
GavinCampbell Offline
Junior Member
Posts: 40
Joined: Jan 2012
Reputation: 0
Post: #8
hömma Wrote:I'm using a NAS Server where I can't install MySQL. Would it be possible to share the whole Database between different Windows-builds on the NAS via symlink? Or would I brick it when accessing the DB from 2 XBMCs at the same time?

From what I have read, it is said you will mess up the DB if you try to do this. The only way is to have a central MYSQL database.
find quote