同台ECS安装多个mysql

环境：

　　系统：centos7.6

　　mysql版本：5.7

 [root@IG-ECS-dev-mysql ~]#yum -y install wget gcc-c++ ncurses ncurses-devel cmake make perl bison openssl openssl-devel gcc* libxml2 libxml2-devel curl-devel libjpeg* libpng* freetype*

# adduser mysql
# mkdir /usr/local/mysql{3306,3307}/data          
# mkdir /usr/local/mysql{3306,3307}/log
# chown -R mysql:mysql /usr/local/mysql{3306,3307}/data/
# chown -R mysql:mysql /usr/local/mysql{3306,3307}/log/
# chmod 750 /usr/local/mysql{3306,3307}/data      
# chmod 750 /usr/local/mysql{3306,3307}/log  
# mkdir -p /usr/local/mysql{3306,3307}/etc
# chown -R mysql.mysql /usr/local/mysql{3306,3307}/etc
# mkdir -p /var/run/mysqld{3306,3307}
# chown -R mysql.mysql /var/run/mysqld{3306,3307}
# mkdir -p /var/lib/mysqld{3306,3307}
# chown -R mysql.mysql /var/lib/mysqld{3306,3307}
# cp /etc/my.cnf /usr/local/mysql{3306,3307}/etc

　

[root@IG-ECS-dev-mysql mysql-5.7.14]# cmake -DCMAKE_INSTALL_PREFIX="/usr/local/mysql3307/" -DDEFAULT_CHARSET=utf8 -DSYSCONFDIR=/usr/local/mysql3307/etc/ -DMYSQL_DATADIR="/usr/local/mysql3307/data/" -DINSTALL_PLUGINDIR=plugin -DWITH_INNOBASE_STORAGE_ENGINE=1 -DDEFAULT_CO
LLATION=utf8_general_ci -DENABLE_DEBUG_SYNC=0 -DENABLED_LOCAL_INFILE=1 -DENABLED_PROFILING=1 -DWITH_ZLIB=system -DWITH_EXTRA_CHARSETS=none -DMYSQL_MAINTAINER_MODE=OFF -DEXTRA_CHARSETS=all -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/opt/boost_1_59_0

　　

make && make install

　

[root@IG-ECS-dev-mysql etc]# vim my.cnf 
-----------------------------------------------------------------
[client]

port = 3306

socket = /tmp/mysql3306.sock

[mysqld]

binlog_format = mixed

port = 3306
bind-address = 0.0.0.0

socket = /tmp/mysql3306.sock

basedir = /usr/local/mysql3306

datadir  = /usr/local/mysql3306/data
pid-file=/var/lib/mysqld3306/mysql.pid

#master-to-master

log-bin   = mysql1-bin

server-id = 1 

#expire-logs-days  = 30 #only 30 days binlog backup 

#replicate-do-db   =  test

binlog-ignore-db  = mysql

binlog-ignore-db  = information_schema

binlog-ignore-db  = sys

binlog-ignore-db  = performance_schema

auto-increment-increment = 5 

auto-increment-offset = 1

log-slave-updates = ON

max_connections=3000

log_timestamps=SYSTEM

   

#============================================

back_log=50

max_user_connections=2000

innodb_thread_concurrency=8

default-storage-engine=InnoDB

innodb_buffer_pool_size=16M

innodb_log_buffer_size=8M

innodb_log_file_size=48M

innodb_flush_log_at_trx_commit=2

innodb_lock_wait_timeout=50

                          

long_query_time = 1

slow_query_log=YES

slow_query_log_file=/usr/local/mysql3306/log/slow.log

                                       

log-error=/usr/local/mysql3306/log/error.log
[mysqld_safe]
log-error=/var/log/mysqld3306.log
pid-file=/var/run/mysqld3306/mysqld.pid

　　

# echo "/usr/local/mysql3306/lib" >> /etc/ld.so.conf.d/mysql.conf
# ldconfig

# ln -s /usr/local/mysql3306/include/mysql /usr/include/mysql

[root@IG-ECS-dev-mysql bin]# ./mysql_install_db  --defaults-file=/usr/local/mysql3306/etc/my.cnf  --basedir=/usr/local/mysql3306  --datadir=/usr/local/mysql3306/data/ --user=mysql

# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld3306

# vi /etc/init.d/mysqld3006
------------------------------------------------------------

basedir=/usr/local/mysql3306
datadir=/usr/local/mysql3306/data
conf=/usr/local/mysql3306/etc/my.cnf
$bindir/mysqld_safe --defaults-file=/usr/local/mysql3306/etc/my.cnf --datadir=$datadir --pid-file=$server_pid_file $other_args >/dev/null 2>&1 &
--------------------------------------------

/etc/init.d/mysql3306 start

 

同理安装其他的mysql

 

 

坑：

当多个mysql在同一台服务器的时候，不建议使用/etc/profile  添加环境变量的方法，貌似mysql的客户端是又识别功能的，我踩的坑是把mysql3306下的bin加到了环境变量，