MySQL Master copy Build

MySQL Download: https://downloads.mysql.com/archives/community/

1. Configure MY.CNF to turn some options on or off according to the master/slave library Environment

datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.socksymbolic-links=0#event_scheduler=1log-error=/var/log/ mysqld.logpid-file=/var/run/mysqld/mysqld.pidserver_id=11log_bin=mysql-binbinlog_format=rowlog_slave_updates= 1expire_logs_days=10log_slave_updates=1relay_log=/var/log/relay.logslow_query_log=onlong_query_time=1slow_ Query_log_file=/var/log/slow-query.logskip_name_resolve=1max_connections=1000open_files_limit=65535table_open_ Cache=5120innodb_file_per_table=1innodb_flush_log_at_trx_commit=2sync_binlog=1max_connect_errors=200default_ Password_lifetime=0join_buffer_size = 1msort_buffer_size = 2mmax_allowed_packet = 32minnodb_open_files = 3000innodb_ buffer_pool_size=4ginnodb_log_buffer_size=16m# Read-only=1

2, the main library authorized users

GRANT REPLICATION slave,replication CLIENT on * * to ' repl ' @ '% ' identified by ' xxxxxx ';

3, the main library is fully prepared

Mysqldump-uroot-p--single-transaction-r--default-character-set=utf8--triggers--events--hex-blob--flush-logs --master-data=2-a >all.sql

4, prepare the library operation, import data

Show Processlist;show Databases;source/tmp/all.sql

Cat All.sql

--Change MASTER to master_log_file= ' mysql-bin.000001 ', master_log_pos=154;

5. Change Maser to the main library

Change Master to master_host= ' xxxxx ', master_user= ' repl ', master_password= ' xxxx ', master_port=3306, master_log_file= ' Mysql-bin.000002 ', Master_log_pos=154;start slave;show slave status;

Additional parameters from the library:

1, Slave_exec_mode

2, Max_allowd_packet

3, Slave_compressed_protocal

4, Read-only

5, Slave_net_timeout

6 、--slave-skip-errors=1062,1053

7, Skip-slave-start

MySQL Master copy Build