mysql启动多个实例

1 2

mkdir /data/{3306,3307}/data chown -R mysql.mysql /data/{3306,3307}/data

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

#3306 [mysqld] sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES port = 3306 socket = /data/3306/mysql.sock basedir =/usr/local/mysql datadir = /data/3306/data user = mysql pid-file=/data/3306/mysqld.pid character-set-server=utf8 expire_logs_days = 3 skip-external-locking key_buffer_size = 64M max_allowed_packet = 100M table_open_cache = 256 myisam_sort_buffer_size = 16M query_cache_type = 1 log-bin=mysql-bin table_open_cache = 512 innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=4M innodb_buffer_pool_size = 128M key_buffer_size=32M tmp_table_size=32M max_heap_table_size=64M read_buffer_size=4M read_rnd_buffer_size=8M sort_buffer_size=8M max_connections=1024 thread_cache_size=60 query_cache_size=64M wait_timeout=20 [mysql] socket = /data/3306/mysql.sock pid-file=/data/3306/mysqld.pid [mysqldump] socket = /data/3306/mysql.sock pid-file=/data/3306/mysqld.pid quick max_allowed_packet = 100M pid-file=/data/3306/mysqld.pid [mysqladmin] pid-file=/data/3306/mysqld.pid socket = /data/3306/mysql.sock [client] pid-file=/data/3306/mysqld.pid socket = /data/3306/mysql.sock [mysqld_safe] log-error=/data/3306/mysql_3306.err pid-file=/data/3306/mysqld.pid

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49

[mysqld] sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES port = 3307 socket = /data/3307/mysql.sock basedir =/usr/local/mysql datadir = /data/3307/data user = mysql pid-file=/data/3307/mysqld.pid character-set-server=utf8 expire_logs_days = 3 skip-external-locking key_buffer_size = 64M max_allowed_packet = 100M table_open_cache = 256 myisam_sort_buffer_size = 16M query_cache_type = 1 log-bin=mysql-bin table_open_cache = 512 innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=4M innodb_buffer_pool_size = 128M key_buffer_size=32M tmp_table_size=32M max_heap_table_size=64M read_buffer_size=4M read_rnd_buffer_size=8M sort_buffer_size=8M max_connections=1024 thread_cache_size=60 query_cache_size=64M wait_timeout=20 [mysql] socket = /data/3307/mysql.sock pid-file=/data/3307/mysqld.pid [mysqldump] socket = /data/3307/mysql.sock pid-file=/data/3307/mysqld.pid quick max_allowed_packet = 100M pid-file=/data/3307/mysqld.pid [mysqladmin] pid-file=/data/3307/mysqld.pid socket = /data/3307/mysql.sock [client] pid-file=/data/3307/mysqld.pid socket = /data/3307/mysql.sock [mysqld_safe] log-error=/data/3307/mysql_3307.err pid-file=/data/3307/mysqld.pid

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55

#3307启动脚本 #!/bin/sh #init port=3307 mysql_user="root" mysql_pwd="clickwise10050" CmdPath="/usr/local/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 "MySQL is stopped...\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 sleep 2 function_start_mysql } case $1 in start) function_start_mysql ;; stop) function_stop_mysql ;; restart) function_restart_mysql ;; *) printf "Usage: /data/${port}/mysql {start|stop|restart}\n" esac

1 2 3 4 5 6 7

1、进入到MySQL的安装目录 cd /usr/local/mysql 2、执行初始化 cd scripts ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/3306/data ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/3307/data

1 2

/data/3306/mysql start /data/3307/mysql start

1 2 3

2018-04-13 14:46:32 31349 [ERROR] Can't start server : Bind on unix socket: Permission denied 2018-04-13 14:46:32 31349 [ERROR] Do you already have another mysqld server running on socket: /data/3306/mysql.sock ? 2018-04-13 14:46:32 31349 [ERROR] Aborting

1

chmyl -R 755 /data/{3306,3307}/*