本文部分内容有参考其他文章。
环境:
虚拟机VMware,
OS:CentOS Linux release 7.3.1611 (Core)
按照下述的单机Mysql8.0的安装方式进行安装完之后,将该机复制两台,分别修改IP为192.168.1.78和192.168.1.78,以及两台新机器配置文件/etc/my.cnf的serverid,还有要去数据路径下删掉auto.cnf不然配置不成。
vim /etc/hosts
192.168.1.78 mgr-mul1
192.168.1.79 mgr-mul2
192.168.1.80 mgr-mul3
要用hostname修改每台机器的主机名确保不相同,不然配置不成功。
一、单机安装(192.168.1.78)
官网下载8.0.11版本的tar.gz包解压,复制更名到/usr/local/mysql
创建数据路径及日志路径并把他们权限改给mysql用户:
/data/mysql3306/mysql3306
/data/mysql3306/logs
配置文件如下:注意修改server-id及组相关ip
vim /etc/my.cnf
-----------------------------------------------------------------------
[client]
port = 3306
socket = /tmp/mysql3306.sock
default_character_set = utf8mb4
[mysql]
default_character_set = utf8mb4
[mysqld]
lower_case_table_names = 1
port = 3306
basedir = /usr/local/mysql8
datadir = /data/mysql3306/mysql3306
socket = /tmp/mysql3306.sock
pid_file = /data/mysql3306/mysql3306.pid
tmpdir = /tmp/
default_authentication_plugin = mysql_native_password
skip_name_resolve = 1
character_set_server = utf8mb4
collation_server = utf8mb4_unicode_ci
max_connections = 2000
max_connect_errors = 10000
interactive_timeout = 600
wait_timeout = 600
table_open_cache = 2048
thread_cache_size = 51
max_allowed_packet = 16M
tmp_table_size = 256M
max_heap_table_size = 96M
sort_buffer_size = 4M
read_buffer_size = 4M #??IO
join_buffer_size = 4M
read_rnd_buffer_size = 64M #??篓虏
bulk_insert_buffer_size = 64M #
log_error = /data/mysql3306/logs/mysql-error.log
log_timestamps = system
slow_query_log = 1
slow_query_log_file = /data/mysql3306/logs/mysql-slow.log
long_query_time = 1
log_queries_not_using_indexes = 1
log_throttle_queries_not_using_indexes =10
log_slow_admin_statements = 1
log_slow_slave_statements = 1
min_examined_row_limit = 100