Created
February 14, 2015 19:20
-
-
Save pushrax/c47efd7b4b704f99bfce to your computer and use it in GitHub Desktop.
Create a MySQL dump to bootstrap a replication slave
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| DATE=`date +%Y-%m-%d.%H%M%S` | |
| echo "Starting MySQL dump for replication $DATE" | |
| mysqldump -u root -p --single-transaction --master-data --databases my_app --verbose | gzip -c > "mysql.master.$DATE.sql.gz" | |
| echo "Dump complete" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Obtains a global lock for a short amount of time at the start of the query to enforce consistent binlog coordinates, then runs without any locks due to
--single-transaction(InnoDB only).