Automatic Schema upgrade support for production docker

[samarabbas]

Current recommendation for using Cadence docker is to not enable automatic schema upgrade. Schema upgrades are always applied out of band to underlying database before rolling out Cadence upgrade to the cluster. This issue is to allow schema upgrades to cluster as part of regular Cadence upgrade automatically. All schemas are versioned and schema upgrade could be applied to database when service comes up. We do need to address race condition to make sure schema upgrades are safe if performed from multiple hosts.

[mfateev]

Ideally we want to ensure atomicity of an update as well as the update script can fail in the middle of its execution.

[mingfang]

This tool may be useful https://github.com/golang-migrate/migrate.