Production

[olaronymax]

hello! I'm using MindsDB and I would like to know how to put it into production using Docker Compose and Nginx. Is there any tutorial available?

[ianu82]

Hey @olaronymax, I don't believe we have a tutorial but we'd be happy to assist. @ZoranPandovski or @martyna-mindsdb will be able to advise.

Would love to know all about your use case if you're able to share :-)

[janbrb]

Hi @ianu82 , I am also looking for a production ready build using Docker Compose. I tried pretty much anything I could find but cant get it to run.

I tried 23.10.5.0 and latest. With or without MDB_CONFIG_CONTENT env var.

MDB_CONFIG_CONTENT={"api": {"http": {"host": "0.0.0.0", "port": "47334"}, "mysql": {"host": "0.0.0.0", "port": "47335", "database": "mindsdb", "ssl": true}, "mongodb": {"host": "0.0.0.0", "port": "47336", "database": "mindsdb"}}}

Testet both locally on port 47334 and via traefik routing on domain (all routers and services working)

Hope I can get some help here and try it out in a current project! :)

version: "3.7"
services:
  mindsdb:
    image: mindsdb/mindsdb:23.10.5.0
    command: bash -c "python3 -m mindsdb --api=http,mysql,mongodb"
    volumes:
      - mindsdb_data:/root 
    networks:
      - proxy
    deploy:
      restart_policy:
        condition: any 
      placement:
        constraints: [node.role == manager]
    labels:
      - "traefik.enable=true"
      - "traefik.docker.network=proxy"
      - "traefik.http.routers.mindsdb.rule=Host(`example.com`)"
      - "traefik.http.services.mindsdb.loadbalancer.server.port=47334"
      - "traefik.http.routers.mindsdb.entrypoints=web,websecure"
    ports:
      - "47334:47334"
      - "47335:47335"
      - "47336:47336"

networks:
  proxy:
    external: true

volumes:
  mindsdb_data:

[ianu82]

Hey @janbrb, thanks for your message and sorry to hear that you're having trouble.

@martyna-mindsdb or @ZoranPandovski - are you able to advise on how to troubleshoot?

[martyna-mindsdb]

@StpMax
Would you be able to advise on running MindsDB with Nginx please?

[StpMax]

If you need nginx only as http proxy, then there is no big reason to use it. You can just change port mapping to 47334:80. If you need ssl, then nginx config should be like:

server {
    listen 443 ssl;
    listen [::]:443;
    server_name _;
    ssl_certificate /path_to_cert.pem;
    ssl_certificate_key /path_to_cert_key.pem;
    
    client_max_body_size 10000M;

    location /{
        proxy_pass http://{mindsdb_hostname}:47334;
        proxy_set_header Host $server_name;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_connect_timeout       1200;
        proxy_send_timeout          1200;
        proxy_read_timeout          1200;
        send_timeout                1200;
    }