源码包编译安装mysql5.6脚本,一个机器安装两个mysql数据库,编译时指定端口,安装路径和socket文件位置。
安装完成的mysql安装文件可以打包复制到别的机器使用,在别的机器使用时候只需要初始化,给相关目录权限既可以。
安装3306端口的mysql:
#!/bin/bash groupadd mysql useradd -g mysql mysql -s /sbin/nologin mkdir /data/3306 chown -R mysql.mysql /data/3306 chmod 755 /data/3306 #mount -o loop /tmp/turbolinux12.iso /mnt/ yum -y install make gcc-c++ cmake bison-devel ncurses-devel openssl openssl-devel bison tar zxf /tmp/mysql-5.6.16.tar.gz -C /usr/local/src/ mv /usr/local/src/mysql-5.6.16/ /usr/local/src/mysql-master #read-n1 var 按任意键继续 read -n1 var cd /usr/local/src/mysql-master cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-master/ -DMYSQL_DATADIR=/data/3306/data -DMYSQL_TCP_PORT=3306 -DMYSQL_UNIX_ADDR=/var/run/mysqld/mysql-master.sock -DSYSCONFDIR=/usr/local/mysql-master -DDEFAULT_CHARSET=gbk -DDEFAULT_COLLATION=gbk_chinese_ci -DWITH_EXTRA_CHARSETS=ALL -DMYSQL_USER=mysql read -n1 var make read -n1 var make install read -n1 var chown -R mysql.mysql /usr/local/mysql-master /usr/local/mysql-master/scripts/mysql_install_db --basedir=/usr/local/mysql-master --datadir=/data/3306/data --user=mysql cp /usr/local/mysql-master/support-files/mysql.server /etc/init.d/mysqld-master read -n1 var chmod +x /etc/init.d/mysqld-master chkconfig --add mysqld-master chkconfig mysqld-master on /etc/init.d/mysqld-master start
安装3307端口的mysql:
#!/bin/bash groupadd mysql useradd -g mysql mysql -s /sbin/nologin mkdir /data/3307 chown -R mysql.mysql /data/3307 chmod 755 /data/3307 #mount -o loop /tmp/turbolinux12.iso /mnt/ yum -y install make gcc-c++ cmake bison-devel ncurses-devel openssl openssl-devel bison tar zxf /tmp/mysql-5.6.16.tar.gz -C /usr/local/src/ mv /usr/local/src/mysql-5.6.16/ /usr/local/src/mysql-slave read -n1 var cd /usr/local/src/mysql-slave cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-slave/ -DMYSQL_DATADIR=/data/3307/data -DMYSQL_TCP_PORT=3307 -DMYSQL_UNIX_ADDR=/var/run/mysqld/mysql-slave.sock -DSYSCONFDIR=/usr/local/mysql-slave -DDEFAULT_CHARSET=gbk -DDEFAULT_COLLATION=gbk_chinese_ci -DWITH_EXTRA_CHARSETS=ALL -DMYSQL_USER=mysql read -n1 var make read -n1 var make install read -n1 var chown -R mysql.mysql /usr/local/mysql-slave /usr/local/mysql-slave/scripts/mysql_install_db --basedir=/usr/local/mysql-slave --datadir=/data/3307/data --user=mysql cp /usr/local/mysql-slave/support-files/mysql.server /etc/init.d/mysqld-slave read -n1 var chmod +x /etc/init.d/mysqld-slave chkconfig --add mysqld-slave chkconfig mysqld-slave on /etc/init.d/mysqld-slave start