无公网环境编译安装mysql5.7

1. 配置yum仓库,下载同系统版本一致的系统镜像,可以到国内各大镜像站下载, http://mirror.chpc.utah.edu/pub/vault.centos.org/7.4.1708/isos/x86_64/CentOS-7-x86_64-Everything-1708.iso

2. 将镜像上传到服务器,挂载镜像,mount CentOS-7-x86_64-Everything-1708.iso /centos7.4

3. 配置yum源,vim /etc/yum.repos.d/centos.repo
   i. name=centos-el7-tsinghua
   ii. baseurl=file:///centos7.4
   iii. enabled=1
   iv. gpgcheck=0
   v. keepcache = 0

4. yum clean all ; yum makecache

5. 准备工作,关闭selinux getenforce 0,安装依赖包, yum install gcc gcc-c++ ncurses ncurses-devel bison libgcrypt perl make cmake –y,创建mysql用户, useradd -s /sbin/nologin -M mysql
   mkdir –p /mysql/data chown –R mysql.mysql /mysql/data

6. 下载安装包并解压https://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz
   https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-boost-5.7.25.tar.gz
   tar xf boost_1_59_0.tar.gz; mv boost_1_59_0 /usr/local/boost
   tar xf mysql-boost-5.7.25.tar.gz; cd mysql-5.7.25/

7. 进行编译安装, cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/mysql/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_TCP_PORT=3306 -DMYSQL_USER=mysql -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DENABLE_DOWNLOADS=1 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/boost

编译安装配置选项详解
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
make &&make install
8. 配置环境变量并初始化vim /etc/profile.d/mysql.sh
export PATH=/usr/local/mysql/bin:$PATH
source /etc/profile.d/mysql.sh
mysql_install_db --defaults-file=/etc/my.cnf --user=mysql --datadir=/mysql/data/ --basedir=/usr/local/mysql
9. vim /etc/my.cnf
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
pid_file =/var/mysql/mysqld.pid
datadir = /mysql/data
skip-external-locking
key_buffer_size = 128M
max_allowed_packet = 1M
table_open_cache = 512
sort_buffer_size = 2M
net_buffer_length = 8K
read_buffer_size = 2M
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 32M
thread_cache_size = 64
query_cache_size = 64M
tmp_table_size = 64M
explicit_defaults_for_timestamp = true
#skip-networking
max_connections = 500
max_connect_errors = 100
open_files_limit = 65535
log-bin=mysql-bin
binlog_format=mixed
server-id = 1
expire_logs_days = 10
default_storage_engine = InnoDB
innodb_data_home_dir = /mysql/data
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /mysql/data
innodb_buffer_pool_size = 512M
innodb_log_file_size = 128M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 2M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout
10. 启动mysql mysqld_safe --defaults-file=/etc/my.cnf &
配置mysql的密码 mysql_secure_installation
11. 配置开机自启 cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
交给chkconfig 管理 chkconfig --add mysqld
查看是否配置成功 chkconfig –list

12. crontab –e

配置自动备份策略0 2 * * * /usr/local/mysql/bin/mysqldump -uuser -ppasswd -all > /backup/$(date “+%Y-%m-%d”).sql
每天晚上2:00做一次全备份

END