centos7安装mysql5.6

编译安装

1. 安装环境准备

yum install gcc gcc-c++ cmake ncurses-devel bison
      

1. 下载源码包

cd /data/tools
  wget         http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.40.tar.gz               
  tar xf mysql-5.6.40.tar.gz
      

3.安装

useradd -s /sbin/nologin mysql
cd mysql-5.6.40
  cmake -DMYSQL_USER=mysql -DCMAKE_INSTALL_PREFIX=/data/server/mysql5.6 -DINSTALL_DATADIR=/data/server/mysql5.6/data -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DDEFAULT_CHARSET=utf8  -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1
make
make install
      

4.初始化数据库

cd server/
ln -s mysql5.6/ mysql
chown -R mysql:mysql /data/server/mysql5.6/data
cp /data/server/mysql5.6/support-files/my-default.cnf /etc/my.cnf
      

5.配置环境变量

vim /etc/profile
  PATH=/data/server/mysql/bin/:$PATH
  source /etc/profile
  #配置文件
      

6.配置文件

vim /etc/my.cnf
   basedir=/data/server/mysql5.6
   datadir=/data/server/mysql5.6/data
      

7.配置启动

cp /data/server/mysql5.6/support-files/mysql.server /etc/init.d/mysqld
  chmod a+x /etc/init.d/mysqld
  service mysqld restart
      

8.更新密码

mysqladmin -uroot password '123456'
      

配置my.cnf文件

datadir = /data/server/mysql5.6/data
basedir=/data/server/mysql5.6
socket = /data/server/mysql5.6/data/mysql.sock      

skip-external-locking

max_allowed_packet = 512M

table_open_cache = 1024M

sort_buffer_size = 1024M

read_buffer_size = 1024M

read_rnd_buffer_size = 1024M

innodb_file_per_table =1

innodb_status_file =1

innodb_additional_mem_pool_size =512M

innodb_buffer_pool_size =6000M #最大内存的70%~80%

innodb_flush_method =O_DIRECT

innodb_support_xa =0

innodb_log_file_size =64M

innodb_log_buffer_size =32M

innodb_flush_log_at_trx_commit=2

thread_cache_size=6 #CPU核数*2

thread_concurrency=6 #CPU核数*2

query_cache_size=512M

join_buffer_size=128M

key_buffer=1024M

key_buffer_size=2048M

多实例

主从同步