mysql 多執行個體部署 Centos7.6 部署3個Mariadb 執行個體

mysql 多執行個體部署 Centos7.6 部署3個Mariadb 執行個體

[root@localhost ~]# yum install mariadb-server -y

建立對應的目錄檔案

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

chown -R mysql.mysql /mysql

初始化資料庫檔案

[root@localhost ~]# mysql_install_db --datadir=/mysql/3306/data/ --user=mysql

[root@localhost ~]# mysql_install_db --datadir=/mysql/3307/data/ --user=mysql

[root@localhost ~]# mysql_install_db --datadir=/mysql/3308/data/ --user=mysql

建立對應配置檔案

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

修改對應的配置檔案

[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

另外的2個執行個體調整對應的端口即可

準備啟動腳本 另外的執行個體修改對應的端口即可

[root@localhost ~]# vim /mysql/3306/bin/mysqld

!/bin/bash

chkconfig: 345 80 2

mysql_user="root"

mysql_pwd=""

cmd_path="/usr/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

function_restart_mysql()

printf "Restarting MySQL...\n"
function_stop_mysql
sleep 2
function_start_mysql           

case $1 in

start)

function_start_mysql           

;;

stop)

function_stop_mysql           

restart)

function_restart_mysql           

*)

printf "Usage: ${mysql_basedir}/${port}/bin/mysqld {start|stop|restart}\n"           

esac

啟動服務

[root@localhost ~]# /mysql/3306/bin/mysqld start

Starting MySQL...

[root@localhost ~]# /mysql/3307/bin/mysqld start

[root@localhost ~]# /mysql/3308/bin/mysqld start

連接配接測試

mysql -S /mysql/3308/socket/mysql.sock -e 'select version()'
version()
5.5.60-MariaDB

關閉資料庫

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

Stoping MySQL...

Enter password:

原文位址

https://www.cnblogs.com/aiaitie/p/10789486.html