Is the master logging to the binary log?
SHOW MASTER STATUS. If it is, Position will be non-zero. If not, verify that you are running the master with the log-bin and server-id options. • Is the slave running? Use SHOW SLAVE STATUS to check whether the Slave_IO_Running and Slave_SQL_Running values are both Yes. If not, verify the options that were used when starting the slave server. • If the slave is running, did it establish a connection to the master? Use SHOW PROCESSLIST, find the I/O and SQL threads and check their State column to see how they display. See section 6.3 Replication Implementation Details. If the I/O thread state says Connecting to master, verify the privileges for the replication user on the master, master hostname, your DNS setup, whether the master is actually running, whether it is reachable from the slave. • If the slave was running before but now has stopped, the reason usually is that some statement that succeeded on the master failed on the slave. This should never happen if you have taken a proper s
Related Questions
- Logging into "Manage My Services" Use Passport York, Yorks computing services method of authentication to log into "Manage My Services", or any other CNS application, such as ClassList, Dial-up usage, or YorkNet.. First time using Passport York?
- Why, when I enable logging and configure devices in the CLI and then save the file, does the save file not save the log?
- Why do I get the following error when logging into Remedy: Unable to successfully log in to any server?