Mysql多实例配置文档

2322312

一、安装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