One way to do this would be to issue a 'stop slave;' on the slave
you are taking a backup from just before the backup starts. Then
issue a 'show slave status\G' to get the master log file and
position. You can use this to setup the new slave properly.
ok, thanks, I was thinking it'd be a
One way to do this would be to issue a 'stop slave;' on the slave
you are taking a backup from just before the backup starts. Then
issue a 'show slave status\G' to get the master log file and
position. You can use this to setup the new slave properly.
ok, thanks, I was thinking it'd be
One way to do this would be to issue a 'stop slave;' on the slave
you are taking a backup from just before the backup starts. Then
issue a 'show slave status\G' to get the master log file and
position. You can use this to setup the new slave properly.
ok, thanks, I was thinking it'd be
MAS! wrote:
btw, I have to get the Master_Log_File and Read_Master_Log_Pos or
Relay_Master_Log_File and Exec_Master_Log_Pos to start the new slave
correctly !?
If the Master_Log_File and Exec_Master_Log_Pos are not equivalent,
you'll want to note the Exec_Master_Log_Pos value as that is the
Are the values of these variables all accessible via the command: show
variables?
Josh Miller wrote:
MAS! wrote:
btw, I have to get the Master_Log_File and Read_Master_Log_Pos or
Relay_Master_Log_File and Exec_Master_Log_Pos to start the new slave
correctly !?
If the Master_Log_File and
Lawrence Sorrillo wrote:
Are the values of these variables all accessible via the command: show
variables?
If the Master_Log_File and Exec_Master_Log_Pos are not equivalent,
you'll want to note the Exec_Master_Log_Pos value as that is the value
which determines where in the binary logs
I have a master-slave replication that works well (thank you MySQL's
team) :D
each night I make a backup from my slave; this is my crontab line:
mysqldump --opt -Q -u root --master-data -pxyz mydb /var/
mydb_backup.sql
even that works well
I'd like to use that backup to setup a new slave
MAS! wrote:
I'd like to use that backup to setup a new slave (from the same (and
unique) master); the problem is I don't know how set-up this new slave,
since I don't know the right master binary-log num and position; in the
backup I have the slave's binary-log/pos and not the master ones :(