Hey everyone, I was just wondering, if there are any complete guides on how to deploy a full prisma application to a root server running Ubuntu. I would like to host my first project like this to save some money until it scales up, concerning user counts. (including graphql-yoga server)

I used this

docker-compose.yml

to create a prisma cluster on my server

@horia.ancas Thank you very much. I will look into the repository.

The Prisma DigitalOcean tutorial should work for any Ubuntu VPS install. I don’t recall anything DO specific. You’ll want to combine that tutorial with setting up a production Node app. DO has great tutorials on that.

@pasa Patrick, yes you can set it all up on one server. You may find my tutorial helpful: https://github.com/maxdarque/prisma-docker My setup is AWS Lambda + Apex/Up for the server, Prisma running on docker on a free EC2 instance, and AWS RDS MySQL. I have only had my server running locally on docker with: Dockerfile

FROM node:8.9.4-alpine

# create a work directory inside the container
RUN mkdir /app
WORKDIR /app

# Install app dependencies
# A wildcard is used to ensure both package.json AND package-lock.json are copied where available (npm@5+)
COPY package*.json ./
COPY yarn.lock ./

# install utilities
RUN npm install -g yarn

# install dependencies
RUN yarn

COPY dist/. /app/dist/.
COPY src/. /app/src/. 

EXPOSE 8080

CMD [ "yarn", "start" ]

docker-compose.yml

version: "3"
services:
  graphql-server:
    image: max/graphql-server:0.1
    container_name: "graphql-server"
    restart: always
    ports: 
      - "0.0.0.0:${PORT}:8080"
    env_file: .env

Does that answer your question?

@max Thank you very much, I will try my best. 😄

@pasa I also have this tutorial for setting up Apex/Up https://github.com/maxdarque/up-graphql-yoga-server-example

Well technically I should be able to run everything on my root server. Performance is not that big of a concern at the moment. Accessibility, on the other hand, is. When I reach some scale, I will scale up my setup too.

@pasa What do you mean by eject? Are you referring to a particular Prisma instance?

@max Thank you very much, for your answers. I'm currently setting up everything. When I run docker-compose up I get the Warning: 'SQL exception occurred: Unknown table 'replica_host_status' in information_schema' tough. Any thoughts about this? What could cause it and should I worry about it?