[mythtv-users] Taking a Load Off DataDirect ???
r-mythtv at thefreemanclan.net
Mon Jun 12 23:12:33 UTC 2006
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.
More information about the mythtv-users