Update Architecture documentation

[corneil]

Update architecture documentation with recommendations for production deployments and gotchas to avoid.

Like only use Local platform if you are running a few batch jobs with dedicated requirements.
Don't use Local Docker for production deployments.
Don't use single container database for production deployments.