随笔分类 - mysql->备份和恢复
摘要:场景: 主库执行delete语句,但是发现从库对应的记录不存在. mysql> show slave status \G;*************************** 1. row *************************** Slave_IO_State: Waiting fo
阅读全文
摘要:我们这里的环境是主从环境,我们将从库先升级到新的版本,然后将从库升级为主库,再升级原来的主库,完成主从环境的升级. 从库mysql_upgrade升级 mysql5.6升级到mysql5.7具体版本:5.6.40-->5.7.301.下载并安装新版本的mysql我们这里下载5.7.30并进行安装2.
阅读全文
摘要:mysql5.6升级到mysql5.7具体版本:5.6.40-->5.7.301.下载并安装新版本的mysql我们这里下载5.7.30并进行安装2.停掉原来旧版本的数据库/opt/mysql5640/bin/mysqladmin -h localhost -uroot -pmysql --socke
阅读全文
摘要:mysql> show slave status \G;*************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Hos
阅读全文
摘要:2020-06-30 19:21:03 2901 [ERROR] Error reading packet from server: binlog truncated in the middle of event; consider out of disk space on master; the
阅读全文
摘要:mysql> show slave status \G;*************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Hos
阅读全文
摘要:grant select, reload, lock tables, replication client, show view, trigger on *.* to 'dbdumpuser'@'%' identified by 'aaaa#DumpData';
阅读全文
摘要:备份 1.dump备份数据库 dump备份db1数据库 #mysqldump -uroot -pmysql -h hxl db1 >/mysqlbak/hxl_db_dump_20121208 备份数据库oss03 ./mysqldump -h localhost -uroot -pmysql --
阅读全文
摘要:环境: OS:Centos 7 1.备份/opt/xtrabackup-8.0.7/bin/xtrabackup --defaults-file=/opt/mha/mysql8/conf/my.cnf --host=localhost --user=root --password=mysql --p
阅读全文
摘要:[root@localhost tmp]# more wget.sh #!/bin/bash download_url=`python /tmp/geturl.py` echo $download_url download_date=`date "+%Y%m%d%H%M%S"` start_time=`date "+%Y%m%d %H%M%S"` echo 'start_time='${sta...
阅读全文
摘要:1.停掉从库/opt/mysql57_slave/bin/mysqladmin -h localhost -uroot -P13306 -pmysql -S /opt/mysql57_slave/mysql.sock shutdown 2.主库上创建同步账号 grant replication sl
阅读全文
摘要:DB:5.6.15 主从库没有采用GTID案例1:从库对象不存在mysql> show slave status \G;*************************** 1. row *************************** Slave_IO_State: Waiting for
阅读全文
摘要:python版本[testuser@localhost tmp]$ python -VPython 2.7.5 需要提前安装RDS[root@localhost ~]# yum -y install epel-release[root@localhost ~]# yum -y install pyt
阅读全文