一、安装采取yum方式,很简简单单
# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
# rpm -ivh mysql-community-release-el7-5.noarch.rpm
# yum install mysql-community-server
如果是自编译的方式(启动脚本为/etc/init.d/mysqld start),需要自己添加到系统服务,命令如下:
/sbin/chkconfig mysqld on
二、mysql每天定时备份
1.1mysql备份脚本mysqlbak.sh
#生成年月日格式存入变量dn
dn=`date +%Y%m%d%H%M`
#通过dump命名导出整个数据库到指定文件
mysqldump --default-character-set=utf8 -uroot -p'123456' totcms > /home/bak/${dn}db.sql
将mysqlbak.sh文件放在/opt/下面
注:密码用''扩起来了,否则使用特殊字符的密码将会出错。
1.2运行crontab指令启动定时任务
crontab -e
写入内容:
00 00 * * * /opt/mysqlbak.sh
上面意思是每天0零点执行/opt/mysqlbak.sh(即数据库备份)
三、修改最大连接数,默认是150有点不够用:)
1、修改linux文件数限制
将以下脚本存为nolimi.sh,然后执行即可
#!/bin/sh
if cat /etc/security/limits.conf | grep "* soft nofile 65535" > /dev/null;then
echo ""
else
echo "* soft nofile 65535" >> /etc/security/limits.conf
fi
if cat /etc/security/limits.conf | grep "* hard nofile 65535" > /dev/null ;then
echo ""
else
echo "* hard nofile 65535" >> /etc/security/limits.conf
fi
2、修改mysql服务文件
编辑 /usr/lib/systemd/system/mysqld.service 文件,在文件最后添加:
LimitNOFILE=65535
LimitNPROC=65535
3、修改mysql配置文件/etc/my.cnf,在[mysqld]标签里添加以下代码:max_connections=3600
4、重启 service mysqld restart
5、查看效果:show variables like '%max_co%';
+---------------------------------------+-------+
| Variable_name | Value |
+---------------------------------------+-------+
| max_connect_errors | 100 |
| max_connections | 3600 |
| performance_schema_max_cond_classes | 80 |
| performance_schema_max_cond_instances | 15364 |
+---------------------------------------+-------+
解决,ok!
二、tomcat服务并自动启动
2.1:
vim /lib/systemd/system/tomcat.service
2.2:复制以下代码保存退出,注意修改你的tomcat路径
[Unit]
Description=tomcat
After=network.target
[Service]
Type=oneshot
ExecStart=/opt/apache-tomcat-8.0.32/bin/startup.sh
ExecStop=/opt/apache-tomcat-8.0.32/bin/shutdown.sh
ExecReload=/bin/kill -s HUP $MAINPID
RemainAfterExit=yes
[Install]
WantedBy=multi-user.target
2.3:启动服务
systemctl start tomcat.service
2.4:查看服务状态
systemctl status tomcat.service
2.5:开机启动
systemctl enable tomcat.service