MySQL5.6.35數(shù)據(jù)庫使用多實(shí)例二進(jìn)制安裝詳細(xì)步驟
下面一起來了解下MySQL5.6.35數(shù)據(jù)庫使用多實(shí)例二進(jìn)制安裝詳細(xì)步驟，相信大家看完肯定會(huì)受益匪淺，文字在精不在多，希望MySQL5.6.35數(shù)據(jù)庫使用多實(shí)例二進(jìn)制安裝詳細(xì)步驟這篇短內(nèi)容是你想要的。
創(chuàng)新互聯(lián)主要從事網(wǎng)站設(shè)計(jì)制作、成都做網(wǎng)站、網(wǎng)頁設(shè)計(jì)、企業(yè)做網(wǎng)站、公司建網(wǎng)站等業(yè)務(wù)。立足成都服務(wù)來賓,10年網(wǎng)站建設(shè)經(jīng)驗(yàn),價(jià)格優(yōu)惠、服務(wù)專業(yè),歡迎來電咨詢建站服務(wù):18982081108
一、軟件包
wget -q http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz
二、解壓移動(dòng)
tar xf mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz
mkdir -p /application/mysql
mv mysql-5.6.35-linux-glibc2.5-x86_64 /application/mysql/mysql-5.6.35
useradd -s /sbin/nologin -M mysql
chown -R mysql.mysql /application/mysql/
cd /application/mysql/mysql-5.6.35/
三、系統(tǒng)設(shè)置
3.1關(guān)閉iptables
臨時(shí)關(guān)閉：service iptables stop
永久關(guān)閉：chkconfig iptables off
3.2關(guān)閉selinux
vi /etc/sysconfig/selinux
將SELINUX修改為DISABLED，即SELINUX=DISABLED
3.3環(huán)境變量
echo ' exportPATH=/application/mysql/mysql-5.6.35/bin:$PATH
' >> /etc/profile
source /etc/profile
tail -1/etc/profile
exportPATH=/application/mysql/mysql-5.6.35/bin:$PATH
四、配置mysql
4.1創(chuàng)建相關(guān)目錄
mkdir -p/data/{3306，3307}
mkdir -p/data/3306/ {data,log,tmp}
mkdir -p/data/3307/ {data,log,tmp}
4.2更改目錄權(quán)限
chown -Rmysql:mysql /data/
chown -Rmysql:mysql /application/mysql/
4.3復(fù)制my.cnf文件到etc目錄
cp /application/mysql/mysql-5.6.35/support-files/my-default.cnf/etc/my.cnf
4.4修改my.cnf（在一個(gè)文件中修改即可）
cat /etc/my.cnf
[client]
port=3306
socket=/tmp/mysql.sock
[mysqld_multi]
mysqld =/application/mysql/mysql-5.6.35/bin/mysqld_safe
mysqladmin =/application/mysql/mysql-5.6.35/bin/mysqladmin
log =/data/mysqld_multi.log
[mysqld]
user=mysql
basedir =/application/mysql/mysql-5.6.35
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysqld3306]
mysqld=mysqld
mysqladmin=mysqladmin
datadir=/data/3306/data
port=3306
server_id=3306
socket=/tmp/mysql_3306.sock
log-output=file
slow_query_log =1
long_query_time= 1
slow_query_log_file= /data/3306/log/slow.log
log-error =/data/3306/log/error.log
binlog_format =mixed
log-bin =/data/3306/log/mysql3306_bin
[mysqld3307]
mysqld=mysqld
mysqladmin=mysqladmin
datadir=/data/3307/data
port=3307
server_id=3307
socket=/tmp/mysql_3307.sock
log-output=file
slow_query_log =1
long_query_time= 1
slow_query_log_file= /data/3307/log/slow.log
log-error =/data/3307/log/error.log
binlog_format =mixed
log-bin =/data/3307/log/mysql3307_bin
4.5初始化數(shù)據(jù)庫
初始化3306數(shù)據(jù)庫
/application/mysql/mysql-5.6.35/scripts/mysql_install_db --basedir=/usr/local/mysql/ --datadir=/data/3306/data--defaults-file=/etc/my.cnf
初始化3307數(shù)據(jù)庫
/application/mysql/mysql-5.6.35/scripts/mysql_install_db --basedir=/usr/local/mysql/ --datadir=/data/3307/data--defaults-file=/etc/my.cnf
檢查數(shù)據(jù)庫是否初始化成功
出現(xiàn)兩個(gè)”O(jiān)K”
4.6查看數(shù)據(jù)庫是否初始化成功
查看3306數(shù)據(jù)庫
ls /data/mysql/mysql_3306/data
auto.cnf ibdata1 ib_logfile0 ib_logfile1 mysql mysql.pid performance_schema test
查看3307數(shù)據(jù)庫
Ls /data/mysql/mysql_3307/data
auto.cnf ibdata1 ib_logfile0 ib_logfile1 mysql mysql.pid performance_schema test
4.7設(shè)置啟動(dòng)文件
cp /application/mysql/mysql-5.6.35/support-files/mysql.server/etc/init.d/mysql
五、啟動(dòng)維護(hù)
5.1啟動(dòng)全部實(shí)例
/application/mysql/mysql-5.6.35/bin/mysqld_multi start
/application/mysql/mysql-5.6.35/bin/mysqld_multi report
看完MySQL5.6.35數(shù)據(jù)庫使用多實(shí)例二進(jìn)制安裝詳細(xì)步驟這篇文章后，很多讀者朋友肯定會(huì)想要了解更多的相關(guān)內(nèi)容，如需獲取更多的行業(yè)信息，可以關(guān)注我們的行業(yè)資訊欄目。
網(wǎng)站標(biāo)題：MySQL5.6.35數(shù)據(jù)庫使用多實(shí)例二進(jìn)制安裝詳細(xì)步驟
文章路徑：http://www.jiaotiyi.com/article/pjhocp.html