CentOS6.7安装mysql-5.5.49(多实例)

1、安装环境

[root@node82 ~]# cat /etc/redhat-release 
CentOS release 6.7 (Final)
[root@node82 ~]# uname -r
2.6.32-573.el6.x86_64
[root@node82 ~]# grep node82 /etc/hosts    #host指向
192.168.0.82    node82

2、安装依赖包

[root@node82 ~]# yum install cmake libaio-devel  ncurses-devel -y
--------------------------------------------cmake源码安装方式
mkdir /home/tools
wget www.cmake.org/files/v2.8/cmake-2.8.0.tar.gz
cd /home/tools
wget www.cmake.org/files/v2.8/cmake-2.8.0.tar.gz
tar -zxvf cmake-2.8.0.tar.gz
cd cmake-2.8.0
./configure
gmake
gmake install
----------------------------------------------

3、创建用户和组以及创建数据库数据目录

[root@node82 tools]#useradd mysql -s /bin/nologin -M
[root@node82 tools]#mkdir -p /data/3306/data
[root@node82 tools]#mkdir -p /data/3307/data
[root@node82 tools]#chown -R mysql.mysql /data

4、开始安装mysql-5.5.49（编译参数https://dev.mysql.com/doc/refman/5.5/en/source-configuration-options.html）

[root@node82 home]# mkdir /home/tools && cd /home/tools
[root@node82 tools]# wget  http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.49.tar.gz
[root@node82 tools]# tar -zxvf mysql-5.5.49.tar.gz
[root@node82 tools]# cd mysql-5.5.49
[root@node82 tools]#cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql5.5.49 \
-DMYSQL_DATADIR=/data \
-DMYSQL_UNIX_ADDR=/usr/local/mysql5.5.49/tmp/mysqld.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITHOUT_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;
[root@node82 tools]#make
[root@node82 tools]#make install 
[root@node82 tools]#ln -s /usr/local/mysql5.5.49 /usr/local/mysql
[root@node82 tools]#chown -R mysql.mysql /usr/local/mysql

5、环境变量修改

[root@node82 tools]#echo 'export PATH=/usr/local/mysql/bin:$PATH' >>/etc/profile
[root@node82 tools]#source /etc/profile
[root@node82 tools]#echo $PATH

6、配置单独的配置文件及启动脚本(在/data/3307下同样创建，对内容作相应修改)

　　[root@node82 mysql-5.5.49]# vi /data/3306/my.cnf

[client]
port            = 3306
socket          = /data/3306/mysql.sock

[mysql]
no-auto-rehash

[mysqld]
user    = mysql
port    = 3306
socket  = /data/3306/mysql.sock
basedir = /usr/local/mysql
datadir = /data/3306/data
open_files_limit    = 1024
back_log = 600
max_connections = 800
max_connect_errors = 3000
table_cache = 614
external-locking = FALSE
max_allowed_packet =8M
sort_buffer_size = 1M
join_buffer_size = 1M
thread_cache_size = 100
thread_concurrency = 2
query_cache_size = 2M
query_cache_limit = 1M
query_cache_min_res_unit = 2k
#default_table_type = InnoDB
thread_stack = 192K
#transaction_isolation = READ-COMMITTED
tmp_table_size = 2M
max_heap_table_size = 2M
long_query_time = 1
#log_long_format
#log-error = /data/3306/error.log
#log-slow-queries = /data/3306/slow.log
pid-file = /data/3306/mysql.pid
log-bin = /data/3306/mysql-bin
relay-log = /data/3306/relay-bin
relay-log-info-file = /data/3306/relay-log.info
binlog_cache_size = 1M
max_binlog_cache_size = 1M
max_binlog_size = 2M
expire_logs_days = 7
key_buffer_size = 16M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
bulk_insert_buffer_size = 1M
#myisam_sort_buffer_size = 1M
#myisam_max_sort_file_size = 10G
#myisam_max_extra_sort_file_size = 10G
#myisam_repair_threads = 1
#myisam_recover

lower_case_table_names = 1
skip-name-resolve
slave-skip-errors = 1032,1062
replicate-ignore-db=mysql

server-id = 1

innodb_additional_mem_pool_size = 4M
innodb_buffer_pool_size = 32M
innodb_data_file_path = ibdata1:128M:autoextend
innodb_file_io_threads = 4
innodb_thread_concurrency = 8
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 2M
innodb_log_file_size = 4M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
innodb_file_per_table = 0
[mysqldump]
quick
max_allowed_packet = 2M

[mysqld_safe]
log-error=/data/3306/mysql_oldboy3306.err
pid-file=/data/3306/mysqld.pid

　　

　　[root@node82 mysql-5.5.49]# vi /data/3306/mysqld

#!/bin/sh

#init
port=3306
mysql_user="root"
mysql_pwd="rootabcd"
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"

　　[root@node82 mysql-5.5.49]# chmod 700 /data/3306/mysqld

 

7、初始化数据库

root@node82 mysql-5.5.49]# /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/data/3306/data/ --user=mysql
root@node82 mysql-5.5.49]# /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/data/3307/data/ --user=mysql

8、启动数据库

[root@node82 ~]# /data/3306/mysqld start
Starting MySQL...
[root@node82 ~]# /data/3307/mysqld start
Starting MySQL...

9、更改数据库root口令，和mysqld中保持一致

[root@node82 ~]# mysqladmin -uroot password 'rootabcd' -S /data/3306/mysql.sock 
[root@node82 ~]# mysqladmin -uroot password 'rootabcd' -S /data/3307/mysql.sock 

10、多实例登陆方式

[root@node82 ~]# /data/3306/mysqld start
Starting MySQL...
[root@node82 ~]# /data/3307/mysqld start
Starting MySQL...
[root@node82 ~]# mysql -uroot -prootabcd -S /data/3306/mysql.sock 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.49-log Source distribution

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

11、快速增加一个实例

mkdir -p /data/3308/data
\cp /data/3306/my.cnf  /data/3308/
\cp /data/3306/mysqld  /data/3308/
sed -i 's/3306/3308/g' /data/3308/my.cnf 
sed -i '/server-id/cserver-id = 8'  /data/3308/my.cnf 
sed -i 's/3306/3308/g' /data/3308/mysqld
chown -R mysql:mysql /data/3308
chmod 700 /data/3308/mysqld
cd /usr/local/mysql/scripts/
./mysql_install_db --datadir=/data/3308/data --basedir=/usr/local/mysql --user=mysql 
chown -R mysql:mysql /data/3308
/data/3308/mysqld start
sleep 5
netstat -lnt|grep 3308
mysqladmin -uroot password 'rootabcd' -S /data/3308/mysql.sock