Taking a Load Off DataDirect ???
- From: Brian Guilfoos <mythtv (at) guilfoos.com>
- Date: Mon, 12 Jun 2006 09:04:44 -0400
Robert Tsai wrote:
> On Sun, Jun 11, 2006 at 07:26:40PM -0600, Brian Wood wrote:
>
>> How about a way to share the schedule data with multiple machines?
>> My Mom's or Brother's machine could be pointed at mine to obtain
>> data, taking some load off DataDirect.
>>
>
> If the channel lineups are identical, you could probably do something
> with exporting/importing the relevant DB tables across the various
> machines.
MySQL replication might be a good candidate. Just limit the replication
user to replication rights only on the relevant tables.
http://dev.mysql.com/doc/refman/4.1/en/replication-howto.html
Of course, I'd probably play around with this on a non-production box
first, until you've got it working like you want. But it seems fairly
straightforward to me.
_______________________________________________
mythtv-users mailing list
mythtv-users (at) mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users