Unable to reproduce the same. After I ran pt-heartbeat on slave, I would able to see server-id in heartbeat table. Here, 1 is master server-id and 101 is slave server-id.
nilnandan@Dell-XPS:~$ pt-heartbeat -D test --check h=localhost,u=root,p=msandbox,S=/tmp/mysql_sandbox20083.sock 105.00 nilnandan@Dell-XPS:~$ mysql> select * from heartbeat; +---------------------+-----------+------+----------+-----------------------+---------------------+ | ts | server_id | file | position | relay_master_log_file | exec_master_log_pos | +---------------------+-----------+------+----------+-----------------------+---------------------+ | 2014-09-15 13:06:26 | 1 | NULL | NULL | NULL | NULL | | 2014-09-15 13:06:26 | 101 | NULL | NULL | NULL | NULL | +---------------------+-----------+------+----------+-----------------------+---------------------+ 2 rows in set (0.01 sec)
Can you please explain what exactly you want us to check? testcase with steps will be helpful.
Unable to reproduce the same. After I ran pt-heartbeat on slave, I would able to see server-id in heartbeat table.
Here, 1 is master server-id and 101 is slave server-id.
nilnandan@ Dell-XPS: ~$ pt-heartbeat -D test --check h=localhost, u=root, p=msandbox, S=/tmp/ mysql_sandbox20 083.sock Dell-XPS: ~$ ------- ------- -+----- ------+ ------+ ------- ---+--- ------- ------- ------+ ------- ------- ------- + log_file | exec_master_log_pos | ------- ------- -+----- ------+ ------+ ------- ---+--- ------- ------- ------+ ------- ------- ------- + ------- ------- -+----- ------+ ------+ ------- ---+--- ------- ------- ------+ ------- ------- ------- +
105.00
nilnandan@
mysql> select * from heartbeat;
+------
| ts | server_id | file | position | relay_master_
+------
| 2014-09-15 13:06:26 | 1 | NULL | NULL | NULL | NULL |
| 2014-09-15 13:06:26 | 101 | NULL | NULL | NULL | NULL |
+------
2 rows in set (0.01 sec)
Can you please explain what exactly you want us to check? testcase with steps will be helpful.