centos7 mysql 多实例_CentOS7配置MySQL5.7多实例

﹏ヽ暗。殇╰゛Y 2022-10-26 14:24 187阅读 0赞

MySQL下载

http://ftp.ntu.edu.tw/pub/MySQL/Downloads/

tar -zxvf mysql-5.7.18-linux-glibc2.5-x86\_64.tar.gz -C /usr/local/

mv mysql-5.7.18-linux-glibc2.5-x86\_64 mysql

创建用户，目录，并授权

groupadd mysql

useradd mysql -s /sbin/nologin -M -g mysql

mkdir -p /data/\{3306,3307\}/data

touch /data/3306/mysql\_3306.err

touch /data/3307/mysql\_3307.err

上传mysql，my.cnf文件到3306和3307文件夹下，文件内容在文章最后。

chown -R mysql.mysql /data

find /data -type f -name "mysql"|xargs chmod 700

vim /etc/profile

export PATH=/usr/local/mysql/bin:$PATH

source /etc/profile

初始化数据库

mysqld --defaults-file=/data/3306/my.cnf --initialize-insecure --user=mysql

mysqld --defaults-file=/data/3307/my.cnf --initialize-insecure --user=mysql

mysqld --defaults-file=/data/3306/my.cnf --user=mysql &

mysqld --defaults-file=/data/3307/my.cnf --user=mysql &

登录修改密码

mysql -uroot -S /data/3306/mysql.sock

mysql -uroot -S /data/3307/mysql.sock

SET PASSWORD=PASSWORD('123456');

修改mysql文件中密码

vim /data/3306/mysql

vim /data/3307/mysql

Mysql的关闭

注意：一定要用mysqladmin关闭

mysqladmin -u root -p -S /data/3306/mysql.sock shutdown

mysqladmin -u root -p -S /data/3307/mysql.sock shutdown

重新开启

/data/3306/mysql start

/data/3307/mysql start

my.cnf和mysql文件更加端口修改内容。

/data/3306/my.cnf文件内容：

\[client\]

port = 3306

socket = /data/3306/mysql.sock

\[mysql\]

no-auto-rehash

\[mysqld\]

user = mysql

port = 3306

socket = /data/3306/mysql.sock

basedir = /usr/local/mysql

datadir = /data/3306/data

open\_files\_limit = 1024

back\_log = 600

max\_connections = 800

max\_connect\_errors = 3000

external-locking = FALSE

max\_allowed\_packet =8M

sort\_buffer\_size = 1M

join\_buffer\_size = 1M

thread\_cache\_size = 100

query\_cache\_size = 2M

query\_cache\_limit = 1M

query\_cache\_min\_res\_unit = 2k

\#default\_table\_type = InnoDB

thread\_stack = 192K

\#transaction\_isolation = READ-COMMITTED

tmp\_table\_size = 2M

max\_heap\_table\_size = 2M

long\_query\_time = 1

\#log\_long\_format

\#log-error = /data/3306/error.log

\#log-slow-queries = /data/3306/slow.log

pid-file = /data/3306/mysql.pid

log-bin = /data/3306/mysql-bin

relay-log = /data/3306/relay-bin

relay-log-info-file = /data/3306/relay-log.info

binlog\_cache\_size = 1M

max\_binlog\_cache\_size = 1M

max\_binlog\_size = 2M

expire\_logs\_days = 7

key\_buffer\_size = 16M

read\_buffer\_size = 1M

read\_rnd\_buffer\_size = 1M

bulk\_insert\_buffer\_size = 1M

\#myisam\_sort\_buffer\_size = 1M

\#myisam\_max\_sort\_file\_size = 10G

\#myisam\_max\_extra\_sort\_file\_size = 10G

\#myisam\_repair\_threads = 1

\#myisam\_recover

lower\_case\_table\_names = 1

skip-name-resolve

slave-skip-errors = 1032,1062

replicate-ignore-db=mysql

server-id = 1

innodb\_buffer\_pool\_size = 32M

innodb\_data\_file\_path = ibdata1:128M:autoextend

innodb\_thread\_concurrency = 8

innodb\_flush\_log\_at\_trx\_commit = 2

innodb\_log\_buffer\_size = 2M

innodb\_log\_file\_size = 4M

innodb\_log\_files\_in\_group = 3

innodb\_max\_dirty\_pages\_pct = 90

innodb\_lock\_wait\_timeout = 120

innodb\_file\_per\_table = 0

\[mysqldump\]

quick

max\_allowed\_packet = 2M

\[mysqld\_safe\]

log-error=/data/3306/mysql\_3306.err

pid-file=/data/3306/mysqld.pid

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

/data/3306/mysql文件内容：

\#!/bin/sh

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

\#3306实例启动脚本

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

\#init

port=3306

mysql\_user="root"

mysql\_pwd="123456"

CmdPath="/usr/local/mysql/bin"

mysql\_sock="/data/$\{port\}/mysql.sock"

\#startup function

function\_start\_mysql()

if \[ ! -e "$mysql\_sock" \];then

printf "Starting MySQL...\\n"

/bin/sh $\{CmdPath\}/mysqld\_safe --defaults-file=/data/$\{port\}/my.cnf 2>&1 > /dev/null &

else

printf "MySQL is running...\\n"

exit

\#stop function

function\_stop\_mysql()

if \[ ! -e "$mysql\_sock" \];then

printf "MySQL is stopped...\\n"

exit

else

printf "Stoping MySQL...\\n"

$\{CmdPath\}/mysqladmin -u $\{mysql\_user\} -p$\{mysql\_pwd\} -S /data/$\{port\}/mysql.sock shutdown

\#restart function

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: /data/$\{port\}/mysql \{start|stop|restart\}\\n"

esac

centos7 mysql 多实例_CentOS7配置MySQL5.7多实例

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 mysql多实例命令_mysql多实例配置

相关 mysql 多实例 centos_CentOS 7 MySQL5.7 多实例（多端口）

相关 centos7 MySQL5.7 多实例安装教程

相关 CentOS7 配置MySQL57

相关 centos7 mysql 多实例_CentOS7配置MySQL5.7多实例

相关 mysql多用户多实例_mysql 多实例

相关基于centos/mysql-57-centos7构建docker镜像

相关 CentOS启动多个MySQL实例

相关 CentOS 7安装Mysql57数据库

相关 centos7 安装多个实例mysql8.0版本