shatteredsilicon / ssm-submodules

GNU Affero General Public License v3.0
0 stars 2 forks source link

Improve Upgrade Process #240

Closed gordan-bobic closed 3 months ago

gordan-bobic commented 4 months ago

It looks like we still upgrade through mysqldump/restore. This is hugely inefficient.

https://github.com/shatteredsilicon/ssm-server/blob/ssm-1.x/entrypoint.sh#L78

Instead we should do something like:

RENAME TABLE pmm.$tablename TO ssm.$tablename;

for each table. That will complete near instantaneously and not require tons of disk I/O and CPU.