1
JohnBull 2022-10-30 17:04:40 +08:00
有
|
2
Pteromyini 2022-10-30 18:18:33 +08:00 1
快照是快照,备份是备份,这是两回事
|
3
edis0n0 OP @Pteromyini #2 有点没说清楚,补充一下,是 PVE SNAPSHOT 模式创建的备份,含全盘数据(不含内存),备份完就传到 aws 的 S3 桶
|
4
Pteromyini 2022-10-31 09:52:15 +08:00
@edis0n0 风险肯定有,但是会很低
|
5
rykinia 2022-10-31 11:38:03 +08:00
mysql 可能有数据没刷盘,导致备份出来的缺了一部分。
|
6
lookStupiToForce 2022-10-31 15:10:03 +08:00
理论上 mysql 内存里也有 binlog cache (其他数据库同理),要是取快照的时候这部分没落盘但又存着关键数据,你就得等着哭了
|
7
kkk123 2022-10-31 15:36:13 +08:00
有机会仆街,刚恢复一个 mariadb 10 快照,db 自己恢复了。
2022-10-31 15:30:31 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=724647025,724647025 2022-10-31 15:30:31 0 [Note] InnoDB: Starting final batch to recover 847 pages from redo log. 2022-10-31 15:30:46 0 [Note] InnoDB: To recover: 555 pages from log 2022-10-31 15:30:56 0 [Note] InnoDB: 128 rollback segments are active. 2022-10-31 15:30:56 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-10-31 15:30:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-10-31 15:30:56 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-10-31 15:30:56 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-10-31 15:30:56 0 [Note] InnoDB: 10.5.9 started; log sequence number 729310827; transaction id 4179210 |
8
abellee000 2022-10-31 16:10:57 +08:00
生产环境的备份一般用啥啊
|