快速设置Mysql 单向主从复制

amwdnuff

快速设置Mysql 单向主从复制


1:环境
系统：RHEL4.7    Mysql-5.1.34
hostname                    IP
Master.server      192.168.76.131
Slave.server        192.168.76.132

2:编译安装Mysql
#groupadd mysql
#useradd -g mysql mysql
#tar zxvf mysql-5.1.34.tar.tar
#cd mysql-5.1.34
#./configure --prefix=/usr/local/mysql --localstatedir=/db/mysql --sysconfdir=/etc --without-debug --enable-assembler --enable-thread-safe-client --enable-profiling --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-charset=utf8 --with-collation=utf8_general_ci --with-extra-charsets=utf8,gbk --with-pthread --without-ndb-debug --with-mysqld-user=mysql --without-embedded-server --with-unix-socket-path=/usr/local/mysql/sock/mysql.sock
#make && make install

#   cp support-files/my-huge.cnf /etc/my.cnf    //huge.cnf   高性能模板
#vi /etc/my.cnf   添加如下值
datadir =   /db/mysql
skip-name-resolv
table-cache = 4096

#mkdir -p /db/mysql
#chown mysql.mysql /db/mysql -R
#./scripts/mysql_install_db --user=mysql --datadir=/db/mysql/
#cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
#chmod +x /etc/rc.d/init.d/mysqld
#chkconfig --level 235 mysqld on
#chown -R root.mysql /usr/local/mysql
//设置环境变量
在 /etc/profile添加一行就 ，在运行mysql的时候就不用输入很长的路经了
export PATH=$PATH:/usr/local/mysql/bin
#mysqladmin -u root password YourPASSWD
#service mysqld start
//以上步骤在2台机器上都要操作一遍，这样初始化环境就搭建好了

===========================================
设置主从
1:在Master.server上设置 此服务器为主复制服务器。


# mysql –uroot –pYourPASSWD
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.1.34-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


mysql> GRANT REPLICATION SLAVE,REPLICATION CLIENT,RELOAD,SUPER ON *.* TO 'replication'@'192.168.76.132' IDENTIFIED BY '111111';
#给与从服务器（192.168.76.132）用户replication的同步权限

mysql>Flush privileges;
#刷新权限，使设置生效
mysql>\q   \\退出
#vi /etc/my.cnf    设置如下参数
log-bin=mysql-bin          //启动二进制日志系统
binlog-do-db=db2           //二进制需要同步的数据库名
server-id = 1                  //本机数据库ID 标示为主

binlog-ignore-db=mysql   //避免同步mysql用户配置，以免不必要的麻烦

#mysql –uroot –pYourPASSWD
mysql>create dabatase db2;
mysql>use db2;
mysql>create table test;

mysql>CREATE TABLE test (a INT NOT NULL AUTO_INCREMENT,PRIMARY KEY (a)) TYPE=MyISAM;