MySQL Forums :: Replication :: 1 Master -> Many slaves, need to update dump file


Advanced Search

1 Master -> Many slaves, need to update dump file
Posted by: Brian Wright ()
Date: July 10, 2012 03:55PM

We have a MySQL setup with 1 Master server and many slaves for distributed statistics gathering (That I inherited and am definitely not a MySQL expert). We occasionally deploy new slaves to keep up with the demand. When the replication was first setup, there was the initial dump file created with mysqldump, then the SHOW MASTER STATUS was used to get the binlog file and position to configure the slaves with. The disk space is starting to fill up with the binlog files (there is currently no automatic maintenance to purge them). Also deploying new servers takes 10-12 hours for replication to catch up, so I want to create a new dump file to shorten this time.

I need some assistance with regards to purging the binlog files, creating a new master dump file, and not breaking the existing slave replication. The current slaves are using the binlog file name and position from the initial dump file. If I lock the tables to do a new dump, then purge the existing binlog files, will the current slaves have any replication issues? What is the best practices for doing something like this?

Thanks in advance!

-Brian

Options: ReplyQuote


Subject Views Written By Posted
1 Master -> Many slaves, need to update dump file 1746 Brian Wright 07/10/2012 03:55PM
Re: 1 Master -> Many slaves, need to update dump file 838 Irfan Ali 07/11/2012 03:20PM
Re: 1 Master -> Many slaves, need to update dump file 889 Rick James 07/11/2012 04:16PM
Re: 1 Master -> Many slaves, need to update dump file 812 Brian Wright 07/12/2012 11:09AM


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.