安装依赖包

  1. yum install libaio -y

下载解压并创建软连接

  1. wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz
  2. tar zxf mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz -C /usr/local
  3. ln -s /usr/local/mysql-5.7.30-linux-glibc2.12-x86_64 /usr/local/mysql

创建目录

  1. mkdir -p /data/mysql_data{1,2,3,4}

创建用户

  1. groupadd mysql
  2. useradd -r -g mysql -s /bin/false mysql

修改目录属组

  1. chown -R mysql.mysql /usr/local/mysql/*
  2. chown -R mysql.mysql /data/

配置环境变量

  1. echo "MYSQL_HOME=/usr/local/mysql/" >> /etc/profile
  2. echo "PATH=\$PATH:\${MYSQL_HOME}/bin" >> /etc/profile
  3. source /etc/profile

创建配置文件

  1. vim /etc/my.cnf
  1. [mysqld_multi]
  2. mysqld = /usr/local/mysql/bin/mysqld 
  3. mysqladmin = /usr/local/mysql/bin/mysqladmin
  4. log = /tmp/mysql_multi.log
  6. [mysqld1]
  7. # 设置数据目录　[多实例中一定要不同]
  8. datadir = /data/mysql_data1
  9. # 设置sock存放文件名　[多实例中一定要不同]
  10. socket = /data/mysql_data1/mysql.sock1
  11. # binlog
  12. log-bin = /data/mysql_data1/mysql-bin
  13. # serverid
  14. server-id = 3306
  15. # 设置监听开放端口　[多实例中一定要不同]
  16. port = 3306
  17. # 设置运行用户
  18. user = mysql
  19. # 关闭监控
  20. performance_schema = off
  21. # 设置innodb 缓存大小
  22. innodb_buffer_pool_size = 32M
  23. # 设置监听IP地址
  24. bind_address = 0.0.0.0
  25. # 关闭DNS 反向解析
  26. skip-name-resolve = 0
  28. [mysqld2]
  29. datadir = /data/mysql_data2
  30. socket = /data/mysql_data2/mysql.sock2
  31. log-bin = /data/mysql_data2/mysql-bin
  32. server-id = 3307
  33. port = 3307
  34. user = mysql
  35. performance_schema = off
  36. innodb_buffer_pool_size = 32M
  37. bind_address = 0.0.0.0
  38. skip-name-resolve = 0
  40. [mysqld3]
  41. datadir = /data/mysql_data3
  42. socket = /data/mysql_data3/mysql.sock3
  43. log-bin = /data/mysql_data3/mysql-bin
  44. server-id = 3308
  45. port = 3308
  46. user = mysql
  47. performance_schema = off
  48. innodb_buffer_pool_size = 32M
  49. bind_address = 0.0.0.0
  50. skip-name-resolve = 0
  52. [mysqld4]
  53. datadir = /data/mysql_data4
  54. socket = /data/mysql_data4/mysql.sock4
  55. log-bin = /data/mysql_data4/mysql-bin
  56. server-id = 3309
  57. port = 3309
  58. user = mysql
  59. performance_schema = off
  60. innodb_buffer_pool_size = 32M
  61. bind_address = 0.0.0.0
  62. skip-name-resolve = 0

初始化

  1. /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql_data1

过滤密码：M/IGgPh;s0lo

  1. /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql_data2

过滤密码：k+j2Vj2nZtlV

  1. /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql_data3

过滤密码：5*K,*o4VDja!

  1. /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql_data4

过滤密码：!rfTr&huc0Kk

配置启动脚本

  1. cp /usr/local/mysql/support-files/mysqld_multi.server /etc/init.d/mysqld_multi
  2. chmod +x /etc/init.d/mysqld_multi
  3. chkconfig --add mysqld_multi

启动服务

  1. /etc/init.d/mysqld_multi report
  2. /etc/init.d/mysqld_multi start
  3. /etc/init.d/mysqld_multi start 1
  4. /etc/init.d/mysqld_multi start 2
  5. /etc/init.d/mysqld_multi start 3
  6. /etc/init.d/mysqld_multi start 4

查看服务

  1. netstat -lntp | grep mysqld

修改密码

  1. mysql -S /data/mysql_data1/mysql.sock1 -p'M/IGgPh;s0lo'
  2. mysql -S /data/mysql_data2/mysql.sock2 -p'k+j2Vj2nZtlV'
  3. mysql -S /data/mysql_data3/mysql.sock3 -p'5*K,*o4VDja!'
  4. mysql -S /data/mysql_data4/mysql.sock4 -p'!rfTr&huc0Kk'
  1. set password = '123456';