1、复制的介绍
[root@node1 ~]# groupadd mysql
[root@node1 ~]# useradd -g mysql mysql
[root@node1 ~]# tar -zxvf mysql-5.0.22.tar.gz
[root@node1 ~]# cd mysql-5.0.22
[root@node1 mysql-5.0.22]#make #编译
[root@node1 mysql-5.0.22]#make install
[root@node1 mysql-5.0.22]#./scripts/mysql_install_db
[root@node1 mysql-5.0.22]# cp support-files/my-medium.cnf /etc/my.cnf
7)copy mysql的启动脚本到资源目录
[root@node1 mysql-5.0.22]#cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
[root@node1 mysql-5.0.22]#chkconfig --level 235 mysqld on
9)更改目录属主
[root@node1 mysql-5.0.22]#chown -R mysql.mysql /var/lib/mysql
在 /etc/profile添加一行就 ,在运行mysql的时候就不用输入很长的路经了
export PATH=$PATH:/usr/local/mysql/bin
[root@node1 mysql-5.0.22]#service mysqld start
到这里mysql软件就按转完毕,node2上的mysql安装按照上面的就行了。
b、配置mysql的配置文件
1)进入mysql命令行,为slave用户添加同步专用权限
输入密码 ,就进入到mysql命令行中了,一般刚装好的没有密码。
[root@node1 ~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.22
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
mysql> GRANT REPLICATION SLAVE,REPLICATION CLIENT,RELOAD,SUPER ON *.* TO 'replication'@'192.168.1.2' IDENTIFIED BY '123456';
#给与从服务器用户replication的同步权限
mysql> Grant ALL PRIVILEGES ON *.* TO li@'%' IDENTIFIED BY '123456';
mysql>Flush privileges;
#刷新权限,使设置生效
[root@node1 ~]# mkdir /var/log/mysql
[root@node1 ~]# chown -R mysql.mysql /var/log/mysql
mysql> show slave status\G;
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.22
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
mysql> GRANT REPLICATION SLAVE,REPLICATION CLIENT,RELOAD,SUPER ON *.* TO 'replication'@'192.168.1.2' IDENTIFIED BY '123456';
#给与从服务器用户replication的同步权限
mysql> Grant ALL PRIVILEGES ON *.* TO li@'%' IDENTIFIED BY '123456';
mysql>Flush privileges;
#刷新权限,使设置生效
[root@node1 ~]#service mysqld restart
mysql> show master status;
#根据上面主服务器的show master status的结果,进行从服务器的二进制数据库记录回归,达到同步的效果
[root@node1 ~]#mysql
mysql>SHOW SLAVE STATUS\
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
mysql>SHOW SLAVE STATUS\
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
此处Slave_IO_Running ,Slave_SQL_Running 都应该是yes,表示从库的I/O,Slave_SQL线程都正确开启.表明数据库正在同步。