X-Git-Url: https://git.stderr.nl/gitweb?a=blobdiff_plain;f=handlers%2Fmysql.in;h=db4159d412a87bc111af4c0dd97fd0184e311df1;hb=refs%2Fheads%2Fvsfixes;hp=39c1fb9c2729819b5d80f86873d910f0f808917c;hpb=cde6d7f672aa62f5e6f42be343b0299f2e3d4cbf;p=matthijs%2Fupstream%2Fbackupninja.git diff --git a/handlers/mysql.in b/handlers/mysql.in index 39c1fb9..db4159d 100644 --- a/handlers/mysql.in +++ b/handlers/mysql.in @@ -13,6 +13,7 @@ getconf sqldump no getconf sqldumpoptions "--lock-tables --complete-insert --add-drop-table --quick --quote-names" getconf compress yes getconf vsname +getconf vsnames # authentication: getconf user @@ -25,23 +26,30 @@ getconf configfile /etc/mysql/debian.cnf # In the former case, check that $vsname exists and is running. local usevserver=no local vroot -if [ $vservers_are_available = yes ]; then - if [ -n "$vsname" ]; then - # does it exist ? - if ! vservers_exist "$vsname" ; then - fatal "The vserver given in vsname ($vsname) does not exist." - fi - # is it running ? - vservers_running $vsname || fatal "The vserver $vsname is not running." - # everything ok - info "Using vserver '$vsname'." - usevserver=yes - vroot="$VROOTDIR/$vsname" + +if [ -n "$vsname" ]; then + if [ -z "$vsnames" ]; then + warning "Using deprecated 'vsname' configuration variable" + vsnames="$vsname" + info "Prepending '%v' to backupdir to emulate legacy behaviour" + backupdir="%v/$backupdir" + else + warning "Ignoring (deprecated) vsname configuration variable, since vsnames is given" + fi +fi + +if [ $vservers_are_available = yes -a -n "$vsnames" ]; then + if [ "$vsnames" = all ]; then + vsnames="$found_vservers" else - info "No vserver name specified, actions will be performed on the host." + if ! vservers_exist "$vsnames" ; then + fatal "At least one of the vservers listed in vsnames ($vsnames) does not exist." + fi fi + info "Using vservers '$vsnames'" + usevserver=yes else - [ -z "$vsname" ] || warning 'vservers support disabled in backupninja.conf, vsname configuration line will be ignored' + [ -z "$vsnames" ] || warning 'vservers support disabled in backupninja.conf, vsnames configuration line will be ignored' fi ## Prepare ignore part of the command @@ -49,278 +57,255 @@ fi ignore='' for i in $ignores $nodata; do - ignore="$ignore --ignore-table=$i" + ignore="$ignore --ignore-table=$i" done - -# create backup dirs, $vroot will be empty if no vsname was specified -# and we will instead proceed to operate on the host -[ -d $vroot$backupdir ] || mkdir -p $vroot$backupdir -[ -d $vroot$backupdir ] || fatal "Backup directory '$vroot$backupdir'" -hotdir="$backupdir/hotcopy" -dumpdir="$backupdir/sqldump" - -if [ $usevserver = yes ] -then - [ "$sqldump" == "no" -o -d $vroot$dumpdir ] || $VSERVER $vsname exec mkdir -p $dumpdir - [ "$hotcopy" == "no" -o -d $vroot$hotdir ] || $VSERVER $vsname exec mkdir -p $hotdir -else - [ "$sqldump" == "no" -o -d $dumpdir ] || mkdir -p $dumpdir - [ "$hotcopy" == "no" -o -d $hotdir ] || mkdir -p $hotdir -fi -####################################################################### -## AUTHENTICATION +function make_backup() { + vsname="$1" + if [ -z "$vsname" ]; then + info "Running on host" + vroot="" + vexec="" + else + if ! vservers_running "$vsname"; then + error "vserver $vsname is not running!" + return 1 + fi + info "Running on vserver $vsname" + vroot="$VROOTDIR/$vsname" + vexec="$VSERVER $vsname exec" + fi -# -# one of three authentication methods: -# 1. setting the user, so that /home/user/.my.cnf is used. -# 2. specifying the user and password in the handler config, -# which generates a temporary .my.cnf in /root/.my.cnf -# 3. specify the config file with --defaults-extra-file -# (this option DOESN'T WORK WITH MYSQLHOTCOPY) -# + interpolated=`interpolate "$backupdir" "$vsname"` -# create .my.cnf -# only if dbusername and dbpassword specified. -# we create a tmp file because we don't want to -# specify the password on the command line. - -defaultsfile="" - -if [ "$dbusername" != "" -a "$dbpassword" != "" ] -then - if [ $usevserver = yes ] - then - vhome=`$VSERVER $vsname exec getent passwd "root" | @AWK@ -F: '{print $6}'` - home="$vroot$vhome" - else - home=`getent passwd "root" | @AWK@ -F: '{print $6}'` - fi - - [ -d $home ] || fatal "Can't find root's home directory ($home)." - - mycnf="$home/.my.cnf" - - if [ -f $mycnf ] - then - # rename temporarily - tmpcnf="$home/my.cnf.disable" - debug "mv $mycnf $tmpcnf" - mv $mycnf $tmpcnf - fi - - oldmask=`umask` - umask 077 - cat > $mycnf < $mycnf <&1` - code=$? - if [ "$code" == "0" ] - then - debug $output - info "Successfully finished hotcopy of all mysql databases" - else - warning $output - warning "Failed to hotcopy all mysql databases" - fi - fi - else - for db in $databases - do - if [ $usevserver = yes ] - then - execstr="$VSERVER $vsname exec $MYSQLHOTCOPY -h $dbhost --allowold $db $hotdir" - else - execstr="$MYSQLHOTCOPY -h $dbhost --allowold $db $hotdir" - fi - debug 'su $user -c \"$execstr\"' - if [ ! $test ] - then - output=`su $user -c "$execstr" 2>&1` - code=$? - if [ "$code" == "0" ] - then - debug $output - info "Successfully finished hotcopy of mysql database $db" - else - warning $output - warning "Failed to hotcopy mysql database $db" - fi - fi - done - fi -fi + debug "User home set to: $userhome" + [ -f $userhome/.my.cnf ] || fatal "Can't find config file in $userhome/.my.cnf" + defaultsfile="--defaults-extra-file=$vuserhome/.my.cnf" + debug "using $defaultsfile" + fi + + ####################################################################### + ## HOT COPY -########################################################################## -## SQL DUMP - -if [ "$sqldump" == "yes" ] -then - info "Initializing SQL dump method" - if [ "$databases" == "all" ] - then - if [ $usevserver = yes ] - then - debug 'echo show databases | $VSERVER $vsname exec su $user -c \"$MYSQL $defaultsfile\" | grep -v Database' - databases=`echo 'show databases' | $VSERVER $vsname exec su $user -c "$MYSQL $defaultsfile" | grep -v Database` - if [ $? -ne 0 ] - then - fatal "Authentication problem, maybe user/password is wrong or mysqld is not running?" - fi - else - databases=$(su $user -c "$MYSQL $defaultsfile -N -B -e 'show databases'" | sed 's/|//g;/\+----/d') - if [ $? -ne 0 ] - then - fatal "Authentication problem, maybe user/password is wrong or mysqld is not running?" - fi - fi - fi - - for db in $databases - do - DUMP_BASE="$MYSQLDUMP $defaultsfile $sqldumpoptions" - - # Dumping structure and data - DUMP="$DUMP_BASE $ignore $db" - - # If requested, dump only the table structure for this database - if echo "$nodata" | grep -E '(^|[[:space:]])'"$db\." >/dev/null + if [ "$hotcopy" == "yes" ] + then + if starts_with "$hotdir" "$vroot"; then + info "Initializing hotcopy method" + vhotdir=`strip_prefix "$hotdir" "$vroot"` + if [ "$databases" == "all" ] + then + info "dbhost: $dbhost" + execstr="$vexec $MYSQLHOTCOPY -h $dbhost --quiet --allowold --regexp /.\*/./.\*/ $vhotdir" + + debug "su $user -c \"$execstr\"" + if [ ! $test ] + then + output=`su $user -c "$execstr" 2>&1` + code=$? + if [ "$code" == "0" ] + then + debug $output + info "Successfully finished hotcopy of all mysql databases" + else + warning $output + warning "Failed to hotcopy all mysql databases" + fi + fi + else + for db in $databases + do + execstr="$vexec $MYSQLHOTCOPY -h $dbhost --allowold $db $vhotdir" + + debug 'su $user -c \"$execstr\"' + if [ ! $test ] + then + output=`su $user -c "$execstr" 2>&1` + code=$? + if [ "$code" == "0" ] + then + debug $output + info "Successfully finished hotcopy of mysql database $db" + else + warning $output + warning "Failed to hotcopy mysql database $db" + fi + fi + done + fi + else + error "hotcopy method can only be used when the backupdir ($hotdir) is within the vserver ($vroot)" + fi + fi + + ########################################################################## + ## SQL DUMP + + if [ "$sqldump" == "yes" ] + then + info "Initializing SQL dump method" + if [ "$databases" == "all" ] + then + debug "$vexec su $user -c \"$MYSQL $defaultsfile -N -B -e 'show databases'\" | sed 's/|//g;/\+----/d'" + # -N removes the column title and -B should remove the ASCII table borders, but doesn't always so we use sed to make sure. + databases=`$vexec su $user -c "$MYSQL $defaultsfile -N -B -e 'show databases'" | sed 's/|//g;/\+----/d'` + if [ $? -ne 0 ] then - # Get the structure of the tables, without data - DUMP_STRUCT="$DUMP_BASE --no-data $db" - for qualified_table in $nodata - do - table=$( expr match "$qualified_table" "$db\.\([^\w]*\)" ) - DUMP_STRUCT="$DUMP_STRUCT $table" - done - DUMP="( $DUMP; $DUMP_STRUCT )" + fatal "Authentication problem, maybe user/password is wrong or mysqld is not running?" fi - if [ $usevserver = yes ] - then + fi + + for db in $databases + do + DUMP_BASE="$MYSQLDUMP $defaultsfile $sqldumpoptions" + + # Dumping structure and data + DUMP="$DUMP_BASE $ignore $db" + + # If requested, dump only the table structure for this database + if echo "$nodata" | grep -E '(^|[[:space:]])'"$db\." >/dev/null + then + # Get the structure of the tables, without data + DUMP_STRUCT="$DUMP_BASE --no-data $db" + for qualified_table in $nodata + do + table=$( expr match "$qualified_table" "$db\.\([^\w]*\)" ) + DUMP_STRUCT="$DUMP_STRUCT $table" + done + DUMP="( $DUMP; $DUMP_STRUCT )" + fi # Test to make sure mysqld is running, if it is not sqldump will not work - $VSERVER $vsname exec su $user -c "$MYSQLADMIN $defaultsfile ping" + $vexec su $user -c "$MYSQLADMIN $defaultsfile ping" if [ $? -ne 0 ]; then fatal "Either you have an authentication problem, or mysqld doesn't appear to be running!" fi if [ "$compress" == "yes" ]; then - execstr="$VSERVER $vsname exec $DUMP | $GZIP > $vroot$dumpdir/${db}.sql.gz" + execstr="$vexec $DUMP | $GZIP > $dumpdir/${db}.sql.gz" else - execstr="$VSERVER $vsname exec $DUMP -r $vroot$dumpdir/${db}.sql" - fi - else - # Test to make sure mysqld is running, if it is not sqldump will not work - su $user -c "$MYSQLADMIN $defaultsfile ping" - if [ $? -ne 0 ]; then - fatal "Either you have an authentication problem, or mysqld doesn't appear to be running!" + execstr="$vexec $DUMP -r $dumpdir/${db}.sql" fi - if [ "$compress" == "yes" ]; then - execstr="$DUMP | $GZIP > $dumpdir/${db}.sql.gz" - else - execstr="$DUMP -r $dumpdir/${db}.sql" + + debug "su $user -c \"$execstr\"" + if [ ! $test ] + then + output=`su $user -c "$execstr" 2>&1` + code=$? + if [ "$code" == "0" ] + then + debug $output + info "Successfully finished dump of mysql database $db" + else + warning $output + warning "Failed to dump mysql databases $db" + fi fi - fi - debug "su $user -c \"$execstr\"" - if [ ! $test ] - then - output=`su $user -c "$execstr" 2>&1` - code=$? - if [ "$code" == "0" ] - then - debug $output - info "Successfully finished dump of mysql database $db" - else - warning $output - warning "Failed to dump mysql databases $db" - fi - fi - done -fi + done + fi -# clean up tmp config file -if [ "$dbusername" != "" -a "$dbpassword" != "" ] -then - ## clean up tmp config file - debug "rm $mycnf" - rm $mycnf - if [ -f "$tmpcnf" ] - then - debug "mv $tmpcnf $mycnf" - mv $tmpcnf $mycnf - fi + # clean up tmp config file + if [ "$dbusername" != "" -a "$dbpassword" != "" ] + then + ## clean up tmp config file + debug "rm $mycnf" + rm $mycnf + if [ -f "$tmpcnf" ] + then + debug "mv $tmpcnf $mycnf" + mv $tmpcnf $mycnf + fi + fi +} + +if [ $usevserver = yes ]; then + for vserver in $vsnames; do + make_backup "$vserver" + done +else + make_backup "" fi return 0