How can I model this schema in MySQL?
Have you thought about what happen with stale/old data??

Each new version creates a ton of new entries.
Management becomes a nightmare
the DB becomes a SPOF(single point of failure).


Better Solution: Service discovery
The better solution would be to use a Service discovery System and annote each Service with their version and the environment as a Metadata tag. This keeps the System more manageble.
More Help
IMHO, sticking Linux Code into a Docker Image and run multiple copies of it, is the best way of getting a immutable infrastructure up and running.