美文网首页mysqlmysql基础笔记
老男孩-MySQL 5.6 ,5.7 ,8.0在安装部署的异同

老男孩-MySQL 5.6 ,5.7 ,8.0在安装部署的异同

作者: MySQL_oldguo | 来源:发表于2019-06-03 14:11 被阅读331次

    如果您对数据库感兴趣，可以添加 DBA解决方案QQ群：855439640

    5.6.44 二进制包安装部署

    解压到以下目录

    [root@oldboy ~]# ll /usr/local/mysql56/
drwxr-xr-x.  2 root root   4096 Jun  3 11:20 bin
-rw-r--r--.  1 7161 31415 17987 Mar 15 15:38 COPYING
drwxr-xr-x.  3 root root     18 Jun  3 11:19 data
drwxr-xr-x.  2 root root     55 Jun  3 11:19 docs
drwxr-xr-x.  3 root root   4096 Jun  3 11:19 include
drwxr-xr-x.  3 root root   4096 Jun  3 11:19 lib
drwxr-xr-x.  4 root root     30 Jun  3 11:19 man
drwxr-xr-x. 10 root root   4096 Jun  3 11:19 mysql-test
-rw-r--r--.  1 7161 31415  2496 Mar 15 15:38 README
drwxr-xr-x.  2 root root     30 Jun  3 11:19 scripts
drwxr-xr-x. 28 root root   4096 Jun  3 11:20 share
drwxr-xr-x.  4 root root   4096 Jun  3 11:19 sql-bench
drwxr-xr-x.  2 root root    136 Jun  3 11:19 support-files
[root@oldboy ~]#

    修改配置文件

    [root@oldboy ~]# cat >/data/mysql56/my.cnf  <<EOF
[mysqld]
basedir=/usr/local/mysql56
datadir=/data/mysql56/data
socket=/tmp/mysql56.sock
user=mysql
log_error=/tmp/mysql56.log
skip_name_resolve
log_bin=/data/mysql56/mysql-bin
port=5606
server_id=5606
EOF

    准备启动脚本

    cat >/etc/systemd/system/mysqld56.service<<EOF
[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=/usr/local/mysql56/bin/mysqld --defaults-file=/data/mysql56/my.cnf
LimitNOFILE = 5000
EOF

    初始化数据

    [root@oldboy ~]# mv /etc/my.cnf  /etc/my.cnf.aa
[root@oldboy ~]# /usr/local/mysql56/scripts/mysql_install_db --user=mysql --datadir=/data/mysql56/data --basedir=/usr/local/mysql56

    启动数据库

    chown -R mysql.mysql /data
[root@oldboy tmp]# systemctl start mysqld56
[root@oldboy tmp]# /usr/local/mysql56/bin/mysql -S /tmp/mysql56.sock 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.44-log MySQL Community Server (GPL)

    5.7.26 二进制包安装部署

    解压到以下目录

    [root@oldboy ~]# ll /usr/local/mysql57/
total 36
drwxr-xr-x.  2 root root   4096 Jun  3 11:22 bin
-rw-r--r--.  1 7161 31415 17987 Apr 13 21:32 COPYING
drwxr-xr-x.  2 root root     55 Jun  3 11:22 docs
drwxr-xr-x.  3 root root   4096 Jun  3 11:21 include
drwxr-xr-x.  5 root root    230 Jun  3 11:22 lib
drwxr-xr-x.  4 root root     30 Jun  3 11:22 man
-rw-r--r--.  1 7161 31415  2478 Apr 13 21:32 README
drwxr-xr-x. 28 root root   4096 Jun  3 11:22 share
drwxr-xr-x.  2 root root     90 Jun  3 11:22 support-files

    修改配置文件

    [root@oldboy ~]# cat > /data/mysql57/my.cnf <<EOF
[mysqld]
basedir=/usr/local/mysql57
datadir=/data/mysql57/data
socket=/tmp/mysql57.sock
user=mysql
log_error=/tmp/mysql57.log
skip_name_resolve
log_bin=/data/mysql57/mysql-bin
port=5706
server_id=5706
EOF

    准备启动脚本

    cat >/etc/systemd/system/mysqld57.service<<EOF
[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=/usr/local/mysql57/bin/mysqld --defaults-file=/data/mysql57/my.cnf
LimitNOFILE = 5000
EOF

    初始化数据

    [root@oldboy ~]# /usr/local/mysql57/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql57/ --datadir=/data/mysql57/data

    启动数据库

    chown -R mysql.mysql /data
[root@oldboy tmp]# systemctl start mysqld57
[root@oldboy tmp]# /usr/local/mysql57/bin/mysql -S /tmp/mysql57.sock

    8.0.16 二进制包安装部署

    解压到以下目录

    [root@oldboy ~]# ll /usr/local/mysql80/
drwxr-xr-x.  2 7161 31415   4096 Apr 14 07:06 bin
drwxr-xr-x.  2 7161 31415     86 Apr 14 07:06 docs
drwxr-xr-x.  3 7161 31415    261 Apr 14 07:06 include
drwxr-xr-x.  6 7161 31415   4096 Apr 14 07:06 lib
-rw-r--r--.  1 7161 31415 335809 Apr 13 19:46 LICENSE
-rw-r--r--.  1 7161 31415 101807 Apr 13 19:46 LICENSE.router
drwxr-xr-x.  4 7161 31415     30 Apr 14 07:06 man
-rw-r--r--.  1 7161 31415    687 Apr 13 19:46 README
-rw-r--r--.  1 7161 31415    700 Apr 13 19:46 README.router
drwxrwxr-x.  2 7161 31415      6 Apr 14 07:06 run
drwxr-xr-x. 28 7161 31415   4096 Apr 14 07:06 share
drwxr-xr-x.  2 7161 31415     77 Apr 14 07:06 support-files
drwxr-xr-x.  3 7161 31415     17 Apr 14 07:06 var
[root@oldboy ~]#

    修改配置文件

    [root@oldboy ~]# cat > /data/mysql80/my.cnf <<EOF
[mysqld]
basedir=/usr/local/mysql80
datadir=/data/mysql80/data
socket=/tmp/mysql80.sock
user=mysql
log_error=/tmp/mysql80.log
skip_name_resolve
log_bin=/data/mysql80/mysql-bin
port=8006
server_id=8006
EOF

    准备启动脚本

    cat >/etc/systemd/system/mysqld80.service<<EOF
[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=/usr/local/mysql80/bin/mysqld --defaults-file=/data/mysql80/my.cnf
LimitNOFILE = 5000
EOF

    初始化数据

    [root@oldboy ~]# /usr/local/mysql80/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql80  --datadir=/data/mysql80/data

    启动数据库

    chown -R mysql.mysql /data
[root@oldboy tmp]# systemctl start mysqld80
[root@oldboy tmp]# /usr/local/mysql80/bin/mysql -S /tmp/mysql80.sock

    相关文章

      网友评论

        本文标题：老男孩-MySQL 5.6 ,5.7 ,8.0在安装部署的异同

        本文链接：https://www.haomeiwen.com/subject/ipaqxctx.html

        延伸阅读

        深度阅读

        • 您也可以注册成为美文阅读网的作者，发表您的原创作品、分享您的心情！

        栏目导航

        热点阅读

        mysql

        mysql基础笔记

        关于我们|服务条款|联系我们|老男孩-MySQL 5.6 ,5.7 ,8.0在安装部署的异同|投稿指南|网站地图|RSS订阅|排版工具|手机版

        提供经典美文摘抄,优美散文欣赏,现代诗歌精选,短篇小说,心情随笔,表白情书范文,故事会在线阅读欣赏

        Copyright © 2014-2023 Haomeiwen.com All Rights Reserved. 好美文阅读网 版权所有

        备案信息：桂公网安备 45052102000051号 · 桂ICP备13007215号-3

        本站所收录作品、热点评论等信息部分来源互联网，目的只是为了系统归纳学习和传递资讯

        所有作品版权归原创作者所有，与本站立场无关，如不慎侵犯了你的权益，请联系我们告知，我们将做删除处理！