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.