docker-compose.yml

# docker-compose et instructions pour comparer 2 versions d'une base de données.
# (faut être trop pressé)

version: '3'

services:

  mysql_un:
    image: mysql:5.7
    container_name: mysql_un
    environment:
      MYSQL_ROOT_PASSWORD: pass
    expose:
      - 3307
    ports:
      - 3307:3307
    networks:
      - mysql_un
    command: mysqld --port 3307

  mysql_deux:
    image: mysql:5.7
    container_name: mysql_deux
    environment:
      MYSQL_ROOT_PASSWORD: pass
    expose:
      - 3308
    ports:
      - 3308:3308
    networks:
      - mysql_deux
    command: mysqld --port 3308

networks:
  - mysql_un
  - mysql_deux

# creation des bases dans les 2 instances :
#  mysql -h 0.0.0.0 -P 3307 -uroot -ppass -e "create database labase_17;"
#  mysql -h 0.0.0.0 -P 3308 -uroot -ppass -e "create database labase_17;"

# injection des bases :
# zcat dev/sql/dumps/dump.sql.gz | mysql -h 0.0.0.0 -P 3306 -uroot -ppass labase_17
# zcat dev/sql/dumps/fetched_dev | mysql -h 0.0.0.0 -P 3307 -uroot -ppass labase_17

# lancement de la machine avec mysqldbcompare :
#  podman run -it --network host  ziodave/mysqldbcompare:1
# lancement de la comparaison
# mysqldbcompare --difftype=sql --quiet --skip-table-options --run-all-tests --server1=root:pass@0.0.0.0:3307 --server2=root:pass@0.0.0.0:3308 labase_17:labase_17