Checking replication is working

[Ayman Al-Aride]

Hi

I needed to find out how to test Mysql database's, we have two nodes a master and a slave, I want to run a scheduled task to update an entry into the database string in the master node, allow replication and then run another task on the slave node to check that string in the database is updated, if it fails I would like it to send an e-mail to me, I don’t know all of the command lines I can use this is what i have done so far A node works fine

Node A:

USE links_db;

Update test_database set time=curtime(), Date_modified=curdate() Where num=9;


Node B

USE links_db;


IF SELECT DateCheck FROM test_database = GETDATE()????????

BEGIN

Date correct stuff

END

ELSE

BEGIN

Date not correct stuff

END


E-mail to [e-mail]

END
….. Can anyone help?

Thanks