mysql 添加实例_MySQL系列之D-2------MySQL多实例添加一个实例

D-2.1添加一个实例(3309实例)

D-2.1.1、创建目录

# cd /data

# mkdir 3309/data

D-2.1.2、创建my.cnf文件在/data/3309

[client]

port=3309

socket=/data/3309/mysql.sock

prompt=\\u@hostname \\r:\\m:\\s->

[mysqld]

basedir =/mysql

datadir =/data/3309/data

port =3309

server_id =4

socket =/data/3309/mysql.sock

log-bin=/data/3309/mysql_bin

binlog_format=mixed

#binlog-do-db=

#binlog-ignore-db=

long_query_time=1

relay-log=/data/3309/relay_bin

relay-log-info-file=/data/3309/relay_log.info

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqld_safe]

log-error=/data/3309/mysql_err.log

pid-file=/data/3309/mysql_pid.pid

D-2.1.3、创建mysql文件(启动脚本)

#!/bin/bash

############################################################

#this scripts is created by liuweixinat 2015-06-18

#liuweixin QQ:1433203077

############################################################

#init

port=3309

mysql_user="root"

mysql_pwd="oracle"

CmdPath="/mysql/bin"

mysql_sock="/data/${port}/mysql.sock"

#startup function

function_start_mysql()

{

if[ ! -e "$mysql_sock" ];then

printf"Starting MySQL...\n"

/bin/sh${CmdPath}/mysqld_safe --defaults-file=/data/${port}/my.cnf 2>&1 >/dev/null &

else

printf"MySQL is running...\n"

exit

fi

}

#stop function()

function_stop_mysql()

{

if[ ! -e "$mysql_sock" ];then

printf"Stoping MySQL...\n"

exit

else

printf  "Stoping Mysql...\n"

${CmdPath}/mysqladmin-u ${mysql_user} -p${mysql_pwd} -S /data/${port}/mysql.sock shutdown

fi

}

#restart function

function_restart_mysql()

{

printf"Restarting MySQL...\n"

function_stop_mysql

sleep2

function_start_mysql

}

#function_kill_mysql()

#{

#   kill-9 $(ps -ef | grep 'bin/mysqld_safe' | grep ${mysql_port} | awk '{printf $2}')

#   kill-9 $(ps -ef | grep 'libexec/mysqld' | grep ${mysql_port} | awk '{printf $2}')

#}

case $1 in

start)

function_start_mysql;;

stop)

function_stop_mysql;;

#kill)

# function_kill_mysql;;

restart)

function_restart_mysql;;

*)

printf"Usage:/data/${port}/mysql {start|stop|restart}\n"

esac

D-2.1.4、启动服务

# /data/3309/mysql start

注意：在这里通过netstat -lnt 330,是没有办法看到3309进程的

D-2.1.5、登录3309实例

# mysql -h 127.0.0.1 -uroot -p--port=3309

# mysql -uroot -p -S/data/3309/mysql.sock

注意：新数据库是没有密码的，直接回车即可。