一 . 环境准备
先上拓扑图
aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAYIAAAFeCAIAAAAHZI+KAAAN2ElEQVR4nO3b0WHbuBYE0NSVglxPqnEzKcbvY/MSWZZh0QQ5Q/Kcv6xlBbgDjGQ5++MNIOpHegHA1akhIEwNAWFqCAhTQ0CYGgLC1BAQpoaAMDUEhKkhIEwNAWFqCAhTQ0CYGgLC1BAQpoaAMDUEhKkhIEwNAWFqCAhTQ0CYGgLC1BAQpoaAMDUEhKkhIEwNAWFqCAhTQ0CYGgLC1BAQpoaAMDUEhKkhIEwNAWFqCAhTQ0CYGgLC1BAQpoaAMDUEhKkhIEwNAWFqCAhTQ0CYGgLCumro96+fP279/PX7/iGvLzdff3l98O0Pvgko1ldD/1rk96+f70rlv5a5rZ7Xlz9fvi2nzhr6rCLfNe/7Wr390l3hwpk019Cfi/jnBr6+PNEwTz1oZ4OKfH25/S+vLzd98/kf4Gy6a+jt9eXP9fvwlccaa+j/vl7bTev+3fjT38y3rPkcYPBOlkW6a+jvn2/fFo08dVs//HD34M3GrMcsWtu/7X9s3fteYo41nwN89k6WpZpr6CbaJ98MPf2m4eZxnzbcrMc8vbabZ/jwZM/2MAut/hzgwfeV++xjypt3fR++OPraBH019PAN8uwa+vvI4emZ9Zin1nb3evruj3/mcoxTfiyrPwf47HkaDT6m/P3r59/jdf+e8Pbk3n9tjr4aerzFJ/tl8evXM29QJjzmq7U9DPfm0Ly8+qFsG6s/B/j3bcfJ56tr8m4391vbonCPUkNP/vB9yBp65gXmEC+2R7T6c4C7b1v+txd+THnbPB8LdoNflxymhh79SPv718+PvwF/ckJ//qov/8YZjxmt7bkT/PvXz+O81h7K6s8B1v6Y0vcx5ftv/ziHDV4SD1RD/3/AZ2fm3pM53H8m+e4f68x4zIO/8/Y/fbLOv7+R2erHcd7e3lZ/DjAjm5KPKf/doQ+flX2sockvil01tI/Xl/ej/veO9t+AZz3mbVCRj75w/wPCo08TmWjN5wDTfktf8/nA7dN8+uvC078bgp19+3OAmf9SqKyG3m7/mdoFPxuCnX3zc4Av3sl+ZwnxjynvH3HzGfXD3yVOpIYgqeNjyteXmwfd/97tw78bmv7bEjUEMS0fU95/7b5nbr+4xW9s1RAQpoaAMDUEhKkhIEwNAWFqCAhTQ0CYGgLC1BAQpoaAsOoa+vg/D5ZLDwwOqfrmpFtlsfTAWCZ9XhZLD2wr1RtLh75YemAskz4vi6UHtpXqjaVDXyw9MJZJn5fF0gPbSvXG0qEvlh4Yy6TPy2LpgW2lemP9GfSvkIG92mOa9MC2Ur2x/gz6V8hAf3z9K5yiemP9GfSvkIH++PpXOEX1xvoz6F8hA/3x9a9wiuqN9WfQv0IG+uPrX+EU1Rvrz6B/hQz0x9e/wimqN9afQf8KGeiPr3+FU1RvrD+D/hUy0B9f/wqnqN5Yfwb9K2SgP77+FU5RvbH+DPpXyEB/fP0rnKJ6Y/0Z9K+Qgf74+lc4RfXG+jPoXyED/fH1r3CK6o31Z9C/Qgb64+tf4RTVG+vPoH+FDPTH17/CKao31p9B/woZ6I+vf4VTVG+sP4P+FTLQH1//Cqeo3lh/Bv0rZKA/vv4VTlG9sf4M+lfIQH98/Suconpj/Rn0r5CB/vj6VzhF9cb6M+hfIQP98fWvcIrqjfVn0L9CBvrj61/hFNUb68+gf4UM9MfXv8IpqjfWn0H/Chnoj69/hVNUb6w/g/4VMtAfX/8Kp6jeWH8G/StkoD++/hVOUb2x/gz6V8hAf3z9K5yiemP9GfSvkIH++PpXOEX1xvoz6F8hA/3x9a9wiuqN9WfQv0IG+uPrX+EU1Rvrz6B/hQz0x9e/wimqN9afQf8KGeiPr3+FU1RvrD+D/hUy0B9f/wqnqN5Yfwb9K2SgP77+FU5RvbH+DPpXyEB/fP0rnKJ6Y/0Z9K+Qgf74+lc4RfXGfhxNemAs0x9f/wqnqN7YXu0xTXpgLJM+L4ulB7aVPTaWzu5gdkiE/6SjXiw9sK2ooTo7JHIy6cQOJh3XA2qozg6JnEw6sYNJx/WAGqqzQyInk07sYNJxPaCG6uyQyMmkEzuYdFwPBGpoh7/xWMxnpb3u70mk43pADeWZz0oGONY/HzWUZz4rGeBY/3zUUJ75rGSAY/3zUUN55rOSAY71z0cN5ZnPSgY41j8fNZRnPisZ4Fj/fNRQnvmsZIBj/fNRQ3nms5IBjvXPRw3lmc9KBjjWPx81lGc+KxngWP981FCe+axkgGP981FDeeazkgGO9c9HDeWZz0oGONY/HzWUZz4rGeBY/3zUUJ75rGSAY/3zUUN55rOSAY71z0cN5ZnPSgY41j8fNZRnPisZ4Fj/fNRQnvmsZIBj/fNRQ3nms5IBjvXPRw3lmc9KBjjWPx81lGc+KxngWP981FCe+axkgGP981FDeeazkgGO9c9HDeWZz0oGONY/HzWUZz4rGeBY/3zUUJ75rGSAY/3zCdQQYzskcjIGONY/HzVUZ4dETiad2MGk43pADdXZIZGTSSd2MOm4HlBDdXZI5GTSiR1MOq4H1FCdHRI5mXRiB5OO64HGNe2gPxieF7nMx5WO64HGNe2gPxgiHIyIiw76EC8R7M+piLjuoB047nhxSrnuoJ057jgPKZeetWPHX16Wgi49ayePv5yEoKuPWxPx5hikXX3czh9vjkGacTuCV+cAxJm4U3h1DkCcib+9OYgXJvoGhv725ixemOgbGPofjuM1Cb2Buf/jRF6N154S5v6PQ3k14i5h9O84l9fhVaeH0b/jaF6HoHuY/j2n8wq83lQx/XsO6BWIuIoAHnBGz80rTRsBPOCYnptw28jgMSf1rLzGFJLBYw7rWYm1kBg+5byej1eXTmL4lCN7PgLtJIkRTXQm0qwliREH90ykWUsSX3B2z0GOzYTxBcf3HOTYTBhfc4JPQILN5PEUh/jQvJCUk8dTnONDk105kTzLUT4oLyH9RPIsp/mgpNZPKgs40IfjxeMQpLKAM3048joEwSzjWB+Il42jEMwyTvaBSOooZLOYw30IXjAORDaLOd+HIKMDEc93OOLlvFQci3i+wykvJ51jkdA3aaJaojkcCX2Ts15LLocjpO/TRIWEckRC+j4nvpBQjkhIqzj0VcRxUHJaxbmvIo6DktNajn4PQRyUqCZw+ht4PTguUU3gAjQQwXFJaw53IMsrwaFJaw7XIMvwD01g07gJKV4Djk5g07gMKcZ+dDKbyX3Yn/Y/AZnN5Ersz8BPQGyTuRV70vvnILbJXIw9GfU5SG4+d2MfGv80JDef67EPQz4N4W1CE23NhM9EeJtwSbZmwmcivK24J9sx25OR31Zcle2Y7cnIb0NuyxZM9XxEuC0XZjo1dD4i3JY7M515no8UN+faTKTWT0mKm3NzJjLJUxLkHmZdno+NVm7iDB9uf+7zkyLIPcy6P9v3xmSbjnHukxMky51MuUJ7tcc02w1w7pOTJcudTLlF2/fGZNsNcOIzEyfO/ay/SHu1xzQbjW7iM9NAnPtZf5f6r+I+NTTraSkh0V2pofXP2blx1pDorlbeqP7buEMNTXlOqgh1b2uaqP9CTl+ht0JXINS9qaHsE1JIrgHfbqL+Ozl3hd4KXYRcA9TQ956tc8usJ9eM712w/js5cYU66DpEm6GGlj5V536ZQrQx37hm/ddyuxqatUIKSTdJDT35PJ2bZRbpJi29bP03c6MamrhCCgk4TA19+SSdO2UiAYctunL9l3OLGpq7QgrJOE8NDZ6hc5vMJeO85y9e//2cXkPTV0ghMVdQQw+/vXOPTCfmCk9ev/4rOreGtlghhSTdQg15K3RZkm7xzCXsv6UTa2ijFVJI2EWuXEPeCl2ZsIt8eRX7L+qsGtpuhRSSd5dxE/Xf1e+t0Fuhi5N3FzXUuS82JfI6gybqv67fWKG3Qoi8jhraepG0EXmjz25m/3VdukIdxJsaqqWGuA6pl3p4P/tv7Moa2mGFFBJ8r9PXkLdC/EfwvT7e0v5Lu6aG9lkhhWRf7cQ1dIjtsA/ZV7tODe22QgqJv90pa+gQe2E34m93hRrac4UUcgIOYNBE5Z7czs7zpI0TcCT798hKz+xi5xlSyCEIiDTCcaXjYnMyDkjf64NJx8XmZByQvtcHk46Lzck4IH2vDyYdF5uTcUD6Xh9MOi42J+MA12zMfK5GxgGu2Zj5XI2MA1yzMfO5GhkHuGZj5nM1Mg5wzcbM52pkHOCajZnP1cg4wDUbM5+rkXGAazZmPlcj4wDXbMx8rkbGAa7ZmPlcjYwDXLMx87kaGQe4ZmPmczUyDnDNxsznamQc4JqNmc/VyDjANRszn6uRcYBrNmY+VyPjANdszHyuRsYBrtmY+VyNjANcszHzuRoZB7hmY+ZzNTIOcM3GzOdqZBzgmo2Zz9XIOMA1GzOfq5FxgGs2Zj5XI+MA12zMfK5GxgGu2Zj5XI2MA1yzMfO5GhkHuGZj5nM1Mg74wRLpuNicjAPS9/pg0nGxORkHpO/1waTjYnMyDkjf64NJx8XmZByQvtcHk46LzckYCFNDQJgaAsLUEBCmhoAwNQSEqSEgTA0BYWoICFNDQJgaAsLUEBCmhoAwNQSEqSEgTA0BYWoICFNDQJgaAsLUEBCmhoAwNQSEqSEgTA0BYWoICFNDQJgaAsLUEBCmhoAwNQSEqSEgTA0BYWoICFNDQJgaAsLUEBCmhoAwNQSEqSEgTA0BYWoICFNDQJgaAsLUEBCmhoAwNQSE/Q/Ieme7G0my5wAAAABJRU5ErkJggg==" alt="" />
两个虚拟机 129和130.CentOS 6.3 安装mysql 版本5.1 .yum 确保安装配置一样.
yum -y install mysql mysql-devel mysql-server
service mysqld start
二 环境.
实验环境 service iptables stop || setenforce 0
三 主从配置
vi /etc/my.cnf
主服务器
log-bin
server-id=
从服务器
log-bin
server-id=
主服务器上
grant replication slave on *.* to 'testsync'@'*' identified by ''
创建账号给从服务器用.
** use mysql; select * from user='testsync' 能看到账号建立.这一步一般不会有问题.
mysql> show master status\G
*************************** . row ***************************
File: mysqld-bin.
Position:
Binlog_Do_DB:
Binlog_Ignore_DB:
row in set (0.00 sec)
记录信息,从服务器会用到
从服务器上
change master to master_host = '192.168.137.129',master_user = 'testsync',master_password = '',
2 master_log_file = 'mysqld-bin.000001',master_log_pos = ;
启动 slave start; 查看信息
mysql> show slave status\G
*************************** . row ***************************
Slave_IO_State:
Master_Host: 192.168.137.129
Master_User: testsync
Master_Port:
Connect_Retry:
Master_Log_File: mysqld-bin.
Read_Master_Log_Pos:
Relay_Log_File: mysqld-relay-bin.
Relay_Log_Pos:
Relay_Master_Log_File: mysqld-bin.
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno:
Last_Error:
Skip_Counter:
Exec_Master_Log_Pos:
Relay_Log_Space:
Until_Condition: None
Until_Log_File:
Until_Log_Pos:
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno:
Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).
Last_SQL_Errno:
Last_SQL_Error:
row in set (0.00 sec)
IO yes ,sql yes .其实主从配置还是很简单的.
** server-id 必须有区别
server 之间网络可达,之间3306端口可达
log-bin 打开, log-position 一致. 主从服务器版本,初始数据信息一致.
done . that's all .
may tomorrow a clear morning.
本站博客皆为原创,转载请标记下 小三爷.多谢~~!