mysql8多实例_牛刀小试MySQL--多实例安装MySQL8.0

思路:多实例安装mysql可以遵循。修改my.cnf的配置文件和目录文件结构。在服务器下需要做的操作如下:

1.新建另外一个实例的文件目录

#cd /data/

#mkdir -p /data/mysqldata/{3307/{data,tmp,binlog,innodb_ts,innodb_log},backup,scripts}

#chown -R mysql:mysql mysqldata

#su - mysql

2.使用新的mysql.cnf文件启动mysql服务

[client]

port = 3307

socket = /data/mysqldata/3307/mysql.sock

# The MySQL server

[mysqld]

port = 3307

mysqlx_port = 33070

user = mysql

socket = /data/mysqldata/3307/mysql.sock

mysqlx_socket=/data/mysqldata/3307/mysqlx.sock

pid-file = /data/mysqldata/3307/mysql.pid

basedir = /usr/local/mysql

datadir = /data/mysqldata/3307/data

tmpdir = /data/mysqldata/3307/tmp

open_files_limit = 60000

explicit_defaults_for_timestamp

server-id = 1203307

lower_case_table_names = 1

character-set-server = utf8

federated

#sql_mode=STRICT_TRANS_TABLES

max_connections = 1000

max_connect_errors = 100000

interactive_timeout = 86400

wait_timeout = 86400

back_log=100