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

多实例

主从同步