search

genghisken / psat-server

Core python3 and C++ code for ATLAS and Pan-STARRS science servers
MIT License
1 stars 0 forks source link

Migration - Change backend of all tables in destination database to be InnoDB #6

Open genghisken opened 1 year ago

genghisken commented 1 year ago

We eventually want to migrate the database off MySQL to MariaDB / Galera. In order to do this we MUST change the backend of each table to be InnoDB and stop relying on MyISAM.

For a start, we should rebuild the database tables in the new database before migration to be InnoDB. We may run into commit issues though. (See issue #5.)

genghisken commented 1 year ago

There is code on psat-server-web repository (convert_backend_storage_to_innodb.sql) to convert the backend of all the tables to InnoDB. It just needs to be run once.