yum && 编译 安装mysql 5.7 多实例

<code class="language-bash hljs"><span class="hljs-selector-attr">[root@localhost ~]<span class="hljs-comment"># <span class="hljs-selector-tag">rpm <span class="hljs-selector-tag">-ivh <span class="hljs-selector-tag">mysql57-community-release-el7<span class="hljs-selector-class">.rpm</span></span></span></span></span></span></code>

<code class="language-bash hljs">[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># yum install mysql mysql-server</span></span></code>

初始化

<code class="language-bash hljs">[<span class="hljs-symbol">root@localhost ~]<span class="hljs-comment"># grep <span class="hljs-string">"password" /<span class="hljs-keyword">var/log/mysqld.log 
<span class="hljs-number">2017<span class="hljs-number">-04<span class="hljs-number">-12T00:<span class="hljs-number">45:<span class="hljs-number">32.972626Z <span class="hljs-number">1 [Note] A temporary password <span class="hljs-keyword">is generated <span class="hljs-keyword">for <span class="hljs-symbol">root@localhost: kvyqpEMl<<span class="hljs-number">9b0  <span class="hljs-comment">#随机密码</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></code>

<code class="language-bash hljs">[root@localhost ~]<span class="hljs-comment"># mysqladmin -u root -p password   #重置密码
Enter password: 
<span class="hljs-keyword">New password: 
Confirm <span class="hljs-keyword">new password: 
</span></span></span></code>

<code class="language-bash hljs">[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># systemctl start mysqld
[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># systemctl enable mysqld</span></span></span></span></code>

编译安装

环境准备

<code class="language-bash hljs"><span class="hljs-selector-attr">[root@localhost ~]<span class="hljs-selector-tag">yum <span class="hljs-selector-tag">install <span class="hljs-selector-tag">-y <span class="hljs-selector-tag">gcc <span class="hljs-selector-tag">gcc-c++ <span class="hljs-selector-tag">openssl <span class="hljs-selector-tag">openssl-devel <span class="hljs-selector-tag">ncurses <span class="hljs-selector-tag">ncurses-devel <span class="hljs-selector-tag">cmake <span class="hljs-selector-tag">bison*</span></span></span></span></span></span></span></span></span></span></span></span></code>

<code class="language-bash hljs">[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># mkdir /data/
[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># mkdir /data/mysql/
[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># mkdir /data/mysql/data/
[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># groupadd mysql
[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># useradd -g mysql -s /sbin/nologin mysql
[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># cd /usr/local/src/
[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-boost-5.7.18.tar.gz
[root<span class="hljs-variable">@localhost src]<span class="hljs-comment"># tar zvxf mysql-boost-5.7.18.tar.gz 
[root<span class="hljs-variable">@localhost src]<span class="hljs-comment"># cd mysql-5.7.18</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></code>

 编译安装

<code class="language-bash hljs">cmake . -<span class="ruby">DCMAKE_INSTALL_PREFIX=<span class="hljs-regexp">/usr/<span class="hljs-built_in">local<span class="ruby">/mysql -<span class="ruby"><span class="hljs-regexp">DMYSQL_DATADIR=/data<span class="hljs-regexp">/mysql/data -<span class="ruby">DSYSCONFDIR=<span class="hljs-regexp">/etc -<span class="ruby">DWITH_BOOST=boost -<span class="ruby">DEFAULT_CHARSET=utf8-<span class="ruby">DDEFAULT_COLLATION=utf8_general_ci -<span class="ruby">DEXTRA_CHARSETS=all -<span class="ruby"><span class="hljs-regexp">DMYSQL_UNIX_ADDR=/data<span class="hljs-regexp">/mysql/data<span class="hljs-regexp">/mysqld.sock -<span class="ruby">DENABLED_LOCAL_INFILE=1 -<span class="ruby">DWITH_MYISAM_STORAGE_ENGINE=1 -<span class="ruby">DWITH_INNOBASE_STORAGE_ENGINE=1 -<span class="ruby">DWITH_MEMORY_STORAGE_ENGINE=1 -<span class="ruby">DWITH_PARTITION_STORAGE_ENGINE=1 -<span class="ruby">DWITH_READLINE=1 -<span class="ruby">DMYSQL_TCP_PORT=3306
<span class="hljs-comment"># -DCMAKE_INSTALL_PREFIX=/usr/local/mysql              #安装路径
<span class="hljs-comment"># -DMYSQL_DATADIR=/data/mysql/data                     #数据文件存放位置
<span class="hljs-comment"># -DSYSCONFDIR=/etc                                    #my.cnf路径
<span class="hljs-comment"># -DWITH_BOOST=boost                                   #指定boost库 
<span class="hljs-comment"># -DDEFAULT_CHARSET=utf8                               #默认字符
<span class="hljs-comment"># -DDEFAULT_COLLATION=utf8_general_ci                  #默认排序规则
<span class="hljs-comment"># -DEXTRA_CHARSETS=all                                 #安装所有的字符集
<span class="hljs-comment"># -DMYSQL_UNIX_ADDR=/data/mysql/data/mysqld.sock       #连接数据库socket路径
<span class="hljs-comment"># -DENABLED_LOCAL_INFILE=1                             #允许从本地导入数据
<span class="hljs-comment"># -DWITH_MYISAM_STORAGE_ENGINE=1                       #支持MyIASM引擎
<span class="hljs-comment"># -DWITH_INNOBASE_STORAGE_ENGINE=1                     #支持InnoDB引擎
<span class="hljs-comment"># -DWITH_MEMORY_STORAGE_ENGINE=1                       #支持Memory引擎
<span class="hljs-comment"># -DWITH_PARTITION_STORAGE_ENGINE=1                    #安装支持数据库分区
<span class="hljs-comment"># -DWITH_READLINE=1                                    #快捷键功能
<span class="hljs-comment"># -DMYSQL_TCP_PORT=3306                                #端口
[root@localhost mysql-5.7.18]<span class="hljs-comment"># make -j `grep processor /proc/cpuinfo | wc -l`  && make install
<span class="hljs-comment"># grep processor /proc/cpuinfo 根据cpu核心数指定编译时的线程数(多核cpu会快很多)</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></code>

初始化配置

<code class="language-bash hljs">[<span class="hljs-symbol">root@localhost ~]<span class="hljs-comment"># chown -R mysql:mysql /<span class="hljs-keyword">data/mysql/<span class="hljs-keyword">data/
[<span class="hljs-symbol">root@localhost mysql<span class="hljs-number">-5.7<span class="hljs-number">.18]<span class="hljs-comment"># /usr/local/mysql/bin/mysqld --initialize --user=mysql
<span class="hljs-number">2017<span class="hljs-number">-04<span class="hljs-number">-16T09:<span class="hljs-number">35:<span class="hljs-number">15.850060Z <span class="hljs-number">0 [Warning] TIMESTAMP with implicit DEFAULT value <span class="hljs-keyword">is deprecated. Please use --explicit_defaults_<span class="hljs-keyword">for_timestamp server option (see documentation <span class="hljs-keyword">for more details).
<span class="hljs-number">2017<span class="hljs-number">-04<span class="hljs-number">-16T09:<span class="hljs-number">35:<span class="hljs-number">16.331637Z <span class="hljs-number">0 [Warning] InnoDB: New <span class="hljs-built_in">log files created, LSN=<span class="hljs-number">45790
<span class="hljs-number">2017<span class="hljs-number">-04<span class="hljs-number">-16T09:<span class="hljs-number">35:<span class="hljs-number">16.408336Z <span class="hljs-number">0 [Warning] InnoDB: Creating foreign key constraint system tables.
<span class="hljs-number">2017<span class="hljs-number">-04<span class="hljs-number">-16T09:<span class="hljs-number">35:<span class="hljs-number">16.467944Z <span class="hljs-number">0 [Warning] No existing UUID has been found, so we assume that <span class="hljs-keyword">this <span class="hljs-keyword">is the first time that <span class="hljs-keyword">this server has been started. Generating a new UUID: ffbe4813<span class="hljs-number">-2287<span class="hljs-number">-11e7<span class="hljs-number">-9d8c<span class="hljs-number">-000c298c8776.
<span class="hljs-number">2017<span class="hljs-number">-04<span class="hljs-number">-16T09:<span class="hljs-number">35:<span class="hljs-number">16.469737Z <span class="hljs-number">0 [Warning] Gtid table <span class="hljs-keyword">is not ready to be used. Table <span class="hljs-string">‘mysql.gtid_executed‘ cannot be opened.
<span class="hljs-number">2017<span class="hljs-number">-04<span class="hljs-number">-16T09:<span class="hljs-number">35:<span class="hljs-number">16.470947Z <span class="hljs-number">1 [Note] A temporary password <span class="hljs-keyword">is generated <span class="hljs-keyword">for <span class="hljs-symbol">root@localhost: sRXga&j<span class="hljs-comment">#w5n
[<span class="hljs-symbol">root@localhost mysql<span class="hljs-number">-5.7<span class="hljs-number">.18]<span class="hljs-comment"># /usr/local/mysql/bin/mysql_ssl_rsa_setup  --user=mysql</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></code>

配置文件 

<code class="language-bash hljs">[root@localhost ~]<span class="hljs-comment"># cp /etc/my.cnf /etc/my.cnf.bak 
[root@localhost ~]<span class="hljs-comment"># rm -rf /etc/my.cnf
[root@localhost ~]<span class="hljs-comment"># vim /etc/my.cnf
[client]
port = 3306
socket = /data/mysql/data/mysql.sock
default-character-set = utf8
 
[mysqld]
port = 3306
socket = /data/mysql/data/mysql.sock
 
basedir = /usr/<span class="hljs-built_in">local/mysql
datadir = /data/mysql/data
pid-file = /data/mysql/data/mysql.pid
user = mysql
<span class="hljs-built_in">bind-address = 0.0.0.0
server-id = 1
 
init-connect = <span class="hljs-string">‘SET NAMES utf8‘
character-set-server = utf8
 
<span class="hljs-comment">#skip-name-resolve
<span class="hljs-comment">#skip-networking
back_<span class="hljs-built_in">log = 300
 
max_connections = 1000
max_connect_errors = 6000
open_files_<span class="hljs-built_in">limit = 65535
table_open_cache = 128
max_allowed_packet = 4M
binlog_cache_size = 1M
max_heap_table_size = 8M
tmp_table_size = 16M
 
<span class="hljs-built_in">read_buffer_size = 2M
<span class="hljs-built_in">read_rnd_buffer_size = 8M
sort_buffer_size = 8M
join_buffer_size = 8M
key_buffer_size = 4M
 
thread_cache_size = 8
 
query_cache_<span class="hljs-built_in">type = 1
query_cache_size = 8M
query_cache_<span class="hljs-built_in">limit = 2M
 
ft_min_word_len = 4
 
<span class="hljs-built_in">log_bin = mysql-bin
binlog_format = mixed
expire_logs_days = 30
 
<span class="hljs-built_in">log_error = /data/mysql/data/mysql-error.log
slow_query_<span class="hljs-built_in">log = 1
long_query_time = 1
slow_query_<span class="hljs-built_in">log_file = /data/mysql/data/mysql-slow.log
 
performance_schema = 0
explicit_defaults_<span class="hljs-keyword">for_timestamp
 
<span class="hljs-comment">#lower_case_table_names = 1
 
skip-external-locking
 
default_storage_engine = InnoDB
<span class="hljs-comment">#default-storage-engine = MyISAM
innodb_file_per_table = 1
innodb_open_files = 500
innodb_buffer_pool_size = 64M
innodb_write_io_threads = 4
innodb_<span class="hljs-built_in">read_io_threads = 4
innodb_thread_concurrency = 0
innodb_purge_threads = 1
innodb_flush_<span class="hljs-built_in">log_at_trx_commit = 2
innodb_<span class="hljs-built_in">log_buffer_size = 2M
innodb_<span class="hljs-built_in">log_file_size = 32M
innodb_<span class="hljs-built_in">log_files_<span class="hljs-keyword">in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_<span class="hljs-built_in">wait_timeout = 120
 
bulk_insert_buffer_size = 8M
myisam_sort_buffer_size = 8M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
 
interactive_timeout = 28800
<span class="hljs-built_in">wait_timeout = 28800
 
[mysqldump]
quick
max_allowed_packet = 16M
 
[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M
<span class="hljs-built_in">read_buffer = 4M
write_buffer = 4M
EOF</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></code>

系统服务

<code class="language-bash hljs">[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># cp /usr/local/src/mysql-5.7.18/support-files/mysql.server /etc/init.d/mysqld
[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># chmod +x /etc/init.d/mysqld 
[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># chkconfig --add mysqld
[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># chkconfig mysqld on
[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># service mysqld start
方法二
[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># vim /usr/lib/systemd/system/mysqld.service
[Unit]
Description=Mysql
After=syslog.target network.target remote-fs.target nss-lookup.target
[Service]
Type=forking
PIDFile=<span class="hljs-regexp">/data/mysql<span class="hljs-regexp">/data/mysql.pid
ExecStart=<span class="hljs-regexp">/usr/<span class="hljs-built_in">local<span class="hljs-regexp">/mysql/support-files/mysql.server start
ExecReload=<span class="hljs-regexp">/bin/<span class="hljs-built_in">kill <span class="hljs-_">-s HUP <span class="hljs-variable">$MAINPID
ExecStop=<span class="hljs-regexp">/bin/<span class="hljs-built_in">kill <span class="hljs-_">-s QUIT <span class="hljs-variable">$MAINPID
PrivateTmp=<span class="hljs-literal"><span class="hljs-keyword">false
[Install]
[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># systemctl daemon-reload 
[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># systemctl enable mysqld.service 
[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># mysqladmin -u root -p password   #重置密码
Enter <span class="hljs-symbol">password: 
New <span class="hljs-symbol">password: 
Confirm new password</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></code>

环境变量

<code class="language-bash hljs">[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># vim /etc/profile
PATH=<span class="hljs-regexp">/usr/<span class="hljs-built_in">local<span class="hljs-regexp">/mysql/bin<span class="hljs-symbol">:/usr/<span class="hljs-built_in"><span class="hljs-symbol">local<span class="hljs-symbol">/mysql/lib<span class="hljs-symbol">:<span class="hljs-variable">$PATH
<span class="hljs-built_in">export PATH
[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># source /etc/profile
</span></span></span></span></span></span></span></span></span></span></span></span></span></span></code>

msyql多实例（完全独立）

<code class="language-bash hljs"><span class="hljs-comment">##准备数据目录
<span class="hljs-section">[root@localhost <span class="hljs-built_in"><span class="hljs-section">local<span class="hljs-section">]<span class="hljs-comment"># mkdir /data/mysql/{3306,3307}
<span class="hljs-section">[root@localhost <span class="hljs-built_in"><span class="hljs-section">local<span class="hljs-section">]<span class="hljs-comment"># chown mysql:mysql /data/mysql/
<span class="hljs-section">[root@localhost <span class="hljs-built_in"><span class="hljs-section">local<span class="hljs-section">]<span class="hljs-comment"># chown mysql:mysql /data/mysql/
<span class="hljs-section">[root@localhost <span class="hljs-built_in"><span class="hljs-section">local<span class="hljs-section">]<span class="hljs-comment"># mv /usr/local/mysql /tmp
<span class="hljs-section">[root@localhost <span class="hljs-built_in"><span class="hljs-section">local<span class="hljs-section">]<span class="hljs-comment"># cd /usr/local/src/mysql-5.7.18/
<span class="hljs-section">[root@localhost mysql-5.7.18]<span class="hljs-comment"># make install
<span class="hljs-comment">##初始化数据库
<span class="hljs-section">[root@localhost mysql-5.7.18]<span class="hljs-comment"># /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/3306
<span class="hljs-section">[root@localhost mysql-5.7.18]<span class="hljs-comment"># /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/3307
<span class="hljs-comment">##配置数据库目录
<span class="hljs-section">[root@localhost mysql-5.7.18]<span class="hljs-comment"># mv /usr/local/mysql /usr/local/mysql3306
<span class="hljs-section">[root@localhost mysql-5.7.18]<span class="hljs-comment"># make install
<span class="hljs-section">[root@localhost mysql-5.7.18]<span class="hljs-comment"># mv /usr/local/mysql /usr/local/mysql3307
<span class="hljs-section">[root@localhost mysql-5.7.18]<span class="hljs-comment"># cd /usr/local/
<span class="hljs-section">[root@localhost <span class="hljs-built_in"><span class="hljs-section">local<span class="hljs-section">]<span class="hljs-comment"># cp /etc/my.cnf /usr/local/mysql3306
<span class="hljs-section">[root@localhost <span class="hljs-built_in"><span class="hljs-section">local<span class="hljs-section">]<span class="hljs-comment"># cp /etc/my.cnf /usr/local/mysql3307
<span class="hljs-section">[root@localhost <span class="hljs-built_in"><span class="hljs-section">local<span class="hljs-section">]<span class="hljs-comment"># mv /etc/my.cnf /etc/my.cnf.bak
<span class="hljs-comment">##修改my.cnf文件中的路径
<span class="hljs-section">[root@localhost <span class="hljs-built_in"><span class="hljs-section">local<span class="hljs-section">]<span class="hljs-comment"># vim mysql3306/my.cnf
<span class="hljs-section">[client]  
<span class="hljs-attr">port = <span class="hljs-number">3306
<span class="hljs-attr">socket = /data/mysql/<span class="hljs-number">3306/mysql.sock
<span class="hljs-attr">default-character-set = utf8
<span class="hljs-section">
[mysqld]
<span class="hljs-attr">port = <span class="hljs-number">3306
<span class="hljs-attr">socket = /data/mysql/<span class="hljs-number">3306/mysql.sock
<span class="hljs-attr">basedir = /usr/<span class="hljs-built_in">local/mysql3306
<span class="hljs-attr">datadir = /data/mysql/<span class="hljs-number">3306
<span class="hljs-attr">pid-file = /data/mysql/<span class="hljs-number">3306/mysql.pid
<span class="hljs-attr">user = mysql
<span class="hljs-built_in">bind<span class="hljs-attr">-address = <span class="hljs-number">0.0.<span class="hljs-number">0.0
<span class="hljs-attr">server-id = <span class="hljs-number">1
<span class="hljs-section">[root@localhost <span class="hljs-built_in"><span class="hljs-section">local<span class="hljs-section">]<span class="hljs-comment"># vim mysql3307/my.cnf
<span class="hljs-section">[client]
<span class="hljs-attr">port = <span class="hljs-number">3307
<span class="hljs-attr">socket = /data/mysql/<span class="hljs-number">3307/mysql.sock
<span class="hljs-attr">default-character-set = utf8
<span class="hljs-section">
[mysqld]
<span class="hljs-attr">port = <span class="hljs-number">3307
<span class="hljs-attr">socket = /data/mysql/<span class="hljs-number">3307/mysql.sock
<span class="hljs-attr">basedir = /usr/<span class="hljs-built_in">local/mysql3307
<span class="hljs-attr">datadir = /data/mysql/<span class="hljs-number">3307
<span class="hljs-attr">pid-file = /data/mysql/<span class="hljs-number">3307/mysql.pid
<span class="hljs-attr">user = mysql
<span class="hljs-built_in">bind<span class="hljs-attr">-address = <span class="hljs-number">0.0.<span class="hljs-number">0.0
<span class="hljs-attr">server-id = <span class="hljs-number">2
</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></code>

<code class="language-bash hljs"><span class="hljs-comment">##配置mysql 启动脚本
[root@localhost <span class="hljs-built_in">local]<span class="hljs-comment"># vim mysql3306/support-files/mysql.server 
<span class="hljs-keyword">then
  basedir=/usr/<span class="hljs-built_in">local/mysql3306
  bindir=/usr/<span class="hljs-built_in">local/mysql3306/bin
  <span class="hljs-keyword">if <span class="hljs-built_in">test -z <span class="hljs-string"><span class="hljs-string">"<span class="hljs-variable"><span class="hljs-string"><span class="hljs-variable">$datadir<span class="hljs-string">"
  <span class="hljs-keyword">then
    datadir=/data/mysql/3306
  <span class="hljs-keyword">fi
  sbindir=/usr/<span class="hljs-built_in">local/mysql3306/bin
  libexecdir=/usr/<span class="hljs-built_in">local/mysql3306/bin
[root@localhost <span class="hljs-built_in">local]<span class="hljs-comment"># vim mysql3307/support-files/mysql.server 
<span class="hljs-keyword">then
  basedir=/usr/<span class="hljs-built_in">local/mysql3307
  bindir=/usr/<span class="hljs-built_in">local/mysql3307/bin
  <span class="hljs-keyword">if <span class="hljs-built_in">test -z <span class="hljs-string"><span class="hljs-string">"<span class="hljs-variable"><span class="hljs-string"><span class="hljs-variable">$datadir<span class="hljs-string">"
  <span class="hljs-keyword">then
    datadir=/data/3307/data
  <span class="hljs-keyword">fi
  sbindir=/usr/<span class="hljs-built_in">local/mysql3307/bin
  libexecdir=/usr/<span class="hljs-built_in">local/mysql3307/bin
<span class="hljs-comment">## 启动服务
[root@localhost <span class="hljs-built_in">local]<span class="hljs-comment"># /usr/local/mysql3306/support-files/mysql.server start
[root@localhost <span class="hljs-built_in">local]<span class="hljs-comment"># /usr/local/mysql3307/support-files/mysql.server start
[root@localhost <span class="hljs-built_in">local]<span class="hljs-comment"># netstat -anpt
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      40724/mysqld        
tcp        0      0 0.0.0.0:3307            0.0.0.0:*               LISTEN      47249/mysqld </span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></code>

mysqld_multi管理多实例

<code class="language-bash hljs"><span class="hljs-comment">##环境准备
[root@localhost <span class="hljs-built_in"><span class="hljs-keyword">local]<span class="hljs-comment"># mkdir /data/mysql/{3306,3307}
[root@localhost <span class="hljs-built_in"><span class="hljs-keyword">local]<span class="hljs-comment"># chown mysql:mysql /data/mysql/
[root@localhost <span class="hljs-built_in"><span class="hljs-keyword">local]<span class="hljs-comment"># cd /usr/local/src/mysql-5.7.18/
[root@localhost mysql-<span class="hljs-number">5.7.<span class="hljs-number">18]<span class="hljs-comment"># make install</span></span></span></span></span></span></span></span></span></span></span></span></span></code>

<code class="language-bash hljs"><span class="hljs-comment">## 修改my.cnf
[root@localhost mysql-5.7.18]<span class="hljs-comment"># vim /etc/my.cnf
[mysqld_multi]
mysqld = /usr/<span class="hljs-built_in">local/mysql/bin/mysqld_safe
mysqladmin = /usr/<span class="hljs-built_in">local/mysql/bin/mysqladmin
<span class="hljs-built_in">log = /data/mysql/mysqld_multi.log
[mysqld1]
port = 3306
socket = /data/mysql/3306/mysql.sock
basedir = /usr/<span class="hljs-built_in">local/mysql
datadir = /data/mysql/3306
pid-file = /data/mysql/3306/mysql.pid
user = mysql
<span class="hljs-built_in">log_error = /data/mysql/3306/mysql-error.log
slow_query_<span class="hljs-built_in">log = 1
long_query_time = 1
slow_query_<span class="hljs-built_in">log_file = /data/mysql/3306/mysql-slow.log
general_<span class="hljs-built_in">log=ON
general_<span class="hljs-built_in">log_file= /data/mysql/3306/mysql.log
performance_schema = 0
explicit_defaults_<span class="hljs-keyword">for_timestamp
[mysqld2]
port = 3307
socket = /data/mysql/3307/mysql.sock
basedir = /usr/<span class="hljs-built_in">local/mysql
datadir = /data/mysql/3307
pid-file = /data/mysql/3307/mysql.pid
user = mysql
<span class="hljs-built_in">log_error = /data/mysql/3307/mysql-error.log
slow_query_<span class="hljs-built_in">log = 1
long_query_time = 1
slow_query_<span class="hljs-built_in">log_file = /data/mysql/3307/mysql-slow.log
general_<span class="hljs-built_in">log=ON
general_<span class="hljs-built_in">log_file= /data/mysql/3307/mysql.log
performance_schema = 0
explicit_defaults_<span class="hljs-keyword">for_timestamp
<span class="hljs-comment">## 初始化数据库
<span class="hljs-comment"># /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/3306
<span class="hljs-comment"># /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/3307</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></code>

<code class="language-bash hljs"><span class="hljs-comment">## 服务管理
<span class="hljs-comment"># /usr/local/mysql/bin/mysqld_multi report      #查看所有实例状态
<span class="hljs-comment"># /usr/local/mysql/bin/mysqld_multi start       #启动所有实例
<span class="hljs-comment"># /usr/local/mysql/bin/mysqld_multi start 1     #启动实例1
<span class="hljs-comment"># mysqladmin -uroot -prVrzzT9s -S /data/mysql/3306/mysql.sock shutdown  #关闭某个实例</span></span></span></span></span></code>

<code class="language-bash hljs"><span class="hljs-comment">## 设置密码
[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># mysqladmin -u root -p password -P 3306 -S /data/mysql/3306/mysql.sock
[root<span class="hljs-variable">@localhost ~]<span class="hljs-comment"># mysqladmin -u root -p password -P 3307 -S /data/mysql/3307/mysql.sock</span></span></span></span></span></code>

yum && 编译 安装mysql 5.7 多实例

标签：cat   nod   连接数   tcp   kotlin   配置文件   服务管理   desc   perl