MySQL-5.6.36.tar.gz多实例安装
查看官方安装说明
more INSTALL-SOURCE
安装cmake及相关依赖包
yum install -y cmake gcc
[root@vhost1 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.0 (Maipo)
[root@vhost1 ~]# yum install ncurses-devel -y #使应用程序直接控制终端屏幕显示的库
创建用户和组
[root@vhost1 ~]#groupadd -g 200 mysql
[root@vhost1 ~]#useradd mysql -u 200 -s /sbin/nologin -M -g mysql
创建安装MySQL软件目录
[root@vhost1 ~]#mkdir -p /application/mysql-5.6.36
解压编译MySQL
[root@vhost1 ~]#cd mysql-5.6.36
[root@vhost1 mysql-5.6.36]#
cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.6.36
-DMYSQL_DATADIR=/application/mysql-5.6.36/data
-DMYSQL_UNIX_ADDR=/application/mysql-5.6.36/tmp/mysql.sock
-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii
-DENABLED_LOCAL_INFILE=ON
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_FEDERATED_STORAGE_ENGINE=1
-DWITH_BLACKHOLE_STORAGE_ENGINE=1
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1
-DWITHOUT_PARTITION_STORAGE_ENGINE=1
-DWITH_FAST_MUTEXES=1
-DWITH_ZLIB=bundled
-DENABLED_LOCAL_INFILE=1
-DWITH_READLINE=1
-DWITH_EMBEDDED_SERVER=1
-DWITH_DEBUG=0
-DWITHOUT_PARTITION_STORAGE_ENGINE=0
[root@vhost1 mysql-5.6.36]# make && make install
#修改安装目录权限为mysql
[root@vhost1 ~]#cd /application
[root@vhost1 ~]#chown -R mysql .
[root@vhost1 ~]#chgrp -R mysql .
创建实例目录：
[root@vhost1 ~]#mkdir -p /mysqldata/3306/data
[root@vhost1 ~]#mkdir -p /mysqldata/3307/data
拷贝配置文件模板和启动脚本模板
[root@vhost1 mysql]# cp support-files/my-default.cnf /mysqldata/3306/my.cnf
[root@vhost1 mysql]# cp support-files/mysql.server /mysqldata/3306/mysql
修改权限
[root@vhost1 ~]#chown -R mysql.mysql /mysqldata/3306
[root@vhost1 ~]#chmod -R 755 /mysqldata/3306
修改配置文件
[root@vhost1 ~]#vi /mysqldata/3306/my.cnf
[mysqld] user = mysql basedir = /application/mysql datadir = /mysqldata/3306/data port = 3306 server_id = 1 socket = /mysqldata/3306/data/mysql3306.sock log-error = /mysqldata/3306/mysql3306_error.log pid-file = /mysqldata/3306/mysql3306.pid
#初始化数据库实例
scripts/mysql_install_db --defaults-file=/mysqldata/3306/my.cnf
#启动数据库
bin/mysqld_safe --defaults-file=/mysqldata/3306/my.cnf &
#查看进程
ps aux |grep mysql
#命令行通过socket进入数据库
[root@vhost1 ~]#mysql -uroot -p -S /mysqldata/3306/mysql3306.sock
#修改脚本（官方给的太复杂，问题也多，下面是简化官方后的脚本）
[root@vhost1 ~]#vi /mysqldata/3306/mysql
#!/bin/sh basedir=/application/mysql datadir=/mysqldata/3306/data bindir=$basedir/bin service_startup_timeout=900 lsb_functions="/lib/lsb/init-functions" if test -f $lsb_functions ; then . $lsb_functions else log_success_msg() { echo " SUCCESS! $@" } log_failure_msg() { echo " ERROR! $@" } fi wait_for_pid () { verb="$1" # created | removed pid="$2" # process ID of the program operating on the pid-file pid_file_path="$3" # path to the PID file. i=0 avoid_race_condition="by checking again" while test $i -ne $service_startup_timeout ; do case "$verb" in 'created') # wait for a PID-file to pop into existence. test -s "$pid_file_path" && i='' && break ;; 'removed') # wait for this PID-file to disappear test ! -s "$pid_file_path" && i='' && break ;; *) echo "wait_for_pid () usage: wait_for_pid created|removed pid pid_file_path" exit 1 ;; esac # if server isn't running, then pid-file will never be updated if test -n "$pid"; then if kill -0 "$pid" 2>/dev/null; then : # the server still runs else # The server may have exited between the last pid-file check and now. if test -n "$avoid_race_condition"; then avoid_race_condition="" continue # Check again. fi # there's nothing that will affect the file. log_failure_msg "The server quit without updating PID file ($pid_file_path)." return 1 # not waiting any more. fi fi echo $echo_n ".$echo_c" i=`expr $i + 1` sleep 1 done if test -z "$i" ; then log_success_msg return 0 else log_failure_msg return 1 fi } mysqld_pid_file_path=$datadir/../mysql3306.pid mode=$1 # start or stop case "$mode" in 'start') # Start daemon # Safeguard (relative paths, core dumps..) cd $basedir echo $echo_n "Starting MySQL" if test -x $bindir/mysqld_safe then # Give extra arguments to mysqld with the my.cnf file. This script # may be overwritten at next upgrade. $bindir/mysqld_safe --defaults-file=$datadir/../my.cnf >/dev/null 2>&1 & wait_for_pid created "$!" "$mysqld_pid_file_path"; return_value=$? # Make lock for RedHat / SuSE if test -w "$lockdir" then touch "$lock_file_path" fi exit $return_value else log_failure_msg "Couldn't find MySQL server ($bindir/mysqld_safe)" fi ;; 'stop') # Stop daemon. We use a signal here to avoid having to know the # root password. if test -s "$mysqld_pid_file_path" then mysqld_pid=`cat "$mysqld_pid_file_path"` if (kill -0 $mysqld_pid 2>/dev/null) then echo $echo_n "Shutting down MySQL" kill $mysqld_pid # mysqld should remove the pid file when it exits, so wait for it. wait_for_pid removed "$mysqld_pid" "$mysqld_pid_file_path"; return_value=$? else log_failure_msg "MySQL server process #$mysqld_pid is not running!" rm "$mysqld_pid_file_path" fi # Delete lock for RedHat / SuSE if test -f "$lock_file_path" then rm -f "$lock_file_path" fi exit $return_value else log_failure_msg "MySQL server PID file could not be found!" fi ;; 'restart') # Stop the service and regardless of whether it was # running or not, start it again. if $datadir/../mysql stop $other_args; then $datadir/../mysql start $other_args else log_failure_msg "Failed to stop running server, so refusing to try to start." exit 1 fi ;; 'reload'|'force-reload') if test -s "$mysqld_pid_file_path" ; then read mysqld_pid < "$mysqld_pid_file_path" kill -HUP $mysqld_pid && log_success_msg "Reloading service MySQL" touch "$mysqld_pid_file_path" else log_failure_msg "MySQL PID file could not be found!" exit 1 fi ;; 'status') # First, check to see if pid file exists if test -s "$mysqld_pid_file_path" ; then read mysqld_pid < "$mysqld_pid_file_path" if kill -0 $mysqld_pid 2>/dev/null ; then log_success_msg "MySQL running ($mysqld_pid)" exit 0 else log_failure_msg "MySQL is not running, but PID file exists" exit 1 fi else # Try to find appropriate mysqld process mysqld_pid=`pidof $libexecdir/mysqld` # test if multiple pids exist pid_count=`echo $mysqld_pid | wc -w` if test $pid_count -gt 1 ; then log_failure_msg "Multiple MySQL running but PID file could not be found ($mysqld_pid)" exit 5 elif test -z $mysqld_pid ; then if test -f "$lock_file_path" ; then log_failure_msg "MySQL is not running, but lock file ($lock_file_path) exists" exit 2 fi log_failure_msg "MySQL is not running" exit 3 else log_failure_msg "MySQL is running but PID file could not be found" exit 4 fi fi ;; *) # usage echo "Usage: $datadir/../mysql {start|stop|restart|reload|force-reload|status}" exit 1 ;; esac exit 0
#脚本使用方法
[root@vhost1 ~]#chmod u+x /mysqldata/3306/mysql
[root@vhost1 ~]#/mysqldata/3306/mysql stop