2014-07-03, 16:08
Is there any way to use both mysql and local library at the same time?
The reason i asked is that i have recently moved my library to a mysql server hosted on my NAS in prep for me adding an additional XMBC instance in the bedroom. However since doing this there is a noticeable delay when browsing through the library on my main theatre PC, i assume this delay is due to it having to query the nas, and the nas replying.
I was thinking the ideal solution would be if i could use *both* the mysql server and the local library at the same time, designate my main XBMC instance on my main HTPC as the master, all other instances as duplicates which are duplicated via the MySql server on the NAS, then whenever the master PC writes any changes to its library it sends those changes to both its internal database and the hosted database. That way when I browse the library from my bedroom, or any additional instances I may add i have access to the most up to date library without the associated slowdown on the main machine.
Does anyone know of any way to do this?
The reason i asked is that i have recently moved my library to a mysql server hosted on my NAS in prep for me adding an additional XMBC instance in the bedroom. However since doing this there is a noticeable delay when browsing through the library on my main theatre PC, i assume this delay is due to it having to query the nas, and the nas replying.
I was thinking the ideal solution would be if i could use *both* the mysql server and the local library at the same time, designate my main XBMC instance on my main HTPC as the master, all other instances as duplicates which are duplicated via the MySql server on the NAS, then whenever the master PC writes any changes to its library it sends those changes to both its internal database and the hosted database. That way when I browse the library from my bedroom, or any additional instances I may add i have access to the most up to date library without the associated slowdown on the main machine.
Does anyone know of any way to do this?