九.mysql資料庫多執行個體安裝

標籤：ror   style   sql_mod   mysql資料庫   l資料庫   art   mysql   結構   目錄   

經常應為系統硬體短缺，導致需要在同一台硬體伺服器上面安裝多個mysql執行個體

1.在mysql使用者目錄下建立mysql3306，mysql3307，mysql3308三個檔案夾，並分別在這三個檔案夾下建立data,log,tmp檔案夾，總體目錄結構如下

     /home/mysql

            ├── mysql3306

                        ├──data

                        ├──log

                        ├──tmp

            ├── mysql3307

                        ├──data

                        ├──log

                        ├──tmp

            ├── mysql3308

                        ├──data

                        ├──log

                        ├──tmp

2.配置my.cnf檔案

[client]port=3306socket=/tmp/mysql.sock [mysqld_multi]mysqld=/usr/local/mysql/bin/mysqld_safemysqladmin=/usr/local/mysql/bin/mysqladminlog=/home/mysql/mysqld_multi.log[mysqld]user=mysqlbasedir=/usr/local/mysqlsql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES[mysqld3306]  mysqld=mysqld  mysqladmin=mysqladmin  datadir=/home/mysql/mysql3306/data  port=3306  server_id=3306  socket=/tmp/mysql3306.sock  log-output=file  slow_query_log = 1  long_query_time = 1  slow_query_log_file = /home/mysql/mysql3306/log/slow.log  log-error = /home/mysql/mysql3306/log/error.log  binlog_format = mixed  log-bin = /home/mysql/mysql3306/log/mysql3306_bin[mysqld3307]mysqld=mysqldmysqladmin=mysqladmindatadir=/home/mysql/mysql3307/dataport=3307server_id=3307socket=/tmp/mysql3307.socklog-output=fileslow_query_log = 1long_query_time = 1slow_query_log_file = /home/mysql/mysql3307/log/slow.loglog-error = /home/mysql/mysql3307/log/error.logbinlog_format = mixedlog-bin = /home/mysql/mysql3307/log/mysql3307_bin[mysqld3308]mysqld=mysqldmysqladmin=mysqladmindatadir=/home/mysql/mysql3308/dataport=3308server_id=3308socket=/tmp/mysql3308.socklog-output=fileslow_query_log = 1long_query_time = 1slow_query_log_file = /home/mysql/mysql3308/log/slow.loglog-error = /home/mysql/mysql3308/log/error.logbinlog_format = mixedlog-bin = /home/mysql/mysql3308/log/mysql3308_bin

 

3.運行mysqld_multi

# 啟動
/usr/local/mysql/bin/mysqld_multi start  

# 停止
/usr/local/mysql/bin/mysqld_multi stop  

# 查詢狀態
/usr/local/mysql/bin/mysqld_multi report  

 

九.mysql資料庫多執行個體安裝