mysql多实例部署

mysql多实例部署

1.下载二进制格式的mysql软件包

[root@localhost ~]# cd /usr/src/
[root@localhost src]# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.42-el7-x86_64.tar.gz

2.配置用户和组并解压二进制程序至/usr/local下

// 创建用户和组
[root@localhost src]# groupadd -r -g 306 mysql
[root@localhost src]# useradd -r -M -s /sbin/nologin -g 306 -u 306 mysql
[root@localhost src]# id mysql
uid=306(mysql) gid=306(mysql) groups=306(mysql)

// 解压软件至/usr/local/
[root@localhost src]# tar xf mysql-5.7.42-el7-x86_64.tar.gz -C /usr/local/
[root@localhost src]# ls
debug  kernels  mysql-5.7.42-el7-x86_64.tar.gz 

// 创建软链接
[root@localhost src]# ln -s /usr/local/mysql-5.7.42-el7-x86_64/ /usr/local/mysql

// 修改目录/usr/local/mysql的属主属组
[root@localhost src]# chown -R mysql.mysql /usr/local/mysql
[root@localhost src]# ll /usr/local/mysql -d
lrwxrwxrwx. 1 mysql mysql 35 Sep  5 18:27 /usr/local/mysql -> /usr/local/mysql-5.7.42-el7-x86_64/

// 配置环境变量
[root@localhost src]# echo 'export PATH=/usr/local/mysql/bin:$PATH' >> /etc/profile
[root@localhost src]# source /etc/profile
[root@localhost src]# echo $PATH
/usr/local/mysql/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin

3.创建各实例数据存放的目录

[root@localhost src]# mkdir -p /opt/data/{3306,3307,3308}
[root@localhost src]# chown -R mysql.mysql /opt/data/
[root@localhost src]# ll /opt/data/
total 0
drwxr-xr-x. 2 mysql mysql 6 Sep  5 18:27 3306
drwxr-xr-x. 2 mysql mysql 6 Sep  5 18:27 3307

4.初始化各实例 --initialize-insecure 不安全的初始化

[root@localhost src]# mysqld --initialize-insecure --datadir=/opt/data/3306 --user=mysql
[root@localhost src]# mysqld --initialize-insecure --datadir=/opt/data/3307 --user=mysql
[root@localhost src]# mysqld --initialize-insecure --datadir=/opt/data/3308 --user=mysql

5.配置配置文件/etc/my.cnf

[root@localhost src]# vi /etc/my.cnf
[root@localhost src]# cat /etc/my.cnf 
[mysqld_multi]
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin

[mysqld3306]
datadir = /opt/data/3306
port = 3306
socket = /tmp/mysql3306.sock
pid-file = /opt/data/3306/mysql_3306.pid
log-error=/var/log/3306.log
character_set_server=utf8

[mysqld3307]
datadir = /opt/data/3307
port = 3307
socket = /tmp/mysql3307.sock
pid-file = /opt/data/3307/mysql_3307.pid
log-error=/var/log/3307.log
character_set_server=utf8

[mysqld3308]
datadir = /opt/data/3308
port = 3308
socket = /tmp/mysql3308.sock
pid-file = /opt/data/3308/mysql_3308.pid
log-error=/var/log/3308.log
character_set_server=utf8

6.利用mysqld_multi配置 安装perl

缺少库文件libncurses.so.5 安装ncurses-compat-libs

[root@localhost src]# yum -y install perl
[root@localhost src]# yum -y install ncurses-compat-libs

7.启动各实例

[root@localhost src]# mysqld_multi start 3306
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = (unset),
        LC_ALL = (unset),
        LANG = "zh_CN.UTF-8"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
[root@localhost src]# mysqld_multi start 3307
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = (unset),
        LC_ALL = (unset),
        LANG = "zh_CN.UTF-8"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
[root@localhost src]# mysqld_multi start 3308
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = (unset),
        LC_ALL = (unset),
        LANG = "zh_CN.UTF-8"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").

8.初始化密码

[root@localhost src]# mysql -uroot -S /tmp/mysql3306.sock -e 'set password = password("123456");' --connect-expired-password
[root@node2 src]# mysql -uroot -p123456 -S /tmp/mysql3306.sock

[root@localhost src]# mysql -uroot -S /tmp/mysql3307.sock -e 'set password = password("1234567");' --connect-expired-password
[root@node2 src]# mysql -uroot -p1234567 -S /tmp/mysql3307.sock

[root@localhost src]# mysql -uroot -S /tmp/mysql3308.sock -e 'set password = password("1234678");' --connect-expired-password
[root@node2 src]# mysql -uroot -p1234678 -S /tmp/mysql3308.sock