msyql 多实例安装

1)yum多实例安装

1.编辑yum源

[mariadb]
name = MariaDB
baseurl = http://mirrors.ustc.edu.cn/mariadb/yum/10.2/centos7-amd64/
gpgkey=http://mirrors.ustc.edu.cn/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1

[root@magedu ~]#sudo yum install MariaDB-server MariaDB-client

2.创建所需文件夹

[root@Centos7 ~]#mkdir /mysql/{3306,3307,3308}/{data,bin,log,socket,pid,etc} -pv
[root@Centos7 ~]#tree /mysql

3.安装库 （二进制提前创建用户）

[root@Centos7 ~]#mysql_install_db --datadir=/mysql/3306/data/ --user=mysql
[root@Centos7 ~]#mysql_install_db --datadir=/mysql/3307/data/ --user=mysql
[root@Centos7 ~]#tree /mysql

4.赋予权限

[root@Centos7 ~]#chown -R mysql.mysql /mysql/

5.修改配置文件 （二进制安装需要找到 /usr/local/mysql/support-files/my-huge.cnf ）

[root@Centos7 ~]#cp /etc/my.cnf  /mysql/3306/etc/

[root@Centos7 ~]#vim /mysql/3306/etc/my.cnf
				[mysqld]
				port=3306
				datadir=/mysql/3306/data
				socket=/mysql/3306/socket/mysql.sock
				symbolic-links=0
				[mysqld_safe]
				log-error=/mysql/3306/log/mariadb.log
				pid-file=/mysql/3306/pid/mariadb.pid 

[root@Centos7 ~]#cp  /mysql/3306/etc/my.cnf /mysql/3307/etc/my.cnf
				[mysqld]
				port=3307
				datadir=/mysql/3307/data
				socket=/mysql/3307/socket/mysql.sock

				symbolic-links=0

				[mysqld_safe]
				log-error=/mysql/3307/log/mariadb.log
				pid-file=/mysql/3307/pid/mariadb.pid 

6.修改启动文件
因为是yum安装可以临时启动查看 mysqld_safe所在地方

[root@Centos7 ~]#systemctl start mariadb
[root@Centos7 ~]#ps aux 
[root@Centos7 ~]#systemctl stop mariadb
[root@Centos7 ~]#chmod +x /mysql/3306/bin/mysqld
[root@Centos7 ~]#vim /mysql/3306/bin/mysqld


#!/bin/bash

port=3306
mysql_user="root"
mysql_pwd="centos"
cmd_path="/usr/bin"   --看下mysqld_safe在哪个路径二进制在就是解压文件夹那里/usr/local/mysql/bin
mysql_basedir="/mysql"                                                                       
mysql_sock="${mysql_basedir}/${port}/socket/mysql.sock"

function_start_mysql()
{
    if [ ! -e "$mysql_sock" ];then
      printf "Starting MySQL...\n"
      ${cmd_path}/mysqld_safe --defaults-file=${mysql_basedir}/${port}/etc/my.cnf  &> /dev/null  &
    else
      printf "MySQL is running...\n"
      exit
    fi
}


function_stop_mysql()
{
    if [ ! -e "$mysql_sock" ];then
       printf "MySQL is stopped...\n"
       exit
    else
       printf "Stoping MySQL...\n"
       ${cmd_path}/mysqladmin -u ${mysql_user} -p${mysql_pwd} -S ${mysql_sock} shutdown
   fi
}

7.操作

启动

[root@Centos7 ~]#/mysql/3306/bin/mysqld start
[root@Centos7 ~]#ss -ntl

进入

[root@Centos7 ~]#mysql -S /mysql/3306/socket/mysql.sock
MariaDB [(none)]> status --可以查看状态

–修改口令后者是在my。cnf里面密码清空关闭的时候就不需要输入密码了

[root@Centos7 ~]# mysqladmin -S /mysql/3306/socket/mysql.sock password 1234  

–所改的密码必须和my.cnf里面的密码一样才可以关闭

[root@Centos7 ~]# mysqladmin -S /mysql/3306/socket/mysql.sock -p1234 password centos

[root@Centos7 ~]#/mysql/3306/bin/mysqld stop

Stoping MySQL…
the end