MySQL Forums
Forum List  »  Replication

Re: Initial setup of replication with large tables
Posted by: A B
Date: August 14, 2011 09:09PM

Thanks, Rick.

** We use InnoDB on Windows

First: "Other ways to do it? Plan ahead. Setting up a Slave takes "no time" when you have no data. Sorry, you are in a tough situation. "
- I laughed when i read this.

well, this is our first foray into the world of replication so it was nto considered previously. oh well...

1. regarding teh binary logs
- how often do they get flushed, merged, rolled or removed? that is, do the binary logs keep incrementing forever?
- what is their lifetime?
I assume they must be flushed or something at some stage as surely you would not want to replay a large period's worth of transactions if a crash occurs.
- not sure about this, though.


2. regarding my Replication issue
I think my plan C, then, will be the best option. we can suffer a (planned) outage of up to about 4 hours) so:
- start building the Slave with the unchanging archive tables.
- turn on binary logging
- then do a dump of the live tables (about an hour)
- restore the live tables to the Slave
- start the replication

I think that should work then.

thanks for your advice.



Edited 1 time(s). Last edit at 08/14/2011 09:10PM by A B.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Initial setup of replication with large tables
1109
A B
August 14, 2011 09:09PM


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.