姚远的博客

xtrabackup备份MySQL时，可能会出现拿不到锁而超时失败的现象，这里说明解决办法。

Innodb集群是有多个节点组成的，这些节点的数据是同步的。对于Innodb集群的备份，通常只需要在一个节点上进行备份。当需要恢复时，可以把备份集恢复到集群中的任意一个节点上。下面通过实验说明在同一节点和不同节点上进行恢复的方法。实验环境实验的集群是有3个沙箱实例组成的一个InnoDB集群，集群的成员信息如下：mysql> select MEMBER_ID,MEMBER_HOST,MEMBER_PORT,MEMBER_STATE,MEMBER_ROLE FROM performance_sch

一个MySQL数据库备份的时候出现下面的错误：InnoDB: Operating system error number 24 in a file operation.InnoDB: Error number 24 means ‘Too many open files’ InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-

RMAN> show ARCHIVELOG DELETION POLICY ;RMAN configuration parameters for database with db_unique_name ORCL are:CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultSQL> set linesize 200; select * from v$flash_recovery_area_usage where FILE_T

备份时出现下面的提示Unknown redo log format (4). Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/ upgrading-downgrading.html.MySQL8.0.20的Release Note中有下面的提示：InnoDB: Redo log records for modifications to undo tablespaces increased in size

https://mp.weixin.qq.com/s/jX1RSOcHq0LTUPwXaHqjfQ