[mythtv-users] Sharing data between two backends

Robert Johnston anaerin at gmail.com
Fri Apr 15 18:38:09 UTC 2005


On 4/15/05, Mark Gardner <markgard at gmail.com> wrote:
> > I like to share recordings between two backends - one
> > in the US and one in Germany. Has anyone done this
> > yet? Or an idea how to do that. Data could be rsync'ed
> > over night but how to get the database updated or how
> > to select the recordings I want. This would be a nice
> > new feature.
> > Thanks.
> 
> I think Rsync would be your best option for the Data Portion.  One
> idea would be to just point myhth backend to only one of the Mysql
> Servers.  IE both US and Germany point to the Mysql instance in
> Germany. (Then again i don't know how heavily the database is hit when
> starting a show or if the lag would be acceptable.)

I'm not sure how it's done in MySQL, but in MSSQL you'd use the
Replication Service for this, which would keep both DB's in sync
pretty much all of the time, and isn't that heavy. Try searching for
"MySQL Replication" and see if that helps
-- 
Robert "Anaerin" Johnston


More information about the mythtv-users mailing list