Linux上安装Mysql

1、参考文档

• 参考J哥的配置文件：https://github.com/Hackeruncle/MySQL

2、部署mysql

2.1、部署mysql

2.1.1、安装包下线

• 官网安装包下载地址：https://downloads.mysql.com/archives/community/
  
• 或者J哥提供的安装包：https://pan.baidu.com/s/1YNaEq9E8lugXC8ebKyegwA 提取码：ienf

[root@maggiedata ~]# ll   【上传了3个不同版本的mysql安装包】
	total 1498844
	-rw-r--r-- 1 root root 311771412 Oct  3 21:16 mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
	-rw-r--r-- 1 root root 548193637 Oct  3 21:17 mysql-5.7.11-linux-glibc2.5-x86_64.tar.gz
	-rw-r--r-- 1 root root 674830866 Oct  3 21:29 mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz

2.1.2、解压安装包

• tar -xzvf mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz -C /usr/local/ 【解压到/usr/local/目录下】

[root@maggiedata ~]# tar -xzvf mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
	。。。。。。【解压步骤省略】
[root@maggiedata ~]# cd /usr/local/
[root@maggiedata local]# ll
	total 48
	。。。。。。
	drwxr-xr-x  9 root root 4096 Oct  3 21:33 mysql-5.7.38-linux-glibc2.12-x86_64

2.1.3、设置软连接ln -s

• ln -s mysql-5.7.38-linux-glibc2.12-x86_64 mysql 设置软链接

[root@maggiedata local]# ln -s mysql-5.7.38-linux-glibc2.12-x86_64 mysql
[root@maggiedata local]# ll
	total 48
	lrwxrwxrwx  1 root root   35 Oct  3 21:35 mysql -> mysql-5.7.38-linux-glibc2.12-x86_64
	drwxr-xr-x  9 root root 4096 Oct  3 21:33 mysql-5.7.38-linux-glibc2.12-x86_64
	。。。。。。
[root@maggiedata local]# cd mysql
[root@maggiedata mysql]# ll
	total 288
	drwxr-xr-x  2 root root    4096 Oct  3 21:33 bin
	drwxr-xr-x  2 root root    4096 Oct  3 21:33 docs
	drwxr-xr-x  3 root root    4096 Oct  3 21:33 include
	drwxr-xr-x  5 root root    4096 Oct  3 21:33 lib
	-rw-r--r--  1 7161 31415 259251 Mar 22  2022 LICENSE
	drwxr-xr-x  4 root root    4096 Oct  3 21:33 man
	-rw-r--r--  1 7161 31415    566 Mar 22  2022 README
	drwxr-xr-x 28 root root    4096 Oct  3 21:33 share
	drwxr-xr-x  2 root root    4096 Oct  3 21:33 support-files
[root@maggiedata mysql]# mkdir arch data tmp  【创建几个文件夹：arch（二进制归档文件）data（数据文件）tmp（临时文件）】
[root@maggiedata mysql]# ll
	total 300
	drwxr-xr-x  2 root root    4096 Oct  3 21:38 arch     【创建成功】
	drwxr-xr-x  2 root root    4096 Oct  3 21:33 bin
	drwxr-xr-x  2 root root    4096 Oct  3 21:38 data     【创建成功】
	drwxr-xr-x  2 root root    4096 Oct  3 21:33 docs
	drwxr-xr-x  3 root root    4096 Oct  3 21:33 include
	drwxr-xr-x  5 root root    4096 Oct  3 21:33 lib
	-rw-r--r--  1 7161 31415 259251 Mar 22  2022 LICENSE
	drwxr-xr-x  4 root root    4096 Oct  3 21:33 man
	-rw-r--r--  1 7161 31415    566 Mar 22  2022 README
	drwxr-xr-x 28 root root    4096 Oct  3 21:33 share
	drwxr-xr-x  2 root root    4096 Oct  3 21:33 support-files
	drwxr-xr-x  2 root root    4096 Oct  3 21:38 tmp     【创建成功】

2.1.4、创建my.cnf(见下面的配置文件)

• vi /etc/my.cnf 【如果有值，可以dG全部删除，然后拷贝下面的内容到my.cnf文件中去。】

[client]
port            = 13306
socket          = /usr/local/mysql/data/mysql.sock
default-character-set=utf8mb4

[mysqld]
port            = 13306
socket          = /usr/local/mysql/data/mysql.sock

skip-slave-start

skip-external-locking
key_buffer_size = 256M
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 4M
query_cache_size= 32M
max_allowed_packet = 16M
myisam_sort_buffer_size=128M
tmp_table_size=32M

table_open_cache = 512
thread_cache_size = 8
wait_timeout = 86400
interactive_timeout = 86400
max_connections = 600

# Try number of CPU's*2 for thread_concurrency
#thread_concurrency = 32 

#isolation level and default engine 
default-storage-engine = INNODB
transaction-isolation = READ-COMMITTED

server-id  = 1739
basedir     = /usr/local/mysql
datadir     = /usr/local/mysql/data
pid-file     = /usr/local/mysql/data/hostname.pid

#open performance schema
log-warnings
sysdate-is-now

binlog_format = ROW
log_bin_trust_function_creators=1
log-error  = /usr/local/mysql/data/hostname.err
log-bin = /usr/local/mysql/arch/mysql-bin
expire_logs_days = 7

innodb_write_io_threads=16

relay-log  = /usr/local/mysql/relay_log/relay-log
relay-log-index = /usr/local/mysql/relay_log/relay-log.index
relay_log_info_file= /usr/local/mysql/relay_log/relay-log.info

log_slave_updates=1
gtid_mode=OFF