[mythtv-users] Slow MySQL query after delete
s2.akira at tin.it
Wed Sep 5 17:40:11 UTC 2007
On Wednesday 05 September 2007 19:26:45 David Brodbeck wrote:
> I think the biggest win would be if this allowed them to arrange
> things so that all DB access went through the backend. Having the
> frontends talking to the DB directly adds another level of
> complication -- you have to configure access control in MySQL, and
> you have to make sure the MySQL port is open on any firewalls between
> the two systems. Better to embed that in the same control channel
> MythTV is already using, in my opinion.
If we are talking only about frontends (no remote backends that share a db
with the master backend), then every frontend could use its own db (I am
thinking about something like sqlight) to store its settings, and get
everything else from the backend as you sad.
More information about the mythtv-users