[mythtv-users] Conversion from single backend to new master/slave backend?

David Frascone dave at frascone.com
Tue May 15 18:24:24 UTC 2007



Brian Guilfoos wrote:
> David Frascone wrote:
>   
>> 1) Move the database to a *third* server -- one with raid 5.
>> 2) Move the tuner card(s) and firewire over to the "new" rackmount server.
>> 3) Make the "old" server a storage / transcoding backend.  I could 
>> possibly leave at tuner here too.
>>
>> So - -what's the best way to do this?  Copy the entire database first?  
>> (With mysqlbackup?  what's the best way to do that)?
>>     
>
> I'd probably move the DB first.  Get mysql up and running on the new
> machine.  Use mysql dump to back up the DB, and then copy that file over
> to the new machine and reload that data.  Go around to each machine (er,
> one right now), and make sure .mythtv/mysql.txt points at the new IP.
> Shut down the old mysql server, and make sure everything still works.
> If it does, you can probably go ahead and clean up the old server
> (uninstall mysql, delete the old data files, whatever) if you like.
>
>   
Cool -- db move worked!

So -- as an intermediate test, I'm going to have my database server run 
mythjob queue . . .

I'm also assuming that mythfilldatabase should run on the database 
server, no?  Why load the backend with it, right?

-Dave


More information about the mythtv-users mailing list