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

I. Export the data of the main database

Mysqldump-uuser-ppassword-S / tmp/mysql.sock-- single-transaction-- master-data=2-- all-databases-- triggers-- routines-- events > / root/master_dump.sql

Second, create master-slave replication users in the master library

Mysql > grant replication slave on *. * to 'rep'@'%' identified by' rep'

Third, import the data file into the slave library

Mysql > source / root/master_dump.sql

Fourth, find the log application point

Less / root/master_dump.sql

And then execute from the library

Log number checked out by change master to MASTER_HOST=' main library IP',MASTER_USER='rep',MASTER_PASSWORD='rep',MASTER_LOG_FILE='', postition found by MASTER_LOG_POS=

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.