MySQL Forums
Forum List  »  InnoDB

Master-Slave with InnoDB
Posted by: emil öhgren
Date: July 13, 2011 01:43AM

Hi
I'm replacing a MySQL server with new hardware.
The server uses InnoDB, and was previously setup as a master. ( Not from start tho )

When I got the new server I installed it and configured it as Slave. So the Master-Slave relations is working. I can replicate NEW databases, but not the ones that I need to replicate due to alot of transactions in the binlog-files are missing.

How do I replicate this? With NO or minimal downtime?
All the tables in the database uses InnoDB and many of them use Foreign Keys.

I read that one workaround was to Alter table engine to MyISAM, then load from master and change back when they are once synced. but how will this affect the tables that are using Foreign Keys?

After The data is replicated on the new server, I will reinstall the old and use Master-Slave;Slave-Master relations.

I am grateful for every tip I get

Best regards
Emil

Options: ReplyQuote


Subject
Views
Written By
Posted
Master-Slave with InnoDB
2947
July 13, 2011 01:43AM
1017
July 14, 2011 10:00AM
1052
July 15, 2011 12:04AM
783
July 15, 2011 10:13AM
1309
July 18, 2011 01:04AM
852
July 18, 2011 08:59AM
1755
July 19, 2011 02:14AM
908
July 19, 2011 09:04PM
909
July 20, 2011 01:40AM
1135
July 20, 2011 09:51AM
826
July 25, 2011 06:36AM
1099
July 25, 2011 09:26AM
1008
July 28, 2011 06:32AM
1011
S D
August 09, 2011 03:22PM


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.