Home  >  Article  >  Database  >  MySQL单实例、多实例安装_MySQL

MySQL单实例、多实例安装_MySQL

WBOY
WBOYOriginal
2016-05-27 13:46:361127browse

【单实例安装】

 

说明:即只提供一个服务,一个端口

sed -i 2s/localhost.localdomain/mysql/ /etc/sysconfig/network

hostname mysql

yum -y install ncurses-devel gcc 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"

 

【多实例安装】

 

说明:多实例,指多个端口,多个MySQL提供服务

sed -i 2s/localhost.localdomain/mysql/ /etc/sysconfig/network

hostname mysql

yum -y install ncurses-devel gcc 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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn