MySQL二进制安装及部署

1.MySQL软件安装及部署

1.1 企业常用版本

MySQL 5.6；MySQL 5.6.36；MySQL 5.6.38；MySQL 5.6.40
MySQL 5.7；MySQL 5.7.18；MySQL 5.7.20；MySQL 5.7.24

1.2MySQL的安装方式

yum install -y mysql
二进制安装
源码包安装

1.3MySQL软件二进制安装部署

[root@db01 ~]#  mkdir /application /data/mysql/data -p

1.3.2创建MySQL用户

useradd mysql   #最好是虚拟用户

[root@db01 /application]# rz -E
rz waiting to receive.

1.3.4环境变量的设置

[root@db01 /application]# vim /etc/profile
 export PATH=/application/mysql/bin:$PATH
[root@db01 ~]# source /etc/profile

1.3.5解压软件，将文件重命名

[root@db01 /application]# tar xf mysql-8.0.16-linux-glibc2.12-x86_64.tar.xz
[root@db01 /application]# mv mysql-8.0.16-linux-glibc2.12-x86_64  mysql

1.3.6将软件相关目录进行授权

- [root@db01 /application]# chown -R mysql mysql /application/ /data/

1.3.7初始化系统数据

[root@db01 /application]# rpm -qa | grep  mariadb
[root@db01 /application]# yum remove -y mariadb-libs.x86_64
[root@db01 /application]# yum install libaio-devel -y    # 安装依赖包

[root@db01 ~]# mysqld --initialize-insecure --user=mysql --basedir=/application/mysql --datadir=/data/mysql/data

2019-08-13T09:09:07.379633Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-08-13T09:09:09.693324Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-08-13T09:09:09.927575Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-08-13T09:09:09.989539Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 02c26600-bdaa-11e9-aac5-000c29cdbdda.
2019-08-13T09:09:09.990627Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-08-13T09:09:09.991187Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.


[root@db01 ~]# ll /data/mysql/data/      ##文件如下证明初始化成功
total 110628
-rw-r----- 1 mysql mysql       56 Aug 13 17:09 auto.cnf
-rw-r----- 1 mysql mysql      419 Aug 13 17:09 ib_buffer_pool
-rw-r----- 1 mysql mysql 12582912 Aug 13 17:09 ibdata1
-rw-r----- 1 mysql mysql 50331648 Aug 13 17:09 ib_logfile0
-rw-r----- 1 mysql mysql 50331648 Aug 13 17:09 ib_logfile1
drwxr-x--- 2 mysql mysql     4096 Aug 13 17:09 mysql
drwxr-x--- 2 mysql mysql     8192 Aug 13 17:09 performance_schema
drwxr-x--- 2 mysql mysql     8192 Aug 13 17:09 sys

1.3.8编写my.cf文件

[root@db01 ~]# vim /etc/my.cnf
[root@db01 ~]# cat /etc/my.cnf 
[mysqld]                     #服务端
basedir=/application/mysql    #软件安装目录
datadir=/data/mysql/data     #数据库数据存放位置
user=mysql                   #mysql用户
socket=/tmp/mysql.sock       #socket文件存放位置
[mysql]                      #客户端 
socket=/tmp/mysql.sock       #客户端socket文件存放位置

1.3.9准备软件启动脚本
A.Centos6启动脚本

[root@db01 ~]#  cd /application/mysql/support-files/
[root@db01 /application/mysql/support-files]# ll
total 24
-rw-r--r-- 1 7161 31415   773 Apr 13 21:32 magic
-rwxr-xr-x 1 7161 31415  1061 Apr 13 22:10 mysqld_multi.server
-rwxr-xr-x 1 7161 31415   894 Apr 13 22:10 mysql-log-rotate
-rwxr-xr-x 1 7161 31415 10576 Apr 13 22:10 mysql.server
[root@db01 /application/mysql/support-files]# cp mysql.server /etc/init.d/mysqld
[root@db01 /etc]# /etc/init.d/mysqld  start   #启动MySQL
Starting MySQL.Logging to '/data/mysql/data/db01.err'.
. SUCCESS! 
[root@db01 /etc]# service mysqld start        #启动MySQL
Starting MySQL. SUCCESS!

B.Centos7启动脚本

root@db01 /etc/systemd/system]# cat /etc/systemd/system/mysqld.service 
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/application/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
[root@db01 /etc/systemd/system]# systemctl start mysqld.service

MySQL二进制安装及部署

1.MySQL软件安装及部署

推荐阅读更多精彩内容