MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

Re: Getting consistent backup of slave that has foreign keys
Posted by: Rick James
Date: March 06, 2016 02:58PM

Another approach to building a new slave:

1. Stop mysqld on existing slave
2. Install MySQL on new slave (no data yet). Create my.cnf, with unique server_id.
3. Copy the entire mysql tree to the new slave. (Not including my.cnf)
4. Start both slaves -- they will both "catch up" on replication from the point of step 1.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Getting consistent backup of slave that has foreign keys
1851
Alexander Spitzer
February 29, 2016 07:33AM
Re: Getting consistent backup of slave that has foreign keys
916
Peter Brawley
February 29, 2016 10:21AM
Re: Getting consistent backup of slave that has foreign keys
892
Alexander Spitzer
February 29, 2016 02:13PM
Re: Getting consistent backup of slave that has foreign keys
834
Peter Brawley
February 29, 2016 06:26PM
Re: Getting consistent backup of slave that has foreign keys
874
Alexander Spitzer
February 29, 2016 06:31PM
Re: Getting consistent backup of slave that has foreign keys
866
Peter Brawley
March 01, 2016 12:02PM
Re: Getting consistent backup of slave that has foreign keys
841
Alexander Spitzer
March 01, 2016 04:42PM
Re: Getting consistent backup of slave that has foreign keys
917
Peter Brawley
March 01, 2016 06:15PM
Re: Getting consistent backup of slave that has foreign keys
913
Alexander Spitzer
March 01, 2016 06:45PM
Re: Getting consistent backup of slave that has foreign keys
909
Peter Brawley
March 01, 2016 08:15PM
Re: Getting consistent backup of slave that has foreign keys
909
Alexander Spitzer
March 01, 2016 08:24PM
Re: Getting consistent backup of slave that has foreign keys
846
Peter Brawley
March 02, 2016 12:38PM
Re: Getting consistent backup of slave that has foreign keys
822
Alexander Spitzer
March 02, 2016 03:12PM
Re: Getting consistent backup of slave that has foreign keys
877
Peter Brawley
March 02, 2016 04:36PM
Re: Getting consistent backup of slave that has foreign keys
829
Alexander Spitzer
March 06, 2016 09:01AM
Re: Getting consistent backup of slave that has foreign keys
859
Rick James
March 06, 2016 02:58PM
Re: Getting consistent backup of slave that has foreign keys
858
Alexander Spitzer
March 08, 2016 06:37AM
Re: Getting consistent backup of slave that has foreign keys
792
Alexander Spitzer
March 08, 2016 06:39AM
Re: Getting consistent backup of slave that has foreign keys
789
Peter Brawley
March 08, 2016 03:52PM
Re: Getting consistent backup of slave that has foreign keys
854
Rick James
March 09, 2016 06:56PM
Re: Getting consistent backup of slave that has foreign keys
883
Peter Brawley
March 09, 2016 08:41PM


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.