linux mysql 多个实例_linux+安装多个MYSQL实例

逃离我推掉我的手 2023-01-11 13:15 155阅读 0赞

mysql创建多个实例，其实就是把DATA文件，SOCK,PORT指向不同的文件和端口

mysql安装过程看

http://blog.csdn.net/tangpengtao/article/details/6650424

先创建3307的DATA目录

\[root@localhost mysql-5.5.15\]\# mkdir -p

/usr/local/mysql3307

\[root@localhost mysql-5.5.15\]\#

\[root@localhost mysql-5.5.15\]\# chmod +w /usr/local/mysql3307

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

/usr/local/mysql3307

\[root@localhost mysql-5.5.15\]\#

\[root@localhost mysql-5.5.15\]\# mkdir -p /var/mysql3307/

mkdir -p /var/mysql3307/data/

mkdir -p /var/mysql3307/log/

chown -R mysql:mysql /var/mysql3307/

\[root@localhost mysql-5.5.15\]\# mkdir -p /var/mysql3307/data/

\[root@localhost mysql-5.5.15\]\# mkdir -p /var/mysql3307/log/

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

/var/mysql3307/

mkdir -p /usr/local/mysql3307

chmod +w /usr/local/mysql3307

chown -R mysql:mysql /usr/local/mysql3307

mkdir -p /var/mysql3307/

mkdir -p /var/mysql3307/data/

mkdir -p /var/mysql3307/log/

chown -R mysql:mysql /var/mysql3307/

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

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

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

> -DDEFAULT\_CHARSET=utf8 \\

> -DDEFAULT\_COLLATION=utf8\_general\_ci \\

> -DWITH\_EXTRA\_CHARSETS:STRING=utf8,gbk \\

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

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

> -DWITH\_READLINE=1 \\

> -DENABLED\_LOCAL\_INFILE=1 \\

> -DMYSQL\_DATADIR=/var/mysql3307/data \\

> ;

\-- MySQL 5.5.15

\-- Configuring done

\-- Generating done

\-- Build files have been written to:

/home/raycloud/software/mysql-5.5.15

\[root@localhost mysql-5.5.15\]\#

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

\-DMYSQL\_UNIX\_ADDR=/tmp/mysql3307.sock \\

\-DDEFAULT\_CHARSET=utf8 \\

\-DDEFAULT\_COLLATION=utf8\_general\_ci \\

\-DWITH\_EXTRA\_CHARSETS:STRING=utf8,gbk \\

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

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

\-DWITH\_READLINE=1 \\

\-DENABLED\_LOCAL\_INFILE=1 \\

\-DMYSQL\_DATADIR=/var/mysql3307/data \\

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

\-- MySQL 5.5.15

\-- Configuring done

\-- Generating done

\-- Build files have been written to:

/home/raycloud/software/mysql-5.5.15

\[ 0%\] Built target INFO\_BIN

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

进入到my.cnf然后vi my.cnf

\[mysqld3\]

port = 3307

socket = /tmp/mysql3307.sock

skip-external-locking

key\_buffer\_size = 256M

max\_allowed\_packet = 1M

table\_open\_cache = 256

sort\_buffer\_size = 1M

read\_buffer\_size = 1M

read\_rnd\_buffer\_size = 4M

myisam\_sort\_buffer\_size = 64M

thread\_cache\_size = 8

query\_cache\_size= 16M

\#wait\_timeout=100

\#interactive\_timeout=100

max\_connections=1400

user=root

datadir=/var/mysql3307/data

启动mysql

\[root@localhost etc\]\# mysqld\_safe --user=root --port=3307

\--socket=/tmp/mysql3307.sock --datadir=/var/mysql3307/data

\[2\] 7459

\[root@localhost etc\]\# Starting mysqld daemon with databases from

/var/mysql3307/data

查看mysql服务是否启动

\[root@localhost etc\]\# ps -ef |grep 3307

root 7459 1624 0 20:18 pts/1 00:00:00 /bin/sh /usr/bin/mysqld\_safe

\--user=root --port=3307 --socket=/tmp/mysql3307.sock

\--datadir=/var/mysql3307/data

root 7488 7459 0 20:18 pts/1 00:00:00 /usr/libexec/mysqld

\--basedir=/usr --datadir=/var/mysql3307/data --user=root

\--pid-file=/var/mysql3307/data/localhost.localdomain.pid

\--skip-external-locking --port=3307

\--socket=/tmp/mysql3307.sock

root 7502 1624 0 20:19 pts/1 00:00:00 grep 3307

\[root@localhost etc\]\#

进入mysqlclient 修改密码

\[root@localhost etc\]\# mysql -uroot --socket=/tmp/mysql3307.sock

\--port=3307 -p

Enter password:

mysql> use mysql;

Database changed

mysql> update user set

password=password('yourpassword') where user='root';

Query OK, 4 rows affected (0.00 sec)

Rows matched: 4 Changed: 4 Warnings: 0

mysql> FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.00 sec)

mysql> set character\_set\_results=utf8

\->

\-> ;

Query OK, 0 rows affected (0.00 sec)

mysql> show variables like '%char%';

\+--------------------------+----------------------------+

| Variable\_name | Value |

\+--------------------------+----------------------------+

| character\_set\_client | utf8 |

| character\_set\_connection | utf8 |

| character\_set\_database | utf8 |

| character\_set\_filesystem | binary |

| character\_set\_results | utf8 |

| character\_set\_server | utf8 |

| character\_set\_system | utf8 |

| character\_sets\_dir | /usr/share/mysql/charsets/ |

\+--------------------------+----------------------------+

8 rows in set (0.00 sec)

mysql>

停止mysql 3307

\[root@localhost etc\]\# mysqladmin -uroot

\--socket=/tmp/mysql3307.sock --port=3307 -p shutdown

Enter password:

\[root@localhost etc\]\#

启动3307数据库

\[root@localhost etc\]\# /usr/local/mysql/bin/mysqld\_multi

\--defaults-file=/etc/my.cnf start 3

linux mysql 多个实例_linux+安装多个MYSQL实例

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 mysql开启多个端口_mysql单个实例开启多个端口

相关 linux mysql 多个实例_linux+安装多个MYSQL实例

相关 mysql多用户多实例_mysql 多实例

相关 Windows上安装多个MySQL实例

相关 Linux MySQL 多实例配置

相关 Mysql-mysql多实例安装

相关 CentOS启动多个MySQL实例

相关 MySql 可以建立多个服务器（实例）

相关 Mysql多实例安装

相关 prometheus监控多个MySQL实例