Mysql多实例安装
前言：前文已经介绍单实例的安装，我们接着进行Mysql的多实例安装,我们利用多个配置文件，多个启动文件管理多实例一、安装依赖包
1
yum installncurses-devel libaio-devel gccgcc-c++ cmake perl
下载Mysql安装包，下载地址mysql-5.5安装包，并解压安装包
1
2
tar -zxvf mysql-5.5.32.tar.gz
cdmysql-5.5.32
编译安装
1
2
3
4
5
6
7
8
9
10
11
12
13
cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \-DWITH_EXAMPLE_STORAGE_ENGINE=1 \-DWITH_PARTITION_STORAGE_ENGINE=1 \-DWITH_FAST_MUTEXES=1 \-DWITH_ZLIB=bundled \-DENABLED_LOCAL_INFILE=1 \-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock\
-DENABLED_LOCAL_INFILE=ON \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_DEBUG=0
make && make install
二、配置用户权限设置Mysql用户和组
1
2
groupaddmysql
useradd -g mysql mysql
新建Mysql安装目录和数据文件目录
1
2
3
mkdir-p /usr/local/mysql
mkdir-p /data/3306
mkdir-p /data/3307
修改目录所有者和组
1
2
3
chown -Rmysql:mysql/usr/local/mysql
chown -Rmysql:mysql/data/3306
chown -Rmysql:mysql/data/3307
三、初始化数据库，配置配置文件，配置启动文件等
1
2
/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/data/3306/data --user=mysql
/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/data/3307/data --user=mysql
创建多个配置文件
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
vim/data/3306/my.cnf
port = 3306
socket = /data/3306/mysql.sock
port = 3306
socket = /data/3306/mysql.sock
basedir = /usr/local/mysql
datadir = /data/3306/data
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
skip-name-resolve
log-bin=mysql-bin
binlog_format=mixed
max_binlog_size = 500M
server-id = 1
log-error=/data/3306/ilanni.err
pid-file=/data/3306/ilanni.pid
quick
max_allowed_packet = 16M
no-auto-rehash
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
interactive-timeout
拷贝一份给3307，幷打文件里的3306都替换为3307
1
2
cp/data/3306/my.cnf/data/3307/my.cnf
sed -i 's/3306/3307/g' /data/3307/my.cnf
创建Mysql服务启动脚本
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
vim /data/3306/mysqld
#!/bin/bash
mysql_port=3306
mysql_username="admin"
mysql_password="password"
function_start_mysql()
{
printf "Starting MySQL...\n"
/bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/data/${mysql_port}/my.cnf 2>&1 > /dev/null &
}
function_stop_mysql()
{
printf "Stoping MySQL...\n"
/usr/local/mysql/bin/mysqladmin -u ${mysql_username} -p${mysql_password} -S /data/${mysql_port}/mysql.sock shutdown
}
function_restart_mysql()
{
printf "Restarting MySQL...\n"
function_stop_mysql
function_start_mysql
}
function_kill_mysql()
{
kill -9 $(ps -ef | grep 'bin/mysqld_safe' | grep ${mysql_port} | awk '{printf $2}')
kill -9 $(ps -ef | grep 'libexec/mysqld' | grep ${mysql_port} | awk '{printf $2}')
}
case $1 in
start)
function_start_mysql;;
stop)
function_stop_mysql;;
kill)
function_kill_mysql;;
restart)
function_stop_mysql
function_start_mysql;;
*)
echo "Usage: /data/${mysql_port}/mysqld {start|stop|restart|kill}";;
esac
拷贝给3307一份启动脚本，把里面的3306都改为3307，幷赋予启动权限
1
2
3
4
cp /data/3306/mysqld /data/3307/mysqld
sed -i 's/3306/3307/g' /data/3307/mysqld
chmod +x /data/3306/mysqld
chmod +x /data/3307/mysqld
修改/etc/profile文件，末尾添加PATH
1
2
PATH=/usr/local/mysql/bin:$PATH
export PATH
保存修改，让配置立即生效
1
source /etc/profile
四，启动数据库幷登录
1
2
3
4
/data/3306/mysqld start
/data/3307/mysqld start
mysql -uroot -p -S /data/3306/mysql.sock
mysql -uroot -p -S /data/3307/mysql.sock
页:
[1]