[mythtv-users] Taking a Load Off DataDirect ???

[Richard Freeman]

Brian Guilfoos wrote:
> MySQL replication might be a good candidate.  Just limit the replication
> user to replication rights only on the relevant tables.
> 

If you're going to go to all that trouble, why not just have a
multi-backend multi-frontend centralized system?  Then you'd get a
shared pool of recordings as well.  There are distributed filesystems
for linux which would allow you to pool storage as well.

That certainly sounds a lot easier than trying to replicate the database
across multiple independent servers.

Actually, with mysql can you have the database query a single table from
someplace else?  With most databases (Oracle et al) you can create a
view which queries another database.  No need to replicate the data, you
can just query it from the other server.