Mysql多实例配置文档
一、安装cmakeyuminstall 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 = /usr/local/mysql5/bin/mysqld
mysqladmin = /usr/local/mysql5/bin/mysqladmin
# 第一个mysqld实例
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实例
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实例
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实例
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
页:
[1]