不可思议的项目，MariaDB从库落后三年？

##

不可思议的项目，MariaDB从库落后三年？

1、项目开始

不敢相信，从库都落后三年了

2、项目过程

Master的数据

MariaDB [(none)]> SELECT ;
+--------------------+------------+-----------+-----------+----------------+
| DB_NAMES           | ROWS       | Data(MB)  | Index(MB) | Fragmented(MB) |
+--------------------+------------+-----------+-----------+----------------+
| abc                | 1318642778 | 340160.74 | 135631.10 |        4911.00 |
| mysql              |       1205 |      2.28 |      0.19 |           0.00 |
| information_schema |       NULL |      0.00 |      0.00 |           0.00 |
| sys                |          6 |      0.01 |      0.01 |           0.00 |
| performance_schema |    5317005 |      0.00 |      0.00 |           0.00 |
+--------------------+------------+-----------+-----------+----------------+
5 rows in set (0.041 sec)

Slave数据

MariaDB [(none)]> SELECT ;
+--------------------+----------+----------+-----------+----------------+
| DB_NAMES           | ROWS     | Data(MB) | Index(MB) | Fragmented(MB) |
+--------------------+----------+----------+-----------+----------------+
| abc                | 46988947 | 68365.05 |   5237.10 |          74.00 |
| mysql              |     1248 |     2.04 |      0.19 |          10.00 |
| information_schema |     NULL |     0.00 |      0.00 |           0.00 |
| sys                |        6 |     0.01 |      0.01 |           0.00 |
| performance_schema |  4651149 |     0.00 |      0.00 |           0.00 |
+--------------------+----------+----------+-----------+----------------+
5 rows in set (0.021 sec)

MariaDB [(none)]> show slave status\G
*************************** 1. row ***************************
              Slave_IO_Running: No
             Slave_SQL_Running: Yes
             
                 Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'could not find next log; the first event 'mysql-bin.000843' at 24818379, the last event read from 'mysql-bin.000872' at 73038429782, the last byte read from 'mysql-bin.000872' at 73038429829.'

数据查两百多GB，binlog丢了N个，补数据是不可能了，只能重做。

3、关键点

1.mariadb-backup

2.存储空间不足

3.zstd压缩比

4.没有用户密码

5.move-back

4、项目结尾

清明在家干项目，三天摸鱼完成一个300GB的项目，收多少钱合适呢