mysql多实例多配置文件安装.docx

?

?

mysql5.7多实例多配置文件安装

?

?

本文旨在学习多实例多个cnf配置文件下的安装与配置，不足之处请指教。

本文中创建了3306、3307、3308三个实例。

1.创建mysql用户以及组

groupaddmysql

useradd-r-gmysql-s/bin/falsemysql

2.创建mysql数据目录

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

chown-Rmysql.mysql/data/

3.创建mysqllogs目录

mkdir-p/logs/{3306,3307,3308}

mkdir-p/logs/{3306,3307,3308}/redolog

mkdir-p/logs/{3306,3307,3308}/undolog

touch/logs/3306/mysqld3306.log

touch/logs/3307/mysqld3307.log

touch/logs/3308/mysqld3308.log

chown-Rmysql.mysql/logs/

mkdir-p/var/run/mysqld

chown-Rmysql.mysql/var/run/mysqld

4.解压Mysql安装包

tarxvfmysql-5.7.26-linux-glibc2.12-x86_64.tar.gz-C/

cd/

mvmysql-5.7.26-linux-glibc2.12-x86_64/mysql

chown-Rmysql.mysql/mysql

5.将Mysql加入环境变量

[root@mysqlmulti/]#.~/.bash_profile

[root@mysqlmulti/]#cat~/.bash_profile

#.bash_profile

#Getthealiasesandfunctions

if[-f~/.bashrc];then

.~/.bashrc

fi

#Userspecificenvironmentandstartupprograms

PATH=$PATH:$HOME/bin:/mysql/bin

exportPATH

6.修改配置文件

修改/data/3306/f文件

[root@mysql573306]#catf

[client]

port=3306

socket=/data/3306/mysql3306.sock

[mysql]

auto-rehash

[mysqld_safe]

log-error=/logs/3306/mysqld3306.log

pid-error=/data/3306/mysql3306.pid

[mysqld]

user=mysql

port=3306

socket=/data/3306/mysql3306.sock

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

datadir=/data/3306/data

basedir=/mysql

skip_name_resolve=1

skip-external-locking

max_connections=3000

max_connect_errors=10

transaction_isolation=READ-COMMITTED

interactive_timeout=86400

wait_timeout=86400

back_log=600

####cache######

table_open_cache=2000

thread_cache_size=500

query_cache_size=128M

query_cache_min_res_unit=128k

sort_buffer_size=2M

read_buffer_size=2M

read_rnd_buffer_size=4M

join_buffer_size=2M

bulk_insert_buffer_size=16M

max_heap_table_size=64M

tmp_table_size=64M

###MyISAM####

key_buffer_size=64M

key_cache_block_size=4k

myisam_sort_buffer_size=2M

########innodbsettings########

#innodb_page_size=4k

innodb_buffer_pool_size=1G

innodb_buffer_