does anyone have any experience with blue/green deployment strategies using magento?
My basic idea is to have 2 installs (blue & green) with separate databases, and in addition an extra database to store users, orders, sessions etc... anything that needs to stay up to date regardless of whether blue or green is live. Then I can flip between blue and green without my customers or orders regressing.
I found some basic information here: how to connect another database from magento about connecting a model in magento to a different database, I guess my questions are:
1) Is this setup feasible at all? and if it is then....
2) What models would I need to point at the shared database?
edit: this was put on hold for being opinion based.... however, I'm asking 2 specific questions. Will this setup work, ie: is there any technical reason (ie: database joins) that it won't work and, to make it work which models would I have to point at the shared database ie: what models does the customer model rely on, what models do I need to move over so that the orders model has everything it needs and so on.