[Lvfs-announce] LVFS Downtime Tomorrow

Richard Hughes hughsient at gmail.com
Tue Jan 14 17:31:06 UTC 2020


Hi all,

Tomorrow morning (~10AM UTC) I'm going to migrate the production
database from a self-hosted MySQL instance to a managed PostgreSQL
instance. I have been fixing up the code ready for this for about a
week now. I've tested the migration and it takes 15 minutes to migrate
and upload 4GB of data, and then a few minutes longer to fix up the
schema and restart services. Whilst the migration is ongoing I will
stop the uwsgi services to ensure the databases do not get out of
sync, and therefore all access to the LVFS (and firmware downloads!)
will be unavailable. The advantages of moving the database are:

* We can do hourly off-site live backups, rather than weekly mysqldump's
* We free up some resources (disk/CPU/memory) on the server so we can
continue to grow
* The performance is much greater, so we can further reduce the
load-time of the various LVFS blueprints
* We can leverage some of the features of postgres in the future, for
instance using Full Text Search in the various search interfaces

If anything goes wrong during the migration or test process I will
roll back the changes and go back to the self-hosted MySQL database.

Richard


More information about the LVFS-announce mailing list