Skip to content

Instantly share code, notes, and snippets.

@pushrax

pushrax/gist:c47efd7b4b704f99bfce

Created February 14, 2015 19:20
Show Gist options
  • Save pushrax/c47efd7b4b704f99bfce to your computer and use it in GitHub Desktop.
Save pushrax/c47efd7b4b704f99bfce to your computer and use it in GitHub Desktop.
Download ZIP
Create a MySQL dump to bootstrap a replication slave
Raw
gistfile1.sh
#!/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"
@pushrax
Copy link
Author

pushrax commented Feb 14, 2015

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).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment