数据库教程:CentOS 7 安装Percona Server+Mysql

  uname -r  3.10.0-693.el7.x86_64  

  percona-server-5.6.29  

  /home/soft  

  groupadd mysql  useradd -r -g mysql mysql  

  mkdir /usr/local/mysql		#mysql安装目录  chown -r mysql:mysql /usr/local/mysql    mkdir /usr/local/mysql/dataconf		#数据库配置存放目录  chown -r mysql:mysql /usr/local/mysql/dataconf    mkdir /usr/local/mysql/sock		#运行mysql时mysql.sock存放目录  chown -r mysql:mysql /usr/local/mysql/sock      mkdir /var/log/mysql          #创建日志存放目录  touch /var/log/mysql/mysql.log  chown -r mysql:mysql /var/log/mysql/mysql.log      touch /usr/local/mysql/my.cnf    #创建mysql配置文件  

  yum install readline-devel git gcc gcc-c++ make cmake bison bison-devel ncurses-devel libaio-devel perl zlib1g-dev autoconf  

  cd /home/soft/  tar zxvf percona-server-5.6.29-76.2.tar.gz   cd percona-server-5.6.29-76.2    cmake -dcmake_install_prefix=/usr/local/mysql  #需要使用cmake进行安装，这里表示的是文件安装目录  -dsysconfdir=/usr/local/mysql          #存放配置文件的目录  -dmysql_datadir=/usr/local/mysql/dataconf     #存放数据库的目录  -dmysql_unix_addr=/usr/local/mysql/sock/mysqld.sock   #存放mysql.sock文件的目录  -dmysql_tcp_port=3306 -dwith_myisam_storage_engine=1   #配置端口  -dwith_innobase_storage_engine=1   -dwith_partition_storage_engine=1   -dextra_charsets=all   -ddefault_charset=utf8         #配置默认的字符编码格式  -ddefault_collation=utf8_general_ci   -denabled_local_infile=1   -dwith_editline=bundled   -dcmake_build_type=relwithdebinfo   -dbuild_config=mysql_release   -dfeature_set=community   -dwith_embedded_server=off  

  make -j 8    #大概需要30-40分钟左右。如果报错，请使用make clean , rm -rf cmakecache.txt  make install  

  cat /usr/local/mysql/my.cnf    [mysqld]  # disabling symbolic-links is recommended to prevent assorted security risks  symbolic-links=0  explicit_defaults_for_timestamp=true     federated  # settings user and group are ignored when systemd is used.  # if you need to run mysqld under a different user or group,  # customize your systemd unit file for mariadb according to the  # instructions in https://fedoraproject.org/wiki/systemd  basedir=/usr/local/mysql  datadir=/usr/local/mysql/dataconf  port=3306  socket=/usr/local/mysql/sock/mysql.sock  symbolic-links=0  character_set_server=utf8  pid-file=/usr/local/mysql/mysql.pid  skip-grant-tables      [mysqld_safe]  log-error=/var/log/mysql/mysql.log  pid-file=/usr/local/mysql/mysql.pid  socket=/usr/local/mysql/sock/mysql.sock      [client]   socket=/usr/local/mysql/mysql.sock     [mysql.server]   user=mysql   basedir=/usr/local/mysql   socket=/usr/local/mysql/sock/mysql.sock    [mysql]  socket=/usr/local/mysql/sock/mysql.sock  

  chown -r mysql:mysql /usr/local/mysql/bin  chown -r mysql:mysql /usr/local/mysql/mysql.pid  

  /usr/local/mysql/scripts/mysql_install_db --defaults-file=/usr/local/mysql/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/dataconf --user=mysql  

  为了能直接调用mysql命令，需要配置环境变量  vi /etc/profile  在/etc/profile文件末尾添加  export path=/usr/local/mysql/bin:$path  使环境变量立即生效  source /etc/profile  

  cp /home/soft/percona-server-5.6.29-76.2/support-files/mysql.server /etc/init.d/mysql  chmod +x /etc/init.d/mysql  chkconfig mysql on  service mysql start/stop  

  rpm -ivh percona-server-shared-compat-5.5.35-rel33.0.611.rhel6.x86_64.rpm  rpm -ivh percona-server-shared-55-5.5.35-rel33.0.611.rhel6.x86_64.rpm  rpm -ivh percona-server-devel-55-5.5.35-rel33.0.611.rhel6.x86_64.rpm  rpm -ivh percona-server-client-55-5.5.35-rel33.0.611.rhel6.x86_64.rpm