MySQL主从异步复制.pdfVIP

MySQL 主从异步复制 修杰_JIANG 目标： 实现MySQL 主从复制，达到实时备份的目的 系统概况： 系统：CentOS；内核版本：2.6.18-194.el5 MySQL: 5.1.54 网络地址： master：01 slave：02 一、安装MySQL 二、配置 三、验证、测试 一、安装mysql(主从相同) #useradd mysql -s /sbin/nologin #tar zxvf mysql-5.1.54.tar.gz #cd mysql-5.1.54 #./configure --prefix=/usr/local/mysql --localstatedir=/opt/data --with-extra-charsets=utf8,gb2312,gbk --with-pthread --enable-thread-safe-client #make #make install #cp support-files/f /etc/f #cd /usr/local/mysql #chgrp -R mysql . #/usr/local/mysql/bin/mysql_install_db --user=mysql # chown -R mysql:mysql /opt/data #/usr/local/mysql/bin/mysqladmin -u root password sairl #echo /usr/local/mysql/bin/mysqld_safe --user=mysql /etc/rc.local #echo export PATH=$PATH:/usr/local/mysql/bin /etc/profile #source /etc/profile 二、配置 1）、修改slav 服务器的server-id （master 服务器不变） 56 # required unique id between 1 and 2^32 - 1 57 # defaults to 1 if master-host is not set 58 # but will not function as a master if omitted 59 server-id = 10 60 61 # Replication Slave (comment out master section to use this) 2）、授权(在master 服务器上操作) mysql GRANT REPLICATION SLAVE ON *.* - TO backup@02 IDENTIFIED BY testpwd; Query OK, 0 rows affected (0.00 sec) mysql show master status; //主数据库状态 +++++ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +++++ | mysql-bin.000003 | 409 | | | +++++ 3)、配置slave 服务器 mysql change master to - master_host=01, - master_user=backup, - master_password=testpwd, - master_log_file=mysql-bin.000003, - master_log_pos=409; Query OK, 0 rows affected (0.00 sec) mysql start slave; Query OK, 0 rows affected (0.00 sec) 查看一下同步状态 mysql show slave status\G *************************** 1