推荐

一键安装redis6.0(Rocky Linux 9/CentOS Stream 9)(shell)

Rocky Linux 9/CentOS Stream 9修改网卡配置/自动修改主机名（实操）

Mycat2版部署mysql读写分离

Mycat1.6版部署mysql读写分离

1/安装包下载

https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.33-linux-glibc2.28-x86_64.tar.gz

2/编写脚本

数据存储在/data/mysql

#cat mysql_8_33_install.sh
#!/bin/bash
# -------------------------------------------------------------------------------
# Filename:    安装mysql.8.0.33
# Revision:    1.2.7
# Author 		
# Description: 解压安装
# Notes:       Rocky Linux 9/CentOS Stream 9
# --------------------------------------------------------------------------------

mysql_8_33_install(){
if ! type mysqld >/dev/null 2>&1 ;then
	yum install -y libaio numactl
	echo "别着急，给我1分钟，就好了。"
	tar -xf mysql-8.0.33-linux-glibc2.28-x86_64.tar.gz -C /usr/local/
	mv /usr/local/mysql-8.0.33-linux-glibc2.28-x86_64 /usr/local/mysql
	rm -rf /etc/my.cnf
    #touch /etc/my.cnf
cat > /etc/my.cnf << EOF
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4

[mysqld]

port = 3306
log-bin=mysql-bin
server-id=1

#binglog日誌格式
binlog_format="ROW"

#binlog过期清理时间
expire_logs_days=10
#binlog每个日志文件大小
max_binlog_size=100m

datadir=/usr/local/mysql
datadir=/data/mysql
socket=/data/mysql/mysql.sock
#symbolic-links=0

#innodb使用内存
#innodb_buffer_pool_size = 12G

#主从不同步的库
#binlog-ignore-db = dbname
binlog-ignore-db = information_schema
binlog-ignore-db = mysql
binlog-ignore-db = performance_schema
binlog-ignore-db = sys

#缓冲的数据hash到不同的缓冲池中，并行的内存读写
innodb_buffer_pool_instances = 2
#该变量将数据存导入到内存中，可以减少大量的IO资源消耗。当事务提交时，保存数据，后续在刷
#新到磁盘。
innodb_log_buffer_size = 128M
#在一个日志组每个日志文件的字节大小,日志文件的总大小
innodb_log_file_size = 256M
#修改InnoDB为独立表空间模式，每个数据库的每个表都会生成一个数据空间。
innodb_file_per_table =ON
#库里的表特别多的情况使用，这个值默认是300M
innodb_open_files=2M
#限制了一次有多少线程能进入内核，0表示不限制进入内核的数量
innodb_thread_concurrency=0
innodb_flush_log_at_trx_commit=1
sync_binlog=1

### myisam
key_buffer_size = 32M
sort_buffer_size=16M

bulk_insert_buffer_size=16M
read_rnd_buffer_size=16M


#连接数
max_connections = 2000
#跳过错误
#slave-skip-errors=all

#utf8mb4编码
character-set-client-handshake = FALSE
character-set-server = utf8mb4
init_connect='SET NAMES utf8mb4'

lower_case_table_names=1

#开启log-bin日志
log-bin-trust-function-creators=1
#开启事件调度器
event_scheduler=1

#慢查询开启
slow_query_log=1
#慢查询时间为2s
long_query_time=2
#存放位置
slow_query_log_file = /data/mysql/slow.log
#索引
log_queries_not_using_indexes

default_authentication_plugin=mysql_native_password

sql_mode=NO_ENGINE_SUBSTITUTION
[mysqld_safe]
log-error=/data/mysql/mysqld.log
pid-file=/data/mysql/mysqld.pid

#
# include all files from the config directory
#
#!includedir /etc/my.cnf.d

EOF

	groupadd mysql
	useradd -g mysql mysql -s /bin/false
	chown -R mysql.mysql /usr/local/mysql
	mkdir -p /data/mysql
	chown -R mysql:mysql /data/mysql
	
	if  type numactl >/dev/null 2>&1 ;then
		cd /usr/local/mysql/bin/
		./mysqld --initialize --user=mysql  --basedir=/usr/local/mysql  --datadir=/data/mysql/ &> $lj/mysql.log
		passw=`cat $lj/mysql.log |grep "root@localhost" |awk -F "localhost:" '{print $2}' |sed 's/^[ ]*//g'`
		cp /usr/local/mysql/support-files/mysql.server /usr/local/mysql/support-files/mysql.server_bak
		sed -i 's%^datadir=%datadir=/data/mysql%g'  /usr/local/mysql/support-files/mysql.server
		sed -i 's%^basedir=%basedir=/usr/local/mysql%g'  /usr/local/mysql/support-files/mysql.server
		# 添加环境变量
		echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
		# 使新添加的环境变量生效
		source /etc/profile
		#添加到/etc目錄的軟連接
		ln -s /data/mysql/mysql.sock /tmp/mysql.sock
		ln -s /usr/local/mysql/bin/mysql /usr/bin
		# 启动mysql服务
		#/etc/init.d/mysqld start
		cat >/etc/systemd/system/mysqld.service << EOF
[Unit]
Description=mysql
After=network.target

[Service]
User=root
Group=root
ExecStart=/usr/local/mysql/support-files/mysql.server start
ExecStop=/usr/local/mysql/support-files/mysql.server stop
Restart=always
Type=forking

[Install]
WantedBy=multi-user.target

EOF
        
		sudo systemctl daemon-reload && sudo systemctl enable mysqld.service && systemctl start mysqld.service
		local svs2=`netstat -tnupl |grep 'mysqld' |wc -l`
		if [ $svs2 -ge 2 ] ;then
			echo "mysql启动成功."
		else
			echo "mysql启动失败,请查找日志。"
		fi
		
	else
		echo "安装numactl插件失败,请手动安装后，再重试。"
	fi
	
else
	echo "安装mysql已经安装了,如果需要重装请先把原来mysql删除完，再安装"
	echo -e "\n"
fi
}

mysql_8_33_install
echo "mysql初始密码为：$passw"

三/修改mysql密码和权限

#修改密码
#8.0 需要先用这条命令
#alter user 'root'@'localhost' identified by '密码';
#CREATE USER 'root'@'%' IDENTIFIED BY '密码'; 
#GRANT ALL ON *.* TO 'root'@'%'; 
#ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '密码';
#密码永不过期的
#ALTER USER 'root'@'localhost' IDENTIFIED BY '密码' PASSWORD EXPIRE NEVER;

如有疏漏不妥之处,还请不吝赐教