|
方式：通过mysqld_safe实现多实例 配置好不同的参数文件，例如/etc/my3306.cnf /etc/my3307.cnf /etc/my3308.cnf 测试环境上有个mysql实例，datadir目录为/var/lib/mysql/ #/bin/sh #创建文件port=$1 cp /etc/my3306.cnf /etc/my$port.cnf #创建配置文件sed -i "s/3306/$port/g" /etc/my$port.cnf #更改配置文件端口 mkdir -p /home/mysql/data$port/mysql #创建basedir mkdir -p /home/mysql/data$port/dbs$port #创建数据目录 cp -r /var/lib/mysql/mysql /home/mysql/data$port/dbs$port/ #cp 元数据库信息 chown -R mysql:mysql /home/mysql #赋权 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my$port.cnf & #启动 测试可行； 通过老库密码登录新实例，即可。 [root@iZ234rd72 mysql]# my 3309 Entry Port ==== 3309 Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.1.73-log Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. Tiger [(none)]> |
|
|
