1、MySQL單雙執行個體實戰

標籤：mysql 安裝 單雙執行個體部署

###########################################################################################

MySQL單一實例實戰

###########################################################################################

#單一實例安裝，上傳mysql-5.5.32.tar.gz、cmake-2.8.8.tar.gz到opt目錄下

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                        #調整tmp許可權，否則初始化會錯誤

chown -R mysql:mysql /usr/local/mysql     #授權Mysql使用者訪問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 -e "select user,host from mysql.user;"

#mysql -e "grant all privileges on *.* to [email protected]‘localhost‘ identified by ‘wsyht123‘ with grant option;"  #添加額外管理員

#mysql -e "delete from mysql.user;" #可以直接全部刪除

###########################################################################################

    MySQL雙執行個體實戰

###########################################################################################

#雙執行個體安裝，上傳mysql-5.5.32.tar.gz、cmake-2.8.8.tar.gz、my.cnf、mysql到opt目錄下

#修改除了預設3306的MySQL指令碼連接埠，修改除了預設的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

本文出自 “wsyht的部落格” 部落格，請務必保留此出處http://wsyht2015.blog.51cto.com/9014030/1787536

1、MySQL單雙執行個體實戰