以yum源安装为例:
用yum安装mariadb:yum install mariadb-server
(找到多实例的包:rpm -ql mariadb-server|grep multi 注:这种的只能在同个版本实现多实例,具有局限性)
规划多实例的各个路径:
mkdir /data/mysql/{3306,3307,3308}/{/etc,bin,socket,pid,log,data} -pv
chown -R mysql.mysql /data/mysql
mysql_install_db --datadir=/data/mysql/3306/data/ --user=mysql
mysql_install_db --datadir=/data/mysql/3307/data/ --user=mysql
mysql_install_db --datadir=/data/mysql/3308/data/ --user=mysql
cp -a /etc/my.cnf mysql/3306/etc/
vim /data/mysql/3306/etc/my.cnf
[mysqld]
port=3306
datadir=/data/mysql/3306/data
socket=/data/mysql/3306/socket/mysql.sock
[mysqld_safe]
log-error=/data/mysql/3306/log/mariadb.log
pid-file=/data/mysql/3306/pid/mariadb.pid
#!includedir /etc/my.cnf.d
cp -a /data/mysql/3306/etc/my.cnf /data/mysql/3307/etc/my.cnf
cp -a /data/mysql/3306/etc/my.cnf /data/mysql/3308/etc/my.cnf
修改这两个配置文件的port端口号
vim /data/mysql/3306/bin/mysqld
#!/bin/bash
port=3306
mysql_user=“root”
mysql_pwd=""
cmd_path="/usr/bin"
mysql_basedir="/data/mysql"
mysql_sock=" m y s q l b a s e d i r / {mysql_basedir}/ mysqlb