SQL server on a different host (1 Viewer)

[posterberg]

Hi there,

I am just wondering if the SQL server can run on a separate host than the TV server application.

I already have a dedicated MySQL server running in my LAN, I would love to be able to use that one to take some of the load off of the TV server host.

Is this possible?

Thanks in advance,
Peter

 

[deebo]

yes you can

just create a user that can connect from the htpc's host

grant select,insert,update,create on tvlibrary.* on 'htpc'@'your htpc hostname/ip here' identified by 'htpc'

 

[posterberg]

That's nice, thank you!

Does the server never need to delete entries from the database? I didn't see the delete command in the grant list.

Is it possible to password protect the account? I guess I'll have to live with "just" limiting which host that connect otherwise...

Thanks again!

 

[deebo]

yea delete is needed, you can just grant all on tvlibrary.*

 

[posterberg]

Thanks again!

 

[bitbucket]

Is it possible to use the sql server of an existing tve3 server for a second tve3 server that is running on another pc? I would like to avoid a sql installation on that machine.

Thanks,
bitbucket

Edit: Am I right that what I have asked is a typical master/slave server configuration?