[CI] Deployment Automation + API/DB Connection checks

[thedavidprice]

related Issue #1886

I'm currently running manual Netlify and Vercel deploys, which requires 1) checking build logs for clean build and 2) checking deployed site to confirm API connection and DB are working accordingly.

We need to automate deploy and API/DB tests:

• when canaries are published, could trigger a workflow to install, modify, and deploy a project (note: modification needs to be automated as well for consistency across a growing number of deploy targets)
• would need DBs and, likely, resetting a DB before each deploy
• use Pingdom or some other cron tasks to consistently check API endpoints
• alerts+notifications: recommend create a notification channel in the Core Team's Slack Workspace

[thedavidprice]

Based on my current status with this repo https://github.com/redwoodjs/deploy-target-ci I'm call it "good enough" for this Issue. What I've done:

• set up deploys and triggers for Netlify and Vercel
• set up deploy local for Serverless. Waiting for confirmation that it's not possible to use Serverless dashboard for CD ('cause yarn workspace). Can add GH Action and Slack message if needed (Slack might work via dashboard regardless)
• set up Pingdom for web and api: Netlify, Vercel, Serverless. Notifications in Slack.
• set up the initial Render project
• Added Renovate for canary releases (not working much at all)

TO DO (post v1):

• Serverless CD: auth via GH secret
• Render: Have no idea how to set up CD for monorepo and workspaces
• Rebuild projects: ideally when breaking changes happen we'd have automation to rebuild each project