摘要: 1、yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm2、percona-release3、yum install percona-toolkit 阅读全文
posted @ 2022-03-01 16:10 learnnote 阅读(70) 评论(0) 推荐(0)
摘要: redis-cli -n 0 keys "*" | while read key do redis-cli -n 0 --raw dump $key | perl -pe 'chomp if eof' | redis-cli -n 11 -x restore $key 0 echo "migrate 阅读全文
posted @ 2022-02-03 11:19 learnnote 阅读(237) 评论(0) 推荐(0)
摘要: yum erase ruby ruby-libs ruby-mode ruby-rdoc ruby-irb ruby-ri ruby-docs yum groupinstall "Development tools" yum -y install zlib-devel curl-devel open 阅读全文
posted @ 2022-01-11 11:03 learnnote 阅读(172) 评论(0) 推荐(0)
摘要: linux server https://github.com/prometheus/node_exporter Dashboard https://grafana.com/grafana/dashboards/1860 Windows Servers: https://github.com/pro 阅读全文
posted @ 2022-01-04 11:46 learnnote 阅读(428) 评论(0) 推荐(0)
摘要: rpm --import https://packagecloud.io/gpg.key [grafana]name=grafanabaseurl=https://packages.grafana.com/oss/rpm-betarepo_gpgcheck=1enabled=1gpgcheck=1g 阅读全文
posted @ 2021-12-28 10:25 learnnote 阅读(66) 评论(0) 推荐(0)
摘要: 1. /etc/my.cnf [client]socket=/usr/local/mydb/mysql.sockuser=rootpassword=tiger#skip-binary-as-hex [mysqld]datadir=/usr/local/mydbbasedir=/usr/local/m 阅读全文
posted @ 2021-12-06 10:45 learnnote 阅读(46) 评论(0) 推荐(0)
摘要: 注意:step 6 ,要操作如下1,2步骤 阅读全文
posted @ 2021-11-02 14:57 learnnote 阅读(35) 评论(0) 推荐(0)
摘要: ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection. 1. Remove the repluser dr 阅读全文
posted @ 2021-11-02 11:36 learnnote 阅读(192) 评论(0) 推荐(0)
摘要: 开启闪回恢复区 在主库上操作 alter system archive log current alter system set log_archive_dest_state_2=defer; 在从库操作如下(将standby数据库变为read write) alter database recov 阅读全文
posted @ 2021-10-29 14:16 learnnote 阅读(176) 评论(0) 推荐(0)
摘要: 准备: 1)二进制mysql数据库8.0安装软件 2) my.cnf 3) 如下脚本 #!/usr/bin/sh Data_dir='/usr/local/mydb'Mysql_dir='/usr/local/mysql'Log_file='file.log' CHK_DIR(){ if [ -d 阅读全文
posted @ 2021-10-26 11:34 learnnote 阅读(203) 评论(0) 推荐(0)