MySQL8安装三：二进制安装配置多实例

素颜马尾好姑娘i 2024-03-23 11:04 190阅读 0赞

9de7bb31d0644e7393039222babfed10

上次记录了二进制安装MySQL8， 本次演示同一个服务器配置多实例的方法。

有2种方式，第一种是多服务， 第二种是单服务。

### 二进制安装 ###

#创建安装用户
    useradd  mysql
    
    #安装目录
    [ -f /u01/mysql ] || mkdir -p /u01/mysql
    tar -xvf mysql-8.0.18-linux-glibc2.12-x86_64.tar.xz -C /u01/mysql
    mv /u01/mysql/mysql-8.0.18-linux-glibc2.12-x86_64 /u01/mysql/8.0.18
    
    chown -R mysql:mysql /u01/mysql
    ln -s /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5

本次演示配置了3个实例， 端口分别是3307,3308,3309, 脚本使用了循环，直接复制粘贴，省的一个个编辑配置文件了。

### 配置方法1:多服务 ###

配置完成后是3个服务，分别是mysqld3307,mysqld3308,mysqld3309,

启动方法就是

systemctl start mysqld3307

systemctl start mysqld3308

systemctl start mysqld3309

echo 'PATH=$PATH:/u01/mysql/8.0.18/bin' >> ~/.bash_profile
    source ~/.bash_profile
    
    for i in {
        3307..3309}
    do
      mkdir -p /u01/mysql/${i}/data #准备数据目录
      [ -f /u01/mysql/${i}/mysqld.log ] || touch /u01/mysql/${i}/mysqld.log  #日志文件
    
    cat > /u01/mysql/${i}/my${i}.cnf <<EOF #准备配置文件
    [mysqld]
    server_id=${i}
    port=${i}
    mysqlx_port=${i}0
    datadir=/u01/mysql/${i}/data
    socket=/u01/mysql/${i}/data/mysql.sock
    mysqlx_socket=/u01/mysql/${i}/data/mysqlx.sock
    log_error=/u01/mysql/${i}/mysqld.log
    basedir=/u01/mysql/8.0.18
    log_bin=/u01/mysql/${i}/data/binlog
    log_bin_index=/u01/mysql/${i}/data/binlog.index
    relay_log=relay-log
    relay_log_index=relay-log.index
    transaction-isolation=repeatable-read
    user=mysql
    gtid-mode=on
    enforce_gtid_consistency=on
    binlog_checksum=none
    disabled_storage_engines="MyISAM,BLACKHOLE,ARCHIVE,MEMORY"
    innodb_buffer_pool_size=4G
    binlog_cache_size=1M
    default_time_zone='+8:00'
    federated=on
    event_scheduler=on
    #below variables are same as default values, do not need setup
    #skip_name_resolve = off 
    #max_binlog_size=1073741824
    #binlog_format=row
    #sync_binlog = 1
    #innodb_flush_log_at_trx_commit = 1
    #binlog_expire_logs_seconds = 2592000
    EOF
    
      chown -R mysql:mysql /u01/mysql/${i} #权限
      mysqld --initialize --user=mysql --basedir=/u01/mysql/8.0.18 --datadir=/u01/mysql/${i}/data #初始化数据库, 记住随机产生的初始密码(屏幕显示 or /var/log/mysqld.log )
    
    cat > /usr/lib/systemd/system/mysqld${i}.service<<EOF #systemd配置文件
    [Unit]
    Description=MySQL Server
    Documentation=man:mysqld(8)
    Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
    After=network.target
    After=syslog.target
    
    [Install]
    WantedBy=multi-user.target
    
    [Service]
    User=mysql
    Group=mysql
    
    Type=notify
    TimeoutSec=0
    PermissionsStartOnly=true
    ExecStart=/u01/mysql/8.0.18/bin/mysqld --defaults-file=/u01/mysql/${i}/my${i}.cnf
    LimitNOFILE = 10000
    Restart=on-failure
    RestartPreventExitStatus=1
    Environment=MYSQLD_PARENT_PID=1
    PrivateTmp=false
    EOF
    
      systemctl --now enable mysqld${i} #启动
    done

### 配置方法2: 单服务 ###

配置完成后是1个服务，是mysqld

启动方法就是

systemctl start mysqld@3307

systemctl start mysqld@3308

systemctl start mysqld@3309

echo 'PATH=$PATH:/u01/mysql/8.0.18/bin' >> ~/.bash_profile
    source ~/.bash_profile
    
    for i in {
        3307..3309}
    do
      mkdir -p /u01/mysql/${i}/data #准备数据目录
      [ -f /u01/mysql/${i}/mysqld.log ] || touch /u01/mysql/${i}/mysqld.log  #日志文件
    
    cat >> /etc/my.cnf <<EOF #准备配置文件,注意此处和多服务配置不同
    [mysqld@${i}]
    server_id=${i}
    port=${i}
    mysqlx_port=${i}0
    socket=/u01/mysql/${i}/data/mysql.sock
    mysqlx_socket=/u01/mysql/${i}/data/mysqlx.sock
    basedir=/u01/mysql/8.0.18
    datadir=/u01/mysql/${i}/data
    log_error=/u01/mysql/${i}/mysqld.log
    log_bin=/u01/mysql/${i}/data/binlog
    log_bin_index=/u01/mysql/${i}/data/binlog.index
    binlog_cache_size = 1M
    relay_log=relay-log
    relay_log_index=relay-log.index
    transaction-isolation = repeatable-read
    event_scheduler=1
    default_time_zone='+8:00'
    user=mysql
    federated
    gtid-mode = on
    enforce_gtid_consistency=true
    binlog_checksum=NONE
    innodb_buffer_pool_size=4G
    disabled_storage_engines="MyISAM,BLACKHOLE,ARCHIVE,MEMORY"
    #below variables are same as default values, do not need setup
    #skip_name_resolve = off 
    #max_binlog_size=1073741824
    #binlog_format=row
    #sync_binlog = 1
    #innodb_flush_log_at_trx_commit = 1
    #binlog_expire_logs_seconds = 2592000
    EOF
    
      chown -R mysql:mysql /u01/mysql/${i} #权限
      mysqld --initialize --user=mysql --basedir=/u01/mysql/8.0.18 --datadir=/u01/mysql/${i}/data #初始化数据库, 记住随机产生的初始密码(屏幕显示 or /var/log/mysqld.log )
    
    cat > /usr/lib/systemd/system/mysqld@.service <<EOF #systemd配置文件
    [Unit]
    Description=MySQL Server
    Documentation=man:mysqld(8)
    Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
    After=network.target
    After=syslog.target
    
    [Install]
    WantedBy=multi-user.target
    
    [Service]
    User=mysql
    Group=mysql
    Type=notify
    TimeoutSec=0
    PermissionsStartOnly=true
    ExecStart=/u01/mysql/8.0.18/bin/mysqld --defaults-group-suffix=@%I $MYSQLD_OPTS
    LimitNOFILE = 10000
    Restart=on-failure
    RestartPreventExitStatus=1
    Environment=MYSQLD_PARENT_PID=1
    PrivateTmp=false
    EOF
    
      systemctl --now enable mysqld@${i} #启动,不要有重复的[mysql@XXXX]
    done

### 验证和修改初始密码 ###

#验证多实例
    netstat -lnp|grep 330
    
    #修改初始化密码
    cd /u01/mysql
    mysql -S 3307/mysql.sock -u root -p --connect-expired-password -e "alter user user() identified by 'Root_1qaz';"
    mysql -S 3308/mysql.sock -u root -p --connect-expired-password -e "alter user user() identified by 'Root_1qaz';"
    mysql -S 3309/mysql.sock -u root -p --connect-expired-password -e "alter user user() identified by 'Root_1qaz';"

至此，多实例配置就完成了。后面再演示下docker和yum安装。谢谢  
9de7bb31d0644e7393039222babfed10