Mysql多執行個體配置文檔

標籤：linux   配置   mysql   文檔   local   

                     

 

一、安裝cmake

    yuminstall gcc gcc-c++ ncurses-devel perl    #安裝前準備

    wgethttp://wwwNaNake.org/files/v2.8/cmake-2.8.10.2.tar.gz  

    tar-xzvf cmake-2.8.10.2.tar.gz  

    cdcmake-2.8.10.2  

    ./bootstrap

     make&& make install

二、安裝mysql

    groupaddmysql
    useradd -g mysql mysql
    cmake.-DCMAKE_INSTALL_PREFIX=/usr/local/mysql5/ 

    -DMYSQL_DATADIR=/data/mysql -DWITH_INNOBASE_STORAGE_ENGINE=1 

    -DMYSQL_TCP_PORT=3306  -DMYSQL_UNIX_ADDR=/var/run/mysql/mysql.sock

    -DWITH_DEBUG=0
    make -j 2 && make install

    報錯處理：

   編譯mysql出現CMake Errorat cmake/readlineNaNake:83 (MESSAGE) 

 

   該報錯原因是未安裝ncurses-devel，運行下面命令

   第一步：安裝

   #yum-y install ncurses-devel

 

   第二步：刪除CMakeCache.txt

   通過find命令找到所有CMakeCache.txt文檔的位置

   #find/ -name CMakeCache.txt

   然後全部刪除：

   #rm -rf /usr/local/src/cmake-2.8.6/Tests/Complex/Cache/CMakeCache.txt

   #rm -rf /usr/local/src/cmake-2.8.6/Tests/ComplexOneConfig/Cache/CMakeCache.txt

   #rm -rf /usr/local/src/cmake-2.8.6/Tests/ComplexRelativePaths/Cache/CMakeCache.txt

   #rm -rf /usr/local/src/mysql-5.5.18/CMakeCache.txt

   .........

   全部刪除後再重新cmake就OK了。

三、配置Mysql

  從support-files裡面拷貝一個my-medium.cnf到/etc/my.cnf，清空裡面預設配置，添加如下配置：

     # mysqld_multi會讀取這個配置短的內容
[mysqld_multi]
mysqld = /usr/local/mysql5/bin/mysqld
mysqladmin = /usr/local/mysql5/bin/mysqladmin

# 第一個mysqld執行個體
[mysqld1]
port = 3306
socket = /var/run/mysql/mysql1.sock
datadir = /data/mysql1
general-log-file = /var/log/mysql/error.log
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log-bin=mysql-bin
binlog_format=mixed
server-id       = 1
user = mysql

# 第二個mysqld執行個體
[mysqld2]
port = 3307
socket = /var/run/mysql/mysql2.sock
datadir = /data/mysql2
general-log-file = /var/log/mysql/error.log
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log-bin=mysql-bin
binlog_format=mixed
server-id       = 1
user = mysql

# 第三個mysqld執行個體
[mysqld3]
port = 3308

socket = /var/run/mysql/mysql3.sock
datadir = /data/mysql3
general-log-file = /var/log/mysql/error.log
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log-bin=mysql-bin
binlog_format=mixed
server-id       = 1
user = mysql

# 第四個mysqld執行個體
[mysqld4]
port = 3309
socket = /var/run/mysql/mysql4.sock
datadir = /data/mysql4
general-log-file = /var/log/mysql/error.log
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log-bin=mysql-bin
binlog_format=mixed
server-id       = 1
user = mysql

mkdir -p /data/mysql1 /data/mysql2 /data/mysql3 /data/mysql4/var/log/mysql /var/run/mysql

chgrp mysql /data/mysql* /var/log/mysql /var/run/mysql

chown mysql /data/mysql* /var/log/mysql/var/run/mysql

/usr/local/mysql5/scripts/mysql_install_db---datadir=/data/mysql1 --user=mysql --basedir=/usr/local/mysql5

/usr/local/mysql5/scripts/mysql_install_db---datadir=/data/mysql2 --user=mysql --basedir=/usr/local/mysql5

/usr/local/mysql5/scripts/mysql_install_db---datadir=/data/mysql3 --user=mysql --basedir=/usr/local/mysql5

/usr/local/mysql5/scripts/mysql_install_db---datadir=/data/mysql4 --user=mysql --basedir=/usr/local/mysql5

vi /etc/profile

添加export PATH=/usr/local/mysql5/bin:$PATH 欄位

source /etc/profile

mysqld_multi start 1-4

 

進入資料庫某個執行個體：

mysql -S  /var/run/mysql/mysql1.sock

更多技術文檔請添加linux系統營運交流群：260431835 每周定時講解linux系統知識

本文出自 “linux系統營運技術交流” 部落格，請務必保留此出處http://fxlinux.blog.51cto.com/4926551/1874262

Mysql多執行個體配置文檔