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

The following content mainly brings you a brief analysis of mysql5.7 upgrading from the library to the main library. The knowledge mentioned here, which is slightly different from books, is summarized by professional and technical personnel in the process of contact with users, and has a certain value of experience sharing. I hope to bring help to the majority of readers.

CHANGE MASTER TOMASTER_HOST='10.10.30.34', MASTER_PORT=3306,MASTER_USER='slave',MASTER_PASSWORD='slave',MASTER_LOG_FILE='mysql-bin.000148',MASTER_LOG_POS=154; changed from database to main library stop slave;reset slave;reset master Change from the library to the previous master library (from the slave library to the master database) vim / etc/my.cnflog-bin=mysql-bin # and restart the database Master library opens binlog log master library operation: show master status master library operation: scp-r / var/lib/mysql/* 10.10.50.34:/var/lib/mysql/ slave library: chown-R mysql.mysql / var/lib/mysql/ slave library: systemctl restart mysqld CHANGE MASTER TOMASTER_HOST='172.16.1.51', MASTER_PORT=3306,MASTER_USER='rep',MASTER_PASSWORD='123456',MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=335 Enter data: start slave; intermediate error report: 1.IO process has been in connnecting slave user password error 2.show slave status; reported error Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file' solution: main library: flush logs Slave library: stop slave;CHANGE MASTER TO MASTER_LOG_FILE='mysqld-bin.000011',MASTER_LOG_POS=106;start slave

For the above brief analysis of the promotion of mysql5.7 from the library to the main database, if you have more information, you can continue to pay attention to the innovation of our industry. If you need professional solutions, you can contact the pre-sales and after-sales on the official website. I hope this article can bring you some knowledge updates.

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.