更新时间:2022-09-24 12:40:29
本文系统:rhel5.8
ip : 192.168.100.150
数据库版本:mysql-5.6.15
1、创建部署mysql服务账号:
1
2
3
4
|
[root@daf ~] # useradd -d /opt/mysql mysql
[root@daf ~] # echo "mysql" |passwd --stdin mysql
Changing password for user mysql.
passwd : all authentication tokens updated successfully.
|
2、解压无需免装包:配置环境变量
1
2
3
4
5
6
7
8
9
10
|
[mysql@daf ~]$ tar zxvf mysql-5.6.15-linux-glibc2.5-x86_64. tar .gz
[mysql@daf ~]$ mv mysql-5.6.15-linux-glibc2.5-x86_64 mysql-5.6.15
[mysql@daf mysql-5.6.15]$ vim ~/.bash_profile MYSQL_HOME= /opt/mysql/mysql-5 .6.15
export MYSQL_HOME
PATH=$MYSQL_HOME /bin :$PATH
export PATH
|
3、配置多实例数据库配置文件
1
2
3
4
5
6
7
|
[root@daf ~] # mkdir /Data_for_Mysql
[root@daf ~] # chown mysql.mysql -R /Data_for_Mysql/
[root@daf ~] # su - mysql
[mysql@daf ~]$ mkdir -p /Data_for_Mysql/3301/data /Data_for_Mysql/3301/logs
[mysql@daf ~]$ touch /Data_for_Mysql/3301/my .cnf
[mysql@daf ~]$ mkdir -p /Data_for_Mysql/3302/data /Data_for_Mysql/3302/logs
[mysql@daf ~]$ touch /Data_for_Mysql/3302/my .cnf
|
目录结构:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
[mysql@daf Data_for_Mysql]$ pwd
/Data_for_Mysql [mysql@daf Data_for_Mysql]$ tree . |-- 3301 | |-- data | |-- logs | `-- my.cnf `-- 3302 |-- data
|-- logs
`-- my.cnf
6 directories, 2 files [mysql@daf Data_for_Mysql]$ |
配置my.cnf ######本配置文件只供参考
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
|
[mysql@daf 3301]$ vim /Data_for_Mysql/3301/my .cnf
[client] port = 3301 socket = /Data_for_Mysql/3301/data/mysql .sock
[mysqld] user=msql port=3301 bind-address=192.168.100.150 socket = /Data_for_Mysql/3301/data/mysql .sock.3301
pid- file = /Data_for_Mysql/3301/data/mysql .pid
basedir = /opt/mysql/mysql-5 .6.15
datadir = /Data_for_Mysql/3301/data
server- id =1
log-bin=mysql-bin log-bin-index= mysql-bin.index # LOGGING log_error= /Data_for_Mysql/3301/logs/mysql-error .log
slow_query_log_file= /Data_for_Mysql/3301/logs/mysql-slow .log
slow_query_log=1 character-sets- dir = /opt/mysql/mysql-5 .6.15 /share/charsets
back_log = 2000 max_connections = 1000 connect-timeout = 60 wait-timeout = 28800 net_buffer_length = 16384 max_allowed_packet = 64M thread_stack = 192K thread_cache_size = 20 thread_concurrency = 128 query_cache_size = 256M query_cache_limit = 2M query_cache_min_res_unit = 2 default- time -zone = system
character- set -server = utf8
default-storage-engine = InnoDB tmp_table_size = 512M max_heap_table_size = 512M max_binlog_size = 1G max_relay_log_size = 1G [mysql] disable-auto-rehash default-character- set = utf8
|
4、初始化数据库
1
2
3
|
[mysql@daf scripts]$ pwd
/opt/mysql/mysql-5 .6.15 /scripts
[mysql@daf scripts]$ . /mysql_install_db --defaults- file = /Data_for_Mysql/3301/my .cnf --user=mysql --basedir= /opt/mysql/mysql-5 .6.15 --datadir= /Data_for_Mysql/3301/data/
|
5、启动3301实例数据库 ###启动数据库必须在mysql目录;
1
2
3
4
5
6
|
[mysql@daf mysql-5.6.15]$ pwd
/opt/mysql/mysql-5 .6.15
[mysql@daf mysql-5.6.15]$ mysqld_safe --defaults- file = /Data_for_Mysql/3301/my .cnf --user=mysql --basedir= /opt/mysql/mysql-5 .6.15 --datadir= /Data_for_Mysql/3301/data/ &
[mysql@daf mysql-5.6.15]$ netstat -nat | grep 3301
tcp 0 0 192.168.100.150:3301 0.0.0.0:* LISTEN |
Ps:3302 实例操作和上面一样,只需改动端口及相应目录即可;
3302配置文件:
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
|
[mysql@daf 3302]$ cat my.cnf
[client] port = 3302 socket = /Data_for_Mysql/3302/data/mysql .sock
[mysqld] user=mysql port=3302 bind-address=192.168.100.150 socket = /Data_for_Mysql/3302/data/mysql .sock.3302
pid- file = /Data_for_Mysql/3302/data/mysql .pid
basedir = /opt/mysql/mysql-5 .6.15
datadir = /Data_for_Mysql/3302/data
server- id =1
log-bin=mysql-bin log-bin-index= mysql-bin.index # LOGGING log_error= /Data_for_Mysql/3302/logs/mysql-error .log
slow_query_log_file= /Data_for_Mysql/3302/logs/mysql-slow .log
slow_query_log=1 character-sets- dir = /opt/mysql/mysql-5 .6.15 /share/charsets
back_log = 2000 max_connections = 1000 connect-timeout = 60 wait-timeout = 28800 net_buffer_length = 16384 max_allowed_packet = 64M thread_stack = 192K thread_cache_size = 20 thread_concurrency = 128 query_cache_size = 256M query_cache_limit = 2M query_cache_min_res_unit = 2 default- time -zone = system
character- set -server = utf8
default-storage-engine = InnoDB tmp_table_size = 512M max_heap_table_size = 512M max_binlog_size = 1G max_relay_log_size = 1G [mysql] disable-auto-rehash default-character- set = utf8
|
3302 实例初始化;
1
2
3
|
[mysql@daf scripts]$ pwd
/opt/mysql/mysql-5 .6.15 /scripts
[mysql@daf scripts]$ . /mysql_install_db --defaults- file = /Data_for_Mysql/3302/my .cnf --user=mysql --basedir= /opt/mysql/mysql-5 .6.15 --datadir= /Data_for_Mysql/3302/data/
|
3302 启动该实例:
1
2
3
4
5
|
[mysql@daf mysql-5.6.15]$ mysqld_safe --defaults- file = /Data_for_Mysql/3302/my .cnf --user=mysql --basedir= /opt/mysql/mysql-5 .6.15 --datadir= /Data_for_Mysql/3302/data/ &
[mysql@daf mysql-5.6.15]$ netstat -nat | grep 330
tcp 0 0 192.168.100.150:3301 0.0.0.0:* LISTEN tcp 0 0 192.168.100.150:3302 0.0.0.0:* LISTEN |
6、创建root密码,要区别实例
1
|
[mysql@daf mysql-5.6.15]$ mysqladmin -uroot password 'root123' -S /Data_for_Mysql/3301/data/mysql .sock.3301
|
6.1、关闭mysql,区别实例
1
2
3
4
|
[mysql@daf mysql-5.6.15]$ mysqladmin -uroot -proot123 -S /Data_for_Mysql/3301/data/mysql .sock.3301 shutdown
Warning: Using a password on the command line interface can be insecure.
150402 15:44:52 mysqld_safe mysqld from pid file /Data_for_Mysql/3301/data/mysql .pid ended
[1]- Done mysqld_safe --defaults- file = /Data_for_Mysql/3301/my .cnf --user=mysql --basedir= /opt/mysql/mysql-5 .6.15 --datadir= /Data_for_Mysql/3301/data/
|