Shulou(Shulou.com)06/01 Report--

Create a replication user:

CREATE USER 'repl'@'192.168.6.%' IDENTIFIED BY' 123'

GRANT REPLICATION SLAVE ON *. * TO 'repl'@'192.168.6.%'

FLUSH PRIVILEGES

The following is the contents of the dump file, which means that the repository is restored to this point.

Show warnings; saw a warning about password security.

Take a look at show slave status again

Then we turn on slave.

Start slave

Of course, for indicators that monitor the status of slave, see Slave_IO_Running,Slave_SQL_Running (IO thread and SQL thread)

Http://blog.itpub.net/29990276/viewspace-2055728/ from the Perspective of replication principle

Look at the thread from the library:

This is the IO thread.

Then look at the threads on the main library:

This is the dump thread on the main library, sending logs.

The purpose of relay.log is to write the binlog received by IO to relay.log, which is then slowly consumed by SQL threads to solve a problem of delayed application. And the relay will be cleared and released after playback. Of course, you can also specify that it should not be deleted, and MHA had better not purge.

Show variables like 'relay_log_purge'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.