We have a central read-only MySQL database that contains geo data, etc. It is used by various projects. As part of a refactoring, I am thinking about setting up a system for versioning the database. The rough idea so far:
The current database is version
1. It is available at:
When in the future the database structure is changed in an incompatible way, then the version number is increased to
2, and the new database is made available at:
That allows updating projects one by one from interfacing with
1.database.example.comto interfacing with
2.database.example.com. Due to the different domain name, it is possible to use a different database server for
2.database.example.com, even one not based on MySQL.
Does that make sense? Is there a standard or recommended way for “versioning” a read-only database?