Can we deploy a mysql container from docker hub to Azure appservice ?

Question

Can we deploy a mysql container from docker hub to Azure appservice ?

varun 20

I'm trying to deploy a multi container application, my docker compose file contains a mysql database and my keycloak application.

But the application is not able to connect to the database, can someone advise if mysql docker container works inside azure app service?

Accepted answer

0 additional answers

Your answer

Answer 1

Ben Gimblett 4,560 Microsoft Employee

Hi varun - thanks for your question. The short answer is yes App Service supports this for Linux (please note it's currently a preview feature) and there's a "getting started" tutorial here that demonstrates the concept. See here.

Did you check spin up the docker compose file locally to check the correct ports are open etc etc?

varun 20

Hi Ben,

Thank you gettinng back, Yes I did the below docker-compose file runs perfectly on my local setup but when I update the JDBC URL and hostname I am getting error related to JDBC and mysql.

The connection string that I'm currently using is shared below.

KC_DB_URL=jdbc:mysql://database:3306/Keycloakdb

version: "3.9"

services:
  database:
    container_name: mysqldb
    image: mysql:latest
    command: --default-authentication-plugin=mysql_native_password
    environment:
        - MYSQL_DATABASE=Keycloakdb
        - MYSQL_ROOT_PASSWORD=sheep
        - MYSQL_USER=Bharath
        - MYSQL_PASSWORD=abcd@3456
    ports:
      - 3306:3306
    networks:
      - keycloak_network

  Keycloak:
    container_name: keycloak
    image: quay.io/keycloak/keycloak:21.1.1
    command: start-dev
    depends_on:
       - database
    working_dir: /opt/keycloak
    ports:
      - 8080:8080
    environment:
      - KEYCLOAK_ADMIN=Root
      - KEYCLOAK_ADMIN_PASSWORD=sheep
      - KC_DB=mysql
      #- KC_DB_URL=jdbc:mysql://database:3306/Keycloakdb defined at runtime using ENV
      - KC_DB_USERNAME=root
      - KC_DB_PASSWORD=sheep
      # - KC_HOSTNAME=localhost # defined at runtime using ENV
      - KC_HOSTNAME_STRICT=false  # Use only when deployed on VM 
      - KC_PROXY=edge # Use only when deployed on VM 
    networks:
      - keycloak_network

networks:
  keycloak_network:
    driver: bridge

Ben Gimblett 4,560 Reputation points Microsoft Employee

2023-05-19T13:28:41.22+00:00

what was the error?
Ben Gimblett 4,560 Reputation points Microsoft Employee

2023-05-19T13:35:26.1966667+00:00

...also please do be very careful posting publicly config with secrets - assume these are just dev/throwaway :) :)
varun 20 Reputation points

2023-05-19T13:37:10.81+00:00

logs.txtI have attached the log file copied from App service.
varun 20 Reputation points

2023-05-19T13:38:40.94+00:00

Thanks, Yes these services are up for a few minutes as part of testing and are destroyed from time to time.
Ben Gimblett 4,560 Reputation points Microsoft Employee

2023-05-19T13:51:01.64+00:00

I'm not an expert on either keycloak or mysql (just to be transparent) but if you look carefully at the log file wall-clock-times it looks like the db socket wasnt quite opened until just after the second connection attempt? Which may indicate a timing issue with the containers coming up
varun 20 Reputation points

2023-05-19T14:02:37.93+00:00

Hi Ben, Thanks that's strange since I do have a explicit depends on attribute set for this exact scenario does it takes time to open up the socket after setting up the container ?

I'm quite new to App service kindly bear with me on that.:)
Ben Gimblett 4,560 Reputation points Microsoft Employee

2023-05-19T14:04:59.64+00:00

Just looking further - I can see the web app preview for multi containers does NOT support depends on and you would need that to guarantee the order of containers coming up (see here)
Ben Gimblett 4,560 Reputation points Microsoft Employee

2023-05-19T14:07:44.91+00:00

yes i see you have depends_on
Ben Gimblett 4,560 Reputation points Microsoft Employee

2023-05-19T14:08:47.1166667+00:00

Yes , sorry i see you did have "depends_on" but as above its not supported in the preview (it's ignored). I'll see if i can find out if the team plan on supporting it for GA
varun 20 Reputation points

2023-05-19T14:15:21.25+00:00

Okay I think let me make a few tweaks and see if that worked and also since if it doesn't support docker networks do you have any article by any chance regarding networking in docker-compose on app services?
Ben Gimblett 4,560 Reputation points Microsoft Employee

2023-05-25T08:22:43.5933333+00:00

Varun I dont. I did check in with the team developing this feature and they cant give a estimate for GA so for now it stays in preview. They cant share more details as it is still a work in progress.

please do mark the answer as accepted if it's helped you as this also helps others

Best regards
varun 20 Reputation points

2023-05-26T07:42:41.15+00:00

Hi Ben,

Thank you, sure this has been resolved.

Share via

Can we deploy a mysql container from docker hub to Azure appservice ?

0 additional answers

Your answer