0

How could I retrieve last position in master's log-bin? For example when I write CHANGE MASTER TO... I can't see master's status so I don't know the master-file-pos...

Dedyshka
  • 421
  • 3
  • 10
  • 20

2 Answers2

1

On your master machine in mysql type:

SHOW MASTER STATUS;

mysql> SHOW MASTER STATUS;
+---------------+----------+--------------+------------------+
| File          | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---------------+----------+--------------+------------------+
| mysql-bin.003 | 73       | test         | manual,mysql     |
+---------------+----------+--------------+------------------+
metalfight - user868766
  • 2,722
  • 1
  • 16
  • 20
  • Well. I'm trying to do this: http://www.onlamp.com/2006/04/20/advanced-mysql-replication.html When procedure calls "CHANGE MASTER TO..." it doesn't know right position of the new master's master-log-pos. – Dedyshka Jul 25 '13 at 13:28
0

Well, I am not sure what you exactly want to achive, but do a SHOW SLAVE STATUS; and look there for Exec_Master_Log_Pos, this will give you the last position until which the slave SQL thread has executed the events from the masters binary log.

For additional information refer to the docs you can find here: SHOW SLAVE STATUS Syntax

Flo Doe
  • 5,197
  • 2
  • 19
  • 18