Hello, So the story is that I am trying to change...
# troubleshoot
b
Hello, So the story is that I am trying to change the MySQL to postgres in the yml file called
docker-compose-without-neo4j-m1.quickstart.yml
and I had modified the following settings:
Copy code
postgres:
    command: --character-set-server=utf8mb4 --collation-server=utf8mb4_bin
    container_name: postgres
    environment:
    - POSTGRES_DB=datahub
    - POSTGRES_USER=datahub
    - POSTGRES_PASSWORD=datahub
    hostname: postgres
    image: postgres:13
    ports:
    - 5432:5432
    volumes:
    - postgres-db-volume:/var/lib/postgresql/data
  postgres-setup:
    container_name: postgres-setup
    depends_on:
    - postgres
    environment:
    - POSTGRES_HOST=postgres
    - POSTGRES_PORT=5432
    - POSTGRES_USER=datahub
    - POSTGRES_PASSWORD=datahub
    - POSTGRES_DB=datahub
    hostname: postgres-setup
    image: acryldata/datahub-postgres-setup:head
Is this a correct way of addressing the change? Could you help by suggesting on how to change the volume. what should it point to?
d
@nutritious-bird-77396 please, can you help here how to do it?
n
@breezy-portugal-43538 Were there any issues with the volumes provided here? https://github.com/datahub-project/datahub/blob/master/docker/postgres/docker-compose.postgres.yml#L13
m
If you still want to use MySQL, try to add
platform: linux/amd64
in for mysql service, and it works on the M1
Copy code
mysql:
    command: --character-set-server=utf8mb4 --collation-server=utf8mb4_bin
    container_name: mysql
    environment:
    - MYSQL_DATABASE=datahub
    - MYSQL_USER=datahub
    - MYSQL_PASSWORD=datahub
    - MYSQL_ROOT_PASSWORD=datahub
    hostname: mysql
    image: mysql:5.7
    platform: linux/amd64
    ports:
    - 3306:3306
    volumes:
    - ./docker/mysql/init.sql:/docker-entrypoint-initdb.d/init.sql
    - mysqldata:/var/lib/mysql
d
actually I think it is better to use mariadb on m1 because it has arm based image as well-> like
mariadb:10.5.8
l
Hi @breezy-portugal-43538! Just checking in here - do you have the direction you need?
b
Hey everyone, thanks a lot for all the help, right now mySQL -> postgres was moved to a background due to resolving current issues, but as soon as I will get back to it and face some problems I will give a reply, thanks a lot for all the help, you are great guys!
teamwork 1
w
Hello, all. @nutritious-bird-77396 I am tring to find how to change data store form mysql to other DB. And I also want to know How to change datahub db endpoint to change data store(mysql -> other db) I already have db server. I deployed DataHub using docker container.