Posts: 111
Joined: May 2008
Reputation:
1
I ran into an issue with my PC that had XBMC's MySQL DB on it and it was out of commission for a couple of days. This left XBMC unable to get past the splash screen unless I disabled the advancedsettings.xml. Is there a way I can run a secondary MySQL DB on a different PC and have XBMC update both as changes to the library is made and if the primary DB is unavailable for some reason XBMC will access the secondary DB without any action from me?
This is no problem for me but if this happens when I am not home my wife would mot be happy with me.
Posts: 1,011
Joined: Sep 2011
Reputation:
20
lrusak
Team-Kodi Member
Posts: 1,011
No but you could setup profiles, have a main profile and a second one as a backup if there is not MYSQL available.
"PPC is too slow, your CPU has no balls to handle HD content." ~ Davilla
"Maybe it's a toaster. Who knows, but it has nothing to do with us." ~ Ned Scott
Posts: 19,982
Joined: May 2009
Reputation:
451
nickr
Retired Team-Kodi Member
Posts: 19,982
Yes of course there is. Mysql supports multiple synchronised servers. It is often used in failsafe environments with multiple servers delivering the same synchronised data to millions of requests per minute.
google "mysql replication"
If I have helped you or increased your knowledge, click the 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Posts: 111
Joined: May 2008
Reputation:
1
How do you get XBMC to access the second DB when the advancedsettings.xml points XBMC to the ip address of the primary DB.
Posts: 31,445
Joined: Jan 2011
I think XBMC only updates one DB, then the two MySQL servers talk to each other.
Posts: 1,606
Joined: Jul 2007
Reputation:
51
In my experience, when the MySQL server is inaccessible, it EVENTUALLY gives up and moves on without it. It takes like a min or two to get past the splash screen though to where it gives up. Though then it has nothing but an empty library of course.