mysql繁衍。。percona 二进制数据库的安装配置。

一、解压

tar xvf /root/Percona-Server-5.5.13-rel20.4-138.Linux.x86_64.tar.gz -C /usr/src/
mv /usr/src/Percona-Server-5.5.13-rel20.4-138.Linux.x86_64/ /usr/local/mysql

二、创建mysql系统用户

groupadd mysql
useradd -g mysql mysql

三、初始化

[root@slave mysql]# ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/

四、授权

[root@slave mysql]# chown mysql:mysql ./* -R

五、拷贝配置文件

[root@slave mysql]# cp support-files/my-medium.cnf /etc/my.cnf
[root@slave mysql]# vim /etc/my.cnf

  1. [mysqld]  
  2. port            = 3306 
  3. socket          = /tmp/mysql.sock            ----------在这行下面添加以下内容-----------------  
  4.  
  5. datadir         = /usr/local/mysql/data  
  6. user            = mysql 
  7. basedir         = /usr/local/mysql  
  8. pid-file        = /usr/local/mysql/mysql.pid  
  9. log_bin_trust_function_creators=1 
  10. character_set_server = utf8 

六、拷贝启动脚本并授权

[root@slave mysql]# cp support-files/mysql.server /etc/init.d/mysqld
[root@slave mysql]# chmod 755 /etc/init.d/mysqld

[root@slave mysql]# vim /etc/init.d/mysqld   （修改路径)

  1. mysqld_pid_file_path=  
  2. if test -z "$basedir"  
  3. then  
  4.   basedir=/usr/local/mysql  
  5.   bindir=/usr/local/mysql/bin  
  6.   if test -z "$datadir"  
  7.   then  
  8.     datadir=/usr/local/mysql/data  
  9.   fi  
  10.   sbindir=/usr/local/mysql/bin  
  11.   libexecdir=/usr/local/mysql/bin  
  12. else  
  13.   bindir="$basedir/bin" 
  14.   if test -z "$datadir"  
  15.   then  
  16.     datadir="$basedir/data" 
  17.   fi  
  18.   sbindir="$basedir/sbin" 
  19.   libexecdir="$basedir/libexec" 
  20. fi  

七、启动

[root@slave mysql]# /etc/init.d/mysqld start     ----------启动服务
[root@slave mysql]# ./bin/mysql                  ----------进入数据库