MySQL single-instance and multi-instance installation _ MySQL

[Single instance installation] description: that is, only one service, a port sed-i2slocalhost.localdomainmysqletcsysconfignetworkhostnamemysqlyum-yinstallncurses-develgccgcc-c + + useraddmysql-ssbin... [single instance installation]

Note: only one service and one port are provided.

Sed-I 2 s/localhost. localdomain/mysql // etc/sysconfig/network

Hostname mysql

Yum-y install ncurses-devel gcc-c ++

Useradd mysql-s/sbin/nologin-M

Tar xf cmake-2.8.8.tar.gz

Cd cmake-2.8.8

./Configure

Gmake

Gmake install

Cd ..

Tar xf mysql-5.5.32.tar.gz

Cd mysql-5.5.32

Cmake.-DCMAKE_INSTALL_PREFIX =/usr/local/mysql \

-DMYSQL_DATADIR =/usr/local/mysql/data \

-DMYSQL_UNIX_ADDR =/usr/local/mysql/tmp/mysql. sock \

-DDEFAULT_CHARSET = utf8 \

-DDEFAULT_COLLATION = utf8_general_ci \

-DEXTRA_CHARSETS = gbk, gb2312, utf8, ascii \

-DENABLED_LOCAL_INFILE = ON \

-DWITH_INNOBASE_STORAGE_ENGINE = 1 \

-DWITH_FEDERATED_STORAGE_ENGINE = 1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE = 1 \

-DWITHOUT_EXAMPLE_STORAGE_ENGINE = 1 \

-DWITHOUT_PARTITION_STORAGE_ENGINE = 1 \

-DWITH_ZLIB = bundled \

-DENABLED_LOCAL_INFILE = 1 \

-DWITH_READLINE = 1 \

-DWITH_EMBEDDED_SERVER = 1 \

-DWITH-DEBUG = 0

Make & make install

Cp support-files/my-small.cnf/etc/my. cnf

Ln-s/usr/local/mysql/bin/*/usr/local/sbin

Chmod-R 1777/tmp

Chown-R mysql: mysql/usr/local/mysql

Cd/usr/local/mysql/scripts/

./Mysql_install_db -- basedir =/usr/local/mysql/-- datadir =/usr/local/mysql/data/-- user = mysql

Cp/opt/mysql-5.5.32/support-files/mysql. server/etc/init. d/mysqld

Chmod + x/etc/init. d/mysqld

Service mysqld start

Chkconfig mysqld on

Mysql-e "delete from mysql. user where user = '';"

Mysql-e "delete from mysql. user where host = 'localhost. localdomain ';"

Mysql-e "delete from mysql. user where host = ': 1 ';"

Mysql-e "drop database test ;"

Mysqladmin-u root password "wsyht123"

Multi-instance installation]

Description: Multi-instance refers to multiple ports and multiple MySQL instances provide services.

Sed-I 2 s/localhost. localdomain/mysql // etc/sysconfig/network

Hostname mysql

Yum-y install ncurses-devel gcc-c ++ libaio-devel

Useradd mysql-s/sbin/nologin-M

Tar xf cmake-2.8.8.tar.gz

Cd cmake-2.8.8

./Configure

Gmake

Gmake install

Cd ..

Tar xf mysql-5.5.32.tar.gz

Cd mysql-5.5.32

Cmake.-DCMAKE_INSTALL_PREFIX =/usr/local/mysql \

-DMYSQL_DATADIR =/usr/local/mysql/data \

-DMYSQL_UNIX_ADDR =/usr/local/mysql/tmp/mysql. sock \

-DDEFAULT_CHARSET = utf8 \

-DDEFAULT_COLLATION = utf8_general_ci \

-DEXTRA_CHARSETS = gbk, gb2312, utf8, ascii \

-DENABLED_LOCAL_INFILE = ON \

-DWITH_INNOBASE_STORAGE_ENGINE = 1 \

-DWITH_FEDERATED_STORAGE_ENGINE = 1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE = 1 \

-DWITHOUT_EXAMPLE_STORAGE_ENGINE = 1 \

-DWITHOUT_PARTITION_STORAGE_ENGINE = 1 \

-DWITH_ZLIB = bundled \

-DENABLED_LOCAL_INFILE = 1 \

-DWITH_READLINE = 1 \

-DWITH_EMBEDDED_SERVER = 1 \

-DWITH-DEBUG = 0

Make & make install

Ln-s/usr/local/mysql/bin/*/usr/local/sbin

Chmod 700/opt/mysql

Mkdir-p/data/{3306, 3307, 3308}

Cp/opt/my. cnf/data/3306/

Cp/opt/my. cnf/data/3307/

Cp/opt/my. cnf/data/3308/

Cp/opt/mysql/data/3306

Cp/opt/mysql/data/3307

Cp/opt/mysql/data/3308

Chmod-R 1777/tmp

Chown-R mysql: mysql/data

Chown-R mysql: mysql/usr/local/mysql

Cd/usr/local/mysql/scripts

./Mysql_install_db -- basedir =/usr/local/mysql/-- datadir =/data/3306/data/-- user = mysql

./Mysql_install_db -- basedir =/usr/local/mysql/-- datadir =/data/3307/data/-- user = mysql

./Mysql_install_db -- basedir =/usr/local/mysql/-- datadir =/data/3308/data/-- user = mysql

/Data/3306/mysql start