We currently have 3 MySQL Servers running;
the first which contains production data and is due to be retired
mysqld Ver 5.5.28-0ubuntu0.12.04.2 for debian-linux-gnu on x86_64 ((Ubuntu))
mysql> SHOW MASTER STATUS; Empty set (0.00 sec)
the second which contains out of date snapshot of production data and is to take over from the first.
mysqld Ver 5.5.28-0ubuntu0.12.04.3-log for debian-linux-gnu on x86_64 ((Ubuntu))
the third which is already a slave of the second server.
mysqld Ver 5.5.29-0ubuntu0.12.04.1 for debian-linux-gnu on x86_64 ((Ubuntu))
mysql> SHOW MASTER STATUS; Empty set (0.01 sec)
My question is would I go about setting up the following?:
First Server (master) -> Second Server (slave) -> Third Server (slave)
Tutorial links welcome! I tried to Google, but I'm sure I've gotten the wrong keywords
SHOW MASTER STATUS;
on all three DB Servers and tell me what you see.