How would be the deployment of a new database version while running ?
Some points should not be forgotten :
- Data migration from one version to another version (For instance, a PostgreSQL 9.4 data cannot run with a PostgreSQL 9.5, a data migration script needs to be executed before redirecting the traffic)
- Load balancing the request to the old instance during the deployment, and then redirecting all the connections to the new database instance
Whatever are the solutions and their pros and cons, they should be listed somewhere.