summaryrefslogtreecommitdiff
path: root/scripts/mysqlhotcopy.sh
diff options
context:
space:
mode:
authorunknown <iggy@amd64.(none)>2008-03-07 15:45:40 -0500
committerunknown <iggy@amd64.(none)>2008-03-07 15:45:40 -0500
commit054237cd0bbad33fa9c25cea174be7be43973f53 (patch)
treeac455176eee23e0350fd9486fff967e20c0b9d79 /scripts/mysqlhotcopy.sh
parent1cddfc2f42afe1767388f1591648a45b211e778e (diff)
downloadmariadb-git-054237cd0bbad33fa9c25cea174be7be43973f53.tar.gz
Bug #27101 mysqlhotcopy --record_log_pos retrieves wrong slave parameters
- Make sure mysqlhotcopy doesn't create unrestorable slaves. scripts/mysqlhotcopy.sh: Bug #27101 mysqlhotcopy --record_log_pos retrieves wrong slave parameters - Record what's been executed by the slave, not what's been delivered.
Diffstat (limited to 'scripts/mysqlhotcopy.sh')
-rw-r--r--scripts/mysqlhotcopy.sh9
1 files changed, 5 insertions, 4 deletions
diff --git a/scripts/mysqlhotcopy.sh b/scripts/mysqlhotcopy.sh
index 8814e36b2fa..4819f512a65 100644
--- a/scripts/mysqlhotcopy.sh
+++ b/scripts/mysqlhotcopy.sh
@@ -733,7 +733,7 @@ sub record_log_pos {
= @{$row_hash}{ qw / Master_Host Log_File Pos / };
} else {
($master_host, $log_file, $log_pos )
- = @{$row_hash}{ qw / Master_Host Master_Log_File Read_Master_Log_Pos / };
+ = @{$row_hash}{ qw / Master_Host Relay_Master_Log_File Exec_Master_Log_Pos / };
}
my $hostname = hostname();
@@ -836,9 +836,10 @@ log-pos-table from the values returned from "show master status" and
log_file and log_pos columns, and establish the position in the binary
logs that any slaves of this host should adopt if initialised from
this dump. The slave status values are stored in master_host,
-master_log_file, and master_log_pos, and these are useful if the host
-performing the dump is a slave and other sibling slaves are to be
-initialised from this dump.
+master_log_file, and master_log_pos, corresponding to the coordinates
+of the next to the last event the slave has executed. The slave or its
+siblings can connect to the master next time and request replication
+starting from the recorded values.
The name of the log-pos table should be supplied in database.table format.
A sample log-pos table definition: