MySQL常用的安裝方式有三種，yum源直接下載安裝冕香、編譯好的二進制包安裝、源碼編譯安裝突那。無論生產(chǎn)還是測試构眯，最常用的安裝方式惫霸，基本上都是二進制包的方式，簡單快捷壹店，滿足了多數(shù)需求硅卢。
MySQL官方下載地址：https://downloads.mysql.com/archives/community/
環(huán)境準(zhǔn)備
1.安裝MySQL需要的依賴藏杖，libaio脉顿，沒有這個MySQL安裝后就起不來了弊予。
root # yum install -y libaio
2.創(chuàng)建相關(guān)目錄和用戶并授權(quán)
root # mkdir -p /data/mysql/data
root # mkdir -p /data/mysql/base
root # mkdir /data/mysql/etc
root # mkdir -p /data/mysql/log/binlog
root # mkdir /data/mysql/tmp
# 創(chuàng)建mysql用戶开财，但不允許登錄
root # groupadd mysql
root # useradd -r -g mysql -s /bin/false mysql
# 授權(quán)目錄
chown -R mysql. /data/mysql
安裝mysql
1.下載mysql二進制包，并解壓到base目錄下碾褂。
root # cd /opt
root # wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.44-el7-x86_64.tar.gz
root # tar xf mysql-5.7.44-el7-x86_64.tar.gz -C /data/mysql/base/
root # cd /data/mysql/base/
root # mv mysql-5.7.44-el7-x86_64/ 5.7.44
2.配置mysql的環(huán)境變量
root # vim /etc/profile
...
export MYSQL_HOME=/data/mysql/base/5.7.44
export PATH=$PATH:$MYSQL_HOME/bin
#使環(huán)境變量生效
root # source /etc/profile
3.在mysql的etc目錄下添加my.cnf文件正塌，并實際情況修改內(nèi)容
root # vim /data/mysql/etc/my.cnf
[client]
port = 3306
user = root
socket = /data/mysql/data/mysql_3306.sock
[mysql]
prompt ='[\c][Conn:\C][\R:\\m:\\s][\U][\d]> '
default-character-set = utf8mb4
#prompt ='\U[\d]> '
tee = /data/mysql/data/mysql_operation.log
[mysqld]
# Base Config
server_id = 4673
basedir = /data/mysql/base/5.7.44
datadir = /data/mysql/data
tmpdir = /data/mysql/tmp
secure_file_priv = /data/mysql/tmp
pid-file = mysqld.pid
socket = /data/mysql/data/mysql_3306.sock
user = mysql
port = 3306
default_storage_engine = InnoDB
character_set_server = utf8mb4
skip_slave_start = 1
skip-name-resolve = 1
skip-external-locking = 1
lower_case_table_names = 1
query_cache_type = 0
query_cache_size = 0
max_connections = 1000
default-time-zone = '+8:00'
log_timestamps = SYSTEM
# InnoDB config
innodb_strict_mode = 1
innodb_file_per_table = 1
innodb_stats_on_metadata = 0
innodb_flush_method = O_DIRECT
innodb_log_files_in_group = 3
innodb_data_file_path = ibdata1:1G:autoextend
innodb_buffer_pool_size = 1G
innodb_log_file_size = 256M
innodb_log_buffer_size = 32M
innodb_max_dirty_pages_pct = 60
innodb_io_capacity = 400
innodb_buffer_pool_instances = 8
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_dump_at_shutdown = 1
innodb_undo_logs = 128
innodb_undo_tablespaces = 3
innodb_flush_neighbors = 1
# Cache config
key_buffer_size = 8M
tmp_table_size = 32M
max_heap_table_size = 32M
thread_cache_size = 1000
table_open_cache = 2048
open_files_limit = 65535
max_allowed_packet = 32M
# Log config
log_error = mysql-error.log
slow_query_log_file = mysql-slow.log
relay-log = mysql-relay
log-bin = mysql-bin
slow_query_log = 1
long_query_time = 0.2
#log_slow_admin_statements = 1
#log_slow_slave_statements = 1
# Semisync config
plugin-load = "rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so"
rpl_semi_sync_master_enabled = 1
rpl_semi_sync_slave_enabled = 1
# Replication config
slave-parallel-type = LOGICAL_CLOCK
slave-parallel-workers = 8
expire_logs_days = 14
binlog_format = row
log_slave_updates = ON
binlog_checksum = NONE
max_binlog_size = 250M
binlog_cache_size = 2M
sync_binlog = 1
innodb_flush_log_at_trx_commit = 1
relay-log-info-repository = TABLE
master_info_repository = TABLE
relay_log_recovery = 1
binlog_rows_query_log_events = 1
log_bin_trust_function_creators = 1
# GTID
gtid-mode = ON
enforce-gtid-consistency = 1
# Performance Schema
performance-schema-instrument = 'wait/lock/metadata/sql/mdl=ON'
4.初始化數(shù)據(jù)目錄，初始化mysql數(shù)據(jù)目錄有兩種方式鸠天，一種帶mysql管理用戶root的隨機密碼帐姻，一種是空密碼饥瓷。
# 無密碼
root # mysqld --defaults-file=/data/mysql/etc/my.cnf --initialize-insecure --user=mysql
# 有密碼，密碼在mysql data目錄下的error log中呢铆。
mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql
啟動mysql
1.配置mysql啟動文件
root # vim /etc/systemd/system/mysqld.service
[Unit]
Description=MySQL Server
Documentation=man:mysqld
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=forking
PIDFile=/data/mysql/data/mysqld.pid
TimeoutSec=0
ExecStart=/data/mysql/base/5.7.44/bin/mysqld --defaults-file=/data/mysql/etc/my.cnf --daemonize $MYSQLD_OPTS
EnvironmentFile=-/etc/sysconfig/mysql
LimitNOFILE = 65535
Restart=on-failure
RestartPreventExitStatus=1
Environment=MYSQLD_PARENT_PID=1
PrivateTmp=false
2.啟動mysql棺克，加入開機自啟，并連接測試
root # systemctl start mysqld.service
root # systemctl enable mysqld
# 連接測試
[root hxy /root] # mysql -uroot -p -S /data/mysql/data/mysql_3306.sock
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.44-log MySQL Community Server (GPL)
Copyright (c) 2000, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
