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

[Brian Guilfoos]

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.