[mythtv-users] Conversion from single backend to new master/slave backend?
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?
More information about the mythtv-users