本次进行MySQL5.7版本的安装,关于MySQL版本选择、官网下载地址、相关系统配置等操作可以参照之前的博文,本文就不在赘述咯。可以参考历史文章处理,下面直奔主题,进行相关安装工作。
总体安装步骤概述如下:操作系统等相关配置设置
安装依赖包
创建用户
修改配置文件、创建相关数据目录、日志目录等并授权
运行安装命令,启动数据库
配置环境变量、服务等
因为我之前已经安装了MySQL5.6,本次继续在同一台机器上安装一个MySQL5.7版本的实例,相关配置及依赖包等操作之前已处理完毕,
现在就接着后续操作进行了。如果首次安装,需先进行配置。详情见https://www.cnblogs.com/gjc592/p/9198323.html
一、准备工作
安装必要依赖包yum install -y libaio
创建用户
groupadd mysql
useradd -r -g mysql mysql
上传安装包至 /usr/local ,如上传至其他路径,以下操作过程中注意修改路径,或者在/usr/local目录创建软连接
解压tar -zxvf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
创建软连接ln -s mysql-5.7.22-linux-glibc2.12-x86_64 /usr/local/mysql5.7
修改目录权限
cd /usr/local
chown -R mysql:root mysql5.7
二、创建相关数据目录、日志目录、配置文件等并授权
创建相关目录mkdir -p /data/mysql/mysql3307/{data,logs,etc,tmp}
配置文件vi /data/mysql/mysql3307/etc/my3307.cnf
可以参考如下配置文件,注意根据自己的环境修改相关配置
[mysqld]########basic settings########server-id = 463307port = 3307user = mysqlcharacter_set_server=utf8mb4skip_name_resolve = 1max_connections = 800max_connect_errors = 1000datadir = /data/mysql/mysql3307/data #根据实际情况修改,建议和程序分离存放transaction_isolation = READ-COMMITTEDexplicit_defaults_for_timestamp = 1join_buffer_size = 512Mtmp_table_size = 512Mtmpdir = /data/mysql/mysql3307/tmppid-file = /data/mysql/mysql3307/tmp/mysqld3307.pidsocket = /data/mysql/mysql3307/tmp/mysql3307.sockmax_allowed_packet = 128Msql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER"interactive_timeout = 1800wait_timeout = 1800read_buffer_size = 16Mread_rnd_buffer_size = 32Msort_buffer_size = 32Mlanguage = /usr/local/mysql5.7/share/english ## 以后版本将取消该参数########log settings########log_error =/data/mysql/mysql3307/logs/mysqld3307.logslow_query_log = 1slow_query_log_file = /data/mysql/mysql3307/logs/slow.loglog_queries_not_using_indexes = 1log_slow_admin_statements = 1log_slow_slave_statements = 1log_throttle_queries_not_using_indexes = 10expire_logs_days = 3long_query_time = 2min_examined_row_limit = 100########replication settings########master_info_repository = TABLErelay_log_info_repository = TABLElog_bin = /data/mysql/mysql3307/logs/mysql_binlogsync_binlog = 1gtid_mode = onenforce_gtid_consistency = 1log_slave_updatesbinlog_format = rowrelay_log = /data/mysql/mysql3307/logs/relay.logrelay_log_recovery = 1binlog_gtid_simple_recovery = 1slave_skip_errors = ddl_exist_errors########innodb settings########innodb_page_size = 8192innodb_buffer_pool_size = 1G #根据实际情况修改innodb_buffer_pool_instances = 8innodb_buffer_pool_load_at_startup = 1innodb_buffer_pool_dump_at_shutdown = 1innodb_lru_scan_depth = 2000innodb_lock_wait_timeout = 5innodb_io_capacity = 4000innodb_io_capacity_max = 8000innodb_flush_method = O_DIRECTinnodb_file_format = Barracudainnodb_file_format_max = Barracudainnodb_log_group_home_dir = /data/mysql/mysql3307/logs/ #根据实际情况修改innodb_undo_directory = /data/mysql/mysql3307/logs/ #根据实际情况修改innodb_undo_logs = 128innodb_undo_tablespaces = 3innodb_flush_neighbors = 1innodb_log_file_size = 512M #根据实际情况修改innodb_log_buffer_size = 16777216innodb_purge_threads = 4innodb_large_prefix = 1innodb_thread_concurrency = 64innodb_print_all_deadlocks = 1innodb_strict_mode = 1innodb_sort_buffer_size = 67108864########semi sync replication settings########plugin_dir=/usr/local/mysql5.7/lib/plugin #根据实际情况修改plugin_load = "rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so"loose_rpl_semi_sync_master_enabled = 1loose_rpl_semi_sync_slave_enabled = 1loose_rpl_semi_sync_master_timeout = 5000[mysqld-5.7]innodb_buffer_pool_dump_pct = 40innodb_page_cleaners = 4innodb_undo_log_truncate = 1innodb_max_undo_log_size = 1Ginnodb_purge_rseg_truncate_frequency = 128binlog_gtid_simple_recovery=1log_timestamps=systemtransaction_write_set_extraction=MURMUR32show_compatibility_56=on
授权chown -R mysql:mysql /data/mysql/mysql3307
三、 安装及启动
1.指定本实例的配置文件进行安装
# 建议写全路径运行命令进行安装/usr/local/mysql5.7/bin/mysqld --defaults-file=/data/mysql/mysql3307/etc/my3307.cnf --initialize --user=mysql
注意:mysql5.7安装后默认会产生一个临时密码,存放于错误日志里,可以查看错误日志进行查看
# 查看日志vim /data/mysql/mysql3307/logs/mysqld3307.log
此时可以看到临时密码,并查看是否有错误产生
如果不想产生临时密码,可以运行如下命令进行操作,建议使用initialize产生随机密码(下面的语句只是科普使用,无需执行)
/usr/local/mysql5.7/bin/mysqld --defaults-file=/data/mysql/mysql3307/etc/my3307.cnf --initialize-insecure --user=mysql
即:使用--initialize生成随机密码,使用--initialize-insecure生成空密码。
注意:如果安装过程中出现错误,需要将 datadir及 logs下对应的文件删除,并将错误原因查出解决后再运行安装命令,否则将无法再次安装。
2. 启动MySQL实例
#启动数据库,并在后台运行(执行下面命令时多次回车,专为小白而备注)
/usr/local/mysql5.7/bin/mysqld_safe --defaults-file=/data/mysql/mysql3307/etc/my3307.cnf &
# 查看进程
ps -ef|grep mysql
# 登录mysql:此时需要用到临时密码(存放于错误日志中)
/usr/local/mysql5.7/bin/mysql -uroot -p'c,/yqCh:&9pS' -P3307 --socket=/data/mysql/mysql3307/tmp/mysql3307.sock ## 标红的为临时密码
# 进入后需先修改密码才能进行其他操作,如下所示
3.停止数据库
shutdown
MySQL 5.7可以在sql里运行shutdown命令关闭数据库(mysql5.6需要用mysqladmin进行)
# mysqladmin 方式关闭 (mysql5.6采用此方法关闭)/usr/local/mysql5.7/bin/mysqladmin -uroot -p123456 --port=3307 --socket=/data/mysql/mysql3307/tmp/mysql3307.sock shutdown
## 至此 mysql5.6 mysql5.7版本的安装及启动停止就已完成了, MySQL8.0的安装与MySQL5.7类似,但是新特性较多,后续也会进行找机会再举例说明。
以上步骤中如有疑问或错误 欢迎指正。