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

four virtual machines

For master-slave configuration, please consult the MYSQL read-write separation reference document before, which will not be repeated here.

Detailed description amoeba profile writing:

During the experiment, in order to test the internal operation process of the service, when the slave server is closed and then opened again, Slave_SQL_Running: No will be found.

At this time, you need to delete the/var/lib/mysql/master.info authentication information file, re-change master to authentication, and then open slave!

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.