Mysql-mysql多实例安装

矫情吗；* 2022-05-25 12:56 225阅读 0赞

前置条件：安装cmake工具、gcc工具

安装gcc :yum install gcc

# 1.安装cmake： #

\[root@localhost workspace\]\# wget  [http://www.cmake.org/files/v2.8/cmake-2.8.3.tar.gz][http_www.cmake.org_files_v2.8_cmake-2.8.3.tar.gz]

\[root@localhost workspace\]\# tar xvf cmake-2.8.3.tar.gz

\[root@localhost workspace\]\# cd cmake-2.8.3

\[root@localhost workspace\]\# ./configure

\[root@localhost workspace\]\# make

\[root@localhost workspace\]\# make install

# 2.下载mysql源码包： #

\[root@localhost workspace\]\# wget  [http://downloads.mysql.com/archives/mysql-5.5/mysql-5.5.32.tar.gz][http_downloads.mysql.com_archives_mysql-5.5_mysql-5.5.32.tar.gz]

\[root@localhost workspace\]\# tar xvf mysql-5.5.32.tar.gz

\[root@localhost workspace\]\# cd mysql-5.5.32

安装第一个MySQL数据库

（1）创建所需要的文件目录

\[root@localhost local\]\# cd /usr/local/

\[root@localhost local\]\# mkdir mysql

\[root@localhost local\]\# cd mysql/

\[root@localhost mysql\]\# mkdir data

\[root@localhost mysql\]\# mkdir etc

（2）配置MySQL源码编译选项

\[root@localhost mysql-5.5.32\]\# cmake                     \\

> -DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql    \\

> -DMYSQL\_DATADIR=/usr/local/mysql/data          \\

> -DSYSCONFDIR=/usr/local/mysql/etc                   \\

> -DWITH\_MYISAM\_STORAGE\_ENGINE=1          \\

> -DWITH\_INNOBASE\_STORAGE\_ENGINE=1      \\

> -DWITH\_MEMORY\_STORAGE\_ENGINE=1        \\

> -DWITH\_READLINE=1                                          \\

> -DMYSQL\_UNIX\_ADDR=/tmp/mysqld.sock         \\

> -DMYSQL\_TCP\_PORT=3306                               \\

> -DENABLED\_LOCAL\_INFILE=1                           \\

> -DWITH\_PARTITION\_STORAGE\_ENGINE=1     \\

> -DEXTRA\_CHARSETS=all                                    \\

> -DDEFAULT\_CHARSET=utf8                               \\

> -DDEFAULT\_COLLATION=utf8\_general\_ci

（3）编译安装

\[root@localhost mysql-5.5.32\]\# make & make install

（4）配置第一个MySQL实例

\[root@localhost mysql-5.5.32\]\# cd /usr/local/mysql

\[root@localhost mysql\]\# chown -R mysql:mysql .

\[root@localhost mysql\]\# cp support-files/my-medium.cnf /usr/local/mysql/etc/my.cnf

\[root@localhost mysql\]\# vi /usr/local/mysql/etc/my.cnf

添加 datadir=/usr/local/mysql/data

default-storage-engine=MyISAM

\[root@localhost mysql\]\# cd /usr/local/mysql/scripts/

\[root@localhost scripts\]\# ./mysql\_install\_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data &

\[root@localhost bin\]\# cd /usr/local/mysql/bin

\[root@localhost bin\]\# ./mysqld\_safe --user=root

\[1\] 28869

\[root@localhost bin\]\# 131016 20:07:13 mysqld\_safe Logging to '/usr/local/mysql/data/localhost.localdomain.err'.

131016 20:07:14 mysqld\_safe Starting mysqld daemon with databases from /usr/local/mysql/data

查看服务是否启动成功

\[root@localhost bin\]\# netstat -tlnap | grep mysql

tcp        0      0 0.0.0.0:3306                0.0.0.0:\*                   LISTEN      29147/mysqld

登录MySQL并修改root用户密码

\[root@localhost bin\]\# ./mysqladmin -uroot password 'eisoo.com'

\[root@localhost bin\]\# ./mysql -uroot -peisoo.com

Welcome to the MySQL monitor.  Commands end with ; or \\g.

Your MySQL connection id is 2

Server version: 5.5.32-log Source distribution

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.

mysql> exit

安装第二个MySQL数据库

（1）清理配置信息

\[root@localhost bin\]\# cd /workspace/mysql-5.5.32

\[root@localhost mysql-5.5.32\]\# make clean

\[root@localhost mysql-5.5.32\]\# rm -rf CMakeCache.txt

（2）创建所需要的文件目录

\[root@localhost mysql-5.5.32\]\# cd /usr/local/

\[root@localhost local\]\# mkdir mysql3307

\[root@localhost local\]\# cd mysql3307/

\[root@localhost mysql3307\]\# mkdir data

\[root@localhost mysql3307\]\# mkdir etc

（3）配置第二个实例的编译信息

\[root@localhost bin\]\# cd /workspace/mysql-5.5.32

\[root@localhost mysql-5.5.32\]\# cmake                     \\

> -DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql3307    \\

> -DMYSQL\_DATADIR=/usr/local/mysql3307/data          \\

> -DSYSCONFDIR=/usr/local/mysql3307/etc                   \\

> -DWITH\_MYISAM\_STORAGE\_ENGINE=1          \\

> -DWITH\_INNOBASE\_STORAGE\_ENGINE=1      \\

> -DWITH\_MEMORY\_STORAGE\_ENGINE=1        \\

> -DWITH\_READLINE=1                                          \\

> -DMYSQL\_UNIX\_ADDR=/tmp/mysqld3307.sock         \\

> -DMYSQL\_TCP\_PORT=3307                               \\

> -DENABLED\_LOCAL\_INFILE=1                           \\

> -DWITH\_PARTITION\_STORAGE\_ENGINE=1     \\

> -DEXTRA\_CHARSETS=all                                    \\

> -DDEFAULT\_CHARSET=utf8                               \\

> -DDEFAULT\_COLLATION=utf8\_general\_ci

（4）编译安装

\[root@localhost mysql-5.5.32\]\# make

\[root@localhost mysql-5.5.32\]\# make install

如果编译不成功就重新解压压缩包进行编译

（5）配置第二个MySQL实例

\[root@localhost mysql-5.5.32\]\# cd /usr/local/mysql3307

\[root@localhost mysql3307\]\# chown -R mysql:mysql .

\[root@localhost mysql3307\]\# cp support-files/my-medium.cnf /usr/local/mysql3307/etc/my.cnf

\[root@localhost mysql3307\]\# vi /usr/local/mysql3307/etc/my.cnf

添加 datadir=/usr/local/mysql3307/data

default-storage-engine=MyISAM

\[root@localhost mysql3307\]\# cd /usr/local/mysql3307/scripts/

\[root@localhost scripts\]\# ./mysql\_install\_db --user=mysql --basedir=/usr/local/mysql3307 --datadir=/usr/local/mysql3307/data &

\[root@localhost scripts\]\# cd /usr/local/mysql3307/bin

\[root@localhost bin\]\# ./mysqld\_safe --user=root

131016 20:40:27 mysqld\_safe Logging to '/usr/local/mysql3307/data/localhost.localdomain.err'.

131016 20:40:27 mysqld\_safe Starting mysqld daemon with databases from /usr/local/mysql3307/data

查看服务是否启动成功

\[root@localhost bin\]\# netstat -tlnap | grep mysql

tcp        0      0 0.0.0.0:3306                0.0.0.0:\*                   LISTEN      29147/mysqld

tcp        0      0 0.0.0.0:3307                0.0.0.0:\*                   LISTEN      7447/mysqld

登录MySQL并修改root用户密码

\[root@localhost bin\]\# ./mysqladmin -uroot password 'eisoo.com123'

\[root@localhost bin\]\# ./mysql -uroot -peisoo.com123

Welcome to the MySQL monitor.  Commands end with ; or \\g.

Your MySQL connection id is 2

Server version: 5.5.32-log Source distribution

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.

mysql> exit

增加系统环境变量

\[root@localhost /\]\# vi /etc/profile

增加一行：export PATH=/usr/local/mysql/bin:/usr/local/mysql3307/bin:$PATH

\[root@localhost /\]\# source /etc/profile

\[root@localhost /\]\# export $PATH

分别启动不同实例：

\[root@localhost /\]\# mysqld\_safe --user=root --port=3306 --socket=/tmp/mysqld.sock --datadir=/usr/local/mysql/data &

\[root@localhost /\]\# mysqld\_safe --user=root --port=3307 --socket=/tmp/mysqld3307.sock --datadir=/usr/local/mysql3307/data &

分别登陆不同实例：

\[root@localhost /\]\# mysql -uroot -peisoo.com -S /tmp/mysqld.sock

\[root@localhost /\]\# mysql -uroot -peisoo.com123 -S /tmp/mysqld3307.sock

启动还是太麻烦，可以这样做：

\[root@localhost /\]\# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql3306

\[root@localhost /\]\# cp /usr/local/mysql3307/support-files/mysql.server /etc/init.d/mysql3307

给mysql用户添加权限：

\[root@localhost /\]\# chmod -R 755 /usr/local/mysql/data

分别启动实例对应的服务：

\[root@localhost tmp\]\# service mysql3306 start

Starting MySQL.                                            \[确定\]

\[root@localhost tmp\]\# service mysql3307 start

Starting MySQL.                                            \[确定\]

查看服务：

\[root@localhost tmp\]\# netstat -tlnap | grep mysql

tcp        0      0 0.0.0.0:3306                0.0.0.0:\*                   LISTEN      10759/mysqld

tcp        0      0 0.0.0.0:3307                0.0.0.0:\*                   LISTEN      11097/mysqld

将服务添加到系统服务中，使其开机自动启动。

\[root@localhost /\]\# chkconfig --add mysql3306

# 遇到的错误: #

1.找不到sock文件，创建失败

解决办法：

1.重新安装

2.检查对应端口是否关闭

可以通过查看mysql的错误日志定位错误信息。

[http_www.cmake.org_files_v2.8_cmake-2.8.3.tar.gz]: http://www.cmake.org/files/v2.8/cmake-2.8.3.tar.gz
[http_downloads.mysql.com_archives_mysql-5.5_mysql-5.5.32.tar.gz]: http://downloads.mysql.com/archives/mysql-5.5/mysql-5.5.32.tar.gz