因为低调所以牛逼

删除所有七天前记录DELETE FROM mq_center_sync_log where DATE_SUB(CURDATE(), INTERVAL 7 DAY) >= date(create_time)

1.超过数据库最大连接数org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database serv

mysql版本 5.7.281.修改主库的my.cnf文件vi /etc/my.cnf2.登录主库mysql终端，给需要同步的从库赋权限：3.从库修改my.cnf配置文件(主要是server-id要不一样，然后可以设置成只读的权限)4.登录到从库mysql终端，执行命令同步主库，注意要启动 slavemysql> change master to master_host='192.168.159.159',master_port=3306,master_user='ro

安装mysql5.7.28指令整理：一、开始按顺序安装rpm包tar -xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar//先看下服务器有没有这个包，以防止版本冲突rpm -qa | grep mariadb//如果有 就执行命令删除rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64 --nodeps//开始安装rpm -ivh mysql-community-common-5.7.28-1.el7.x8