mysql安装步骤

1、安装相关资源
yum install pcre-devel
yum install zlib-devel
yum install openssl-devel
安装cmake地址：http://www.cnblogs.com/mophee/archive/2013/03/19/2969456.html
安装yum install ncurses-devel

安装mysql
参考资料：http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html#multiple-unix-servers
下载源码包：sudo wget -c wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.16.tar.gz

1.解压(解压两个文件，方便分别编译)：
sudo mkdir 1-mysql-5.6.16
sudo tar -xzvf mysql-5.6.16.tar.gz -C 1-mysql-5.6.16
sudo mkdir 2-mysql-5.6.16
sudo tar -xzvf mysql-5.6.16.tar.gz -C 2-mysql-5.6.16
sudo mkdir 3-mysql-5.6.16
sudo tar -xzvf mysql-5.6.16.tar.gz -C 3-mysql-5.6.16

2.建立要安装的目录：sudo mkdir -p /home/moon/db
sudo groupadd mysql
sudo useradd -g mysql mysql

3.进入每个节点对应源码目录，如：cd 1-mysql-5.6.16
(注意：每个节点的configure都不一样)
cmake -DCMAKE_INSTALL_PREFIX=/home/moon/db/mysql_1 -DMYSQL_DATADIR=/mnt/data/moon/db/data_1 -DMYSQL_TCP_PORT=5001 -DMYSQL_UNIX_ADDR=/home/moon/db/mysql_1/var/mysql.sock -DSYSCONFDIR=/home/moon/db/mysql_1/etc -DDEFAULT_CHARSET=utf8 -DMYSQL_USER=mysql -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_READLINE=1 -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1
cmake -DCMAKE_INSTALL_PREFIX=/home/moon/db/mysql_2 -DMYSQL_DATADIR=/mnt/data/moon/db/data_2 -DMYSQL_TCP_PORT=5002 -DMYSQL_UNIX_ADDR=/home/moon/db/mysql_2/var/mysql.sock -DSYSCONFDIR=/home/moon/db/mysql_2/etc -DDEFAULT_CHARSET=utf8 -DMYSQL_USER=mysql -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_READLINE=1 -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1
cmake -DCMAKE_INSTALL_PREFIX=/home/moon/db/mysql_3 -DMYSQL_DATADIR=/mnt/data/moon/db/data_3 -DMYSQL_TCP_PORT=5003 -DMYSQL_UNIX_ADDR=/home/moon/db/mysql_3/var/mysql.sock -DSYSCONFDIR=/home/moon/db/mysql_3/etc -DDEFAULT_CHARSET=utf8 -DMYSQL_USER=mysql -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_READLINE=1 -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1
cmake -DCMAKE_INSTALL_PREFIX=/home/moon/db/mysql_4 -DMYSQL_DATADIR=/mnt/data/moon/db/data_4 -DMYSQL_TCP_PORT=5004 -DMYSQL_UNIX_ADDR=/home/moon/db/mysql_4/var/mysql.sock -DSYSCONFDIR=/home/moon/db/mysql_4/etc -DDEFAULT_CHARSET=utf8 -DMYSQL_USER=mysql -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_READLINE=1 -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1
cmake -DCMAKE_INSTALL_PREFIX=/home/moon/db/mysql_5 -DMYSQL_DATADIR=/mnt/data/moon/db/data_5 -DMYSQL_TCP_PORT=5005 -DMYSQL_UNIX_ADDR=/home/moon/db/mysql_5/var/mysql.sock -DSYSCONFDIR=/home/moon/db/mysql_5/etc -DDEFAULT_CHARSET=utf8 -DMYSQL_USER=mysql -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_READLINE=1 -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1
cmake -DCMAKE_INSTALL_PREFIX=/home/moon/db/mysql_6 -DMYSQL_DATADIR=/mnt/data/moon/db/data_6 -DMYSQL_TCP_PORT=5006 -DMYSQL_UNIX_ADDR=/home/moon/db/mysql_6/var/mysql.sock -DSYSCONFDIR=/home/moon/db/mysql_6/etc -DDEFAULT_CHARSET=utf8 -DMYSQL_USER=mysql -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_READLINE=1 -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1


./configure --prefix=/home/moon/db/mysql_2 --with-plugins=all --localstatedir=/mnt/data/moon/db/data_2 --with-tcp-port=5002 --with-unix-socket-path=/home/moon/db/mysql_2/var/mysql.sock --sysconfdir=/home/moon/db/mysql_2/etc --enable-assembler --with-mysqld-ldflags=-all-static --with-charset=utf8 --with-mysqld-user=mysql

sudo make

sudo make install

4.在安装目录下建立目录./etc, ./var, ./tmp
sudo mkdir etc var tmp

5.拷贝并修改my.cnf，参考我们自己的模板配置
sudo cp /home/kyle/my1.cnf /home/moon/db/mysql_1/etc/my.cnf
sudo cp /home/kyle/my2.cnf /home/moon/db/mysql_2/etc/my.cnf

6.为temp增加权限
sudo chown -R mysql /home/moon/db/mysql_1/tmp
sudo chown -R mysql /home/moon/db/mysql_2/tmp

7.初始化数据库：
sudo /home/moon/db/mysql_1/scripts/mysql_install_db --basedir=/home/moon/db/mysql_1 --datadir=/mnt/data/moon/db/data_1 --user=mysql --defaults-file=/home/moon/db/mysql_1/etc/my.cnf
sudo /home/moon/db/mysql_2/scripts/mysql_install_db --basedir=/home/moon/db/mysql_2 --datadir=/mnt/data/moon/db/data_2 --user=mysql --defaults-file=/home/moon/db/mysql_2/etc/my.cnf
sudo /home/moon/db/mysql_3/scripts/mysql_install_db --basedir=/home/moon/db/mysql_3 --datadir=/mnt/data/moon/db/data_3 --user=mysql --defaults-file=/home/moon/db/mysql_3/etc/my.cnf
sudo /home/moon/db/mysql_4/scripts/mysql_install_db --basedir=/home/moon/db/mysql_4 --datadir=/mnt/data/moon/db/data_4 --user=mysql --defaults-file=/home/moon/db/mysql_4/etc/my.cnf
sudo /home/moon/db/mysql_5/scripts/mysql_install_db --basedir=/home/moon/db/mysql_5 --datadir=/mnt/data/moon/db/data_5 --user=mysql --defaults-file=/home/moon/db/mysql_5/etc/my.cnf
sudo /home/moon/db/mysql_6/scripts/mysql_install_db --basedir=/home/moon/db/mysql_6 --datadir=/mnt/data/moon/db/data_6 --user=mysql --defaults-file=/home/moon/db/mysql_6/etc/my.cnf

8.更改目录权限：
sudo chown -R root .
mkdir -p  /mnt/data/moon/db/data_1/var
sudo chown -R mysql  /mnt/data/moon/db/data_1/var
sudo chown -R mysql var
sudo chown -R mysql tmp
sudo chgrp -R mysql .
sudo chown -R mysql /mnt/data/moon/db/data_1
sudo chown -R mysql /mnt/data/moon/db/data_2

9.启动mysql：
sudo /home/moon/db/mysql_1/bin/mysqld_safe --defaults-file=/home/moon/db/mysql_1/etc/my.cnf --user=mysql &
sudo /home/moon/db/mysql_2/bin/mysqld_safe --defaults-file=/home/moon/db/mysql_2/etc/my.cnf --user=mysql &
sudo /home/moon/db/mysql_3/bin/mysqld_safe --defaults-file=/home/moon/db/mysql_3/etc/my.cnf --user=mysql &
sudo /home/moon/db/mysql_4/bin/mysqld_safe --defaults-file=/home/moon/db/mysql_4/etc/my.cnf --user=mysql &
sudo /home/moon/db/mysql_5/bin/mysqld_safe --defaults-file=/home/moon/db/mysql_5/etc/my.cnf --user=mysql &
sudo /home/moon/db/mysql_6/bin/mysqld_safe --defaults-file=/home/moon/db/mysql_6/etc/my.cnf --user=mysql &


10.使用客户端测试连接mysql server：
mysql -h127.0.0.1 -P5001 -uroot --default-character-set=utf8
mysql -h127.0.0.1 -P5002 -uroot --default-character-set=utf8