MySQL非常规安装2个小实验

1、MySQL数据文件路径修改实验

1.1检查MySQL实例状态

[root@mysql11 bin]# ps -ef|grep mysql
root      56981      1  0 08:21 pts/1    00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/mysql11.pid
mysql     57066  56981  0 08:21 pts/1    00:00:02 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=mysql11.err --pid-file=/usr/local/mysql/data/mysql11.pid
root      57295  56425  0 08:38 pts/1    00:00:00 grep --color=auto mysql
[root@mysql11 bin]# 
[root@mysql11 bin]# 

1.2将MySQL实例停掉

[root@mysql11 bin]# /etc/init.d/mysql.server  status
 SUCCESS! MySQL running (57066)
[root@mysql11 bin]# 
[root@mysql11 bin]# 
[root@mysql11 bin]# 
[root@mysql11 bin]# /etc/init.d/mysql.server  stop
Shutting down MySQL. SUCCESS! 
[root@mysql11 bin]# 

1.3建新目录，注意权限问题，将data目录迁移到新路径下

[root@mysql11 /]# cd /mysql/
[root@mysql11 mysql]# mv /usr/local/mysql/data  ./
[root@mysql11 mysql]# ll
total 4
drwxr-x---. 6 mysql mysql 4096 Dec 14 08:38 data
drwxr-xr-x. 2 mysql mysql   88 Oct  8 12:12 soft
[root@mysql11 mysql]# 

1.4更改/etc/my.cnf路径下的配置文件内容、

[root@mysql11 mysql]# cat /etc/my.cnf 
[mysqld]
datadir=/mysql/data
[root@mysql11 mysql]# 

1.5启动MySQL实例

[root@mysql11 mysql]# /etc/init.d/mysql.server  start 
Starting MySQL. SUCCESS! 
[root@mysql11 mysql]#

2、MySQL（非默认/usr/local/mysql）指定新路径安装实验+不同端口实例

[root@mysql11 mysql]# 
[root@mysql11 mysql]# /etc/init.d/mysql.server  stop
Shutting down MySQL. SUCCESS! 
[root@mysql11 mysql]# 

2.2进行整个目录克隆，注意权限

[root@mysql11 mysql]# ll
total 0
drwxr-xr-x. 10 mysql mysql 141 Dec 14 22:27 mysql1（旧库）
drwxr-xr-x. 10 mysql mysql 141 Dec 14 22:27 mysql2（新库）
drwxr-xr-x.  2 mysql mysql  88 Dec 14 22:15 soft
[root@mysql11 mysql]# 

2.3复制旧的配置文件，更改对应参数，不同端口不同名配置文件

旧库配置文件：
[root@mysql11 mysql]# cat /etc/my.cnf 
[mysqld]
datadir=/mysql/mysql1/data
basedir=/mysql/mysql1
[root@mysql11 mysql]#

新库配置文件：
[root@mysql11 mysql]# cat /etc/my3377.cnf 
[mysqld]
datadir=/mysql/mysql2/data
basedir=/mysql/mysql2
port=3377
socket=/tmp/mysql3377.sock
mysqlx_port=33770
mysqlx_socket=/tmp/mysqlx33770.sock
[root@mysql11 mysql]# 
[root@mysql11 mysql]# 

2.4启动两个不同端口实例

旧库：
[root@mysql11 mysql2]# bin/mysqld --defaults-file=/etc/my.cnf --user=mysql &
[2] 59222
[root@mysql11 mysql2]# 2021-12-15T03:33:39.435095Z 0 [System] [MY-010116] [Server] /mysql/mysql2/bin/mysqld (mysqld 8.0.25) starting as process 59222
2021-12-15T03:33:39.444466Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-15T03:33:39.605406Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-15T03:33:39.711197Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2021-12-15T03:33:39.772002Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-15T03:33:39.772145Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-15T03:33:39.788619Z 0 [System] [MY-010931] [Server] /mysql/mysql2/bin/mysqld: ready for connections. Version: '8.0.25'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Server - GPL.

[root@mysql11 mysql2]# 

新库：
[root@mysql11 mysql2]# bin/mysqld --defaults-file=/etc/my3377.cnf --user=mysql &
[1] 59171
[root@mysql11 mysql2]# 2021-12-15T03:32:58.432486Z 0 [System] [MY-010116] [Server] /mysql/mysql2/bin/mysqld (mysqld 8.0.25) starting as process 59171
2021-12-15T03:32:58.442328Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-15T03:32:58.590166Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-15T03:32:58.683543Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33770, socket: /tmp/mysqlx33770.sock
2021-12-15T03:32:58.731629Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-15T03:32:58.731772Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-15T03:32:58.748814Z 0 [System] [MY-010931] [Server] /mysql/mysql2/bin/mysqld: ready for connections. Version: '8.0.25'  socket: '/tmp/mysql3377.sock'  port: 3377  MySQL Community Server - GPL.

[root@mysql11 mysql2]#