Re:GitHub's online schema migration for MySQL
by xenomachina on Thursday May 03, 2018 @12:09PM
(#16987199)
> your application needs to handle both schemas during transition.
How is this typically done? Have a version number in the db? Have the app examine the schema with every transaction? Have the app assume old/new schema optimistically, and if that fails rollback and try with alt schema? Something else?
How is this typically done? Have a version number in the db? Have the app examine the schema with every transaction? Have the app assume old/new schema optimistically, and if that fails rollback and try with alt schema? Something else?