Assistence in Setting a Online installation and migrating offline setup details

Could someone please help me carry out an online installation on Google Cloud, AWS EC2 instance? There is a Corteza CRM production setup video (https://www.youtube.com/watch?v=9pgQHjMkOMc 468) that discusses this installation but I believe it is outdated. Could anyone please point me to a newer version of this video?

I already have an offline installation running which I have been experimenting with. Could the changes done in the development environment be exported via DB dumps or otherwise into the production server once deployed?

What additional aspects should I consider especially regarding the Online installation that I do not have to do in the offline installation?

These were sample steps I gathered for creating a new Google Cloud instance, installing required software (Nginx, Docker, Docker Compose), setting up Corteza CRM, and configuring SSL keys and domain assignments. Anything other points to be considered?

Step 1: Create a Google Cloud Instance

  • Sign in to Google Cloud Console:
    • Go to the Google Cloud Console and sign in with your Google account.
  • Create a New Compute Engine Instance:
    • Navigate to Compute Engine > VM instances.
    • Click on “Create Instance”.
    • Configure the instance with the following details:
      • Name: Choose a name for your instance.
      • Region and Zone: Select a region and zone.
      • Machine type: Choose a suitable machine type (e.g., f1-micro for Free Tier).
      • Boot disk: Select “Ubuntu” as the operating system and choose the version.
      • Firewall: Allow HTTP (80) and HTTPS (443) traffic.
      • Networking: Assign a static external IP address.

Step 2: Install Required Software

  • SSH into the Instance:
    • Click on the SSH button next to the instance to connect to it.
  • Install Nginx:
    • Update the package list: sudo apt update.
    • Install Nginx: sudo apt install nginx.
    • Start Nginx: sudo systemctl start nginx.
    • Verify Nginx is running: Open a web browser and enter your instance’s external IP address.
  • Install Docker and Docker Compose:
    • Install Docker: Follow the official Docker installation guide.
    • Install Docker Compose: Follow the official Docker Compose installation guide.

Step 3: Install Corteza CRM

  • Clone Corteza Repository:
  • Configure Corteza:
    • Navigate to the Corteza directory: cd corteza-server.
    • Edit the .env file to configure Corteza settings.
  • Start Corteza:
    • Start Corteza using Docker Compose: docker-compose up -d.

Step 4: SSL Keys and Domain Assignment

  • Obtain SSL Certificate:
    • Obtain a free SSL certificate from Let’s Encrypt using Certbot.
    • Follow the instructions to generate SSL keys for your domain.
  • Assign Domain to Corteza:
    • Configure Nginx to serve Corteza over HTTPS.
    • Update Nginx configuration to use SSL certificates.
    • Point your domain to the instance’s static external IP address.

Step 5: Verification

  • Verify Nginx Configuration:
    • Check Nginx configuration syntax: sudo nginx -t.
  • Verify Docker and Corteza Installation:
    • Check Docker Compose configuration: docker-compose config.
    • Access Corteza CRM using your domain over HTTPS and verify it is working.

Note: Make sure to monitor resource usage to stay within the Free Tier limits.