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软件二进制安装部署
- 1.3.1创建所需目录
[root@db01 ~]# mkdir /application /data/mysql/data -p
- 1.3.2创建MySQL用户
useradd mysql #最好是虚拟用户
- 1.3.3上传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