MySQL Replication
MySQL replication involves maintaining a separate server which is a continuous copy of a primary, master MySQL server. These statements and functions are related to those activities.
CHANGE MASTER TOThis MySQL statement changes the settings on a slave server related to the master server and replication. |
SHOW BINARY LOGSThis MySQL statement displays a list of binary logs created by the master MySQL server in the filesystem directory. |
LOAD DATA FROM MASTERThis MySQL statement has been deprecated and will be removed from future releases of MySQL. |
SHOW BINLOG EVENTSThis MySQL statement displays the events in a binary log file. |
LOAD TABLE...FROM MASTERThis MySQL statement has been deprecated and will be removed from future releases of MySQL since it has many problems. |
SHOW MASTER LOGSThis MySQL statement displays a list of binary logs created by the master MySQL server in the filesystem directory. |
MASTER_POS_WAIT( )This function is useful to synchronize MySQL master and slave server logging. |
SHOW MASTER STATUSThis MySQL statement displays information on the status of the binary log file that is being used currently on the master MySQL server. |
PURGE MASTER LOGSThis MySQL statement deletes the binary logs from a master server. |
SHOW SLAVE HOSTSThis MySQL statement displays a list of slave servers for the master server. |
RESET MASTERThis MySQL statement deletes all the binary log files on the master server. |
SHOW SLAVE STATUSThis MySQL statement displays information on the slave thread. |
RESET SLAVEUse this MySQL statement within or after the RESET MASTER statement that sets the binary logging index back to 1. |
START SLAVEUse this MySQL statement to start a slave server. |
SET GLOBAL SQL_SLAVE_SKIP_COUNTERThis MySQL statement skips the given number of events from the master. |
STOP SLAVEThis MySQL statement stops the slave server threads. |
SET SQL_LOG_BINThis MySQL statement enables or disables binary logging of SQL statements for the current connection. |
Need Math Examples
Although we did well in math classes all through school, we have very little experience with the Math Functions of MySQL very little. As a result, we don't have very good examples for them. If you work in science or engineering and have some ideas for easy to understand examples that we can add, please tell us.
MySQL Replication
Whether you’re new to MySQL replication or have been using it for some time, you will find this new book useful. It will help you actually to understand MySQL replication so you can keep it running. It’s especially useful when replication stops and you can’t get it started again.
