[mythtv-users] Slave Backend & Mysql

[Mike Perkins]

William Munson wrote:
> Bruce Nordstrand wrote:
>> Hi all
>>
>> I am a bit confused. The documentation on mythtv.org states this:
>>
>> "*NOTE*: Slave backends *must not* run a local MySQL daemon. By default, 
>> they will connect to their local daemon rather than the central 
>> database, causing unexpected behavior such as empty "Watch Recordings" 
>> lists and a failure to locate the Video Sources defined on the master 
>> backend. Modify the |/usr/local/share/mythtv/mysql.txt| file on all 
>> slave backends to ensure that the |DBHostName| has the address of the 
>> MySQL server."
>>
>> The way I read this is that you can have Mysql running on a slave 
>> backend as long as you modify mysql.txt, but I may be wrong as this 
>> statement is actually saying two different things....
>>
>> Am I reading this correctly?
>>
>> I ask as I need to offload commflagging and user jobs to a slave 
>> backend, which just so happens to be the desktop I am typing on - and 
>> this machine has MySQL running on it.
>>
>> Cheers
>> Bruce
>>   
> Slave backends must not run their own independant databases however it 
> is acceptable to run your sql database on a slave system. You just need 
> to make sure all myth boxes on your network point to the same mysql server.
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 
- There's also no problem running *other* mysql databases on other 
machines on your network, I do. Having more than one 'mythconverg' 
database is the issue. It can be on any machine, including any non-myth 
machine.

Mike Perkins