MySQL Forums
Forum List  »  InnoDB

Re: Switch to file_per_table using a slave
Posted by: Chris Weyn
Date: May 08, 2010 03:03PM

We do have backups running at night. They take ~12 hours or so. I would use that to build the slave and then let catch up...

I am not able to change servers so I had another idea: build the slave on the same server and then switch to that as the new master.

I have to test whether that is not going to cause too much I/O on our system...

What do you think of this option?

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Switch to file_per_table using a slave
1304
May 08, 2010 03:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.