Spin up the docker-compose stack from https://github.com/Toumash/mlflow-docker that populates a mysql instance (with root password toor
)
Inside the container, verify with pip
that pip install mlflow
installed the latest 1.28
version:
(base) root@4900a8349bf0:/# pip show mlflow
Name: mlflow
Version: 1.28.0
Summary: MLflow: A Platform for ML Development and Productionization
Home-page: https://mlflow.org/
Author: Databricks
Author-email:
License: Apache License 2.0
Location: /opt/conda/lib/python3.9/site-packages
Requires: alembic, Flask, requests, gunicorn, importlib-metadata, sqlparse, querystring-parser, databricks-cli, protobuf, entrypoints, cloudpickle, numpy, pytz, docker, scipy, packaging, sqlalchemy, gitpython, click, pandas, prometheus-flask-exporter, pyyaml
Required-by:
Generate a full SQL dump (attached as 2-mlflow.sql
) with:
docker exec -it 1b774240295c mysqldump -u root -p mlflow
mysql> show tables;
+-----------------------+
| Tables_in_mlflow |
+-----------------------+
| alembic_version |
| experiment_tags |
| experiments |
| latest_metrics |
| metrics |
| model_version_tags |
| model_versions |
| params |
| registered_model_tags |
| registered_models |
| runs |
| tags |
+-----------------------+
12 rows in set (0.00 sec)
mysql> describe alembic_version; describe experiment_tags; describe experiments; describe latest_metrics; describe metrics; describe model_version_tags; describe model_versions; describe params; describe registered_model_tags; describe registered_models; describe runs; describe tags;
| alembic_version |
+-------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| version_num | varchar(32) | NO | PRI | NULL | |
+-------------+-------------+------+-----+---------+-------+
1 row in set (0.00 sec)
| experiment_tags |
+---------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+---------------+------+-----+---------+-------+
| key | varchar(250) | NO | PRI | NULL | |
| value | varchar(5000) | YES | | NULL | |
| experiment_id | int(11) | NO | PRI | NULL | |
+---------------+---------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
| experiments |
+-------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+----------------+
| experiment_id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(256) | NO | UNI | NULL | |
| artifact_location | varchar(256) | YES | | NULL | |
| lifecycle_stage | varchar(32) | YES | | NULL | |
+-------------------+--------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
| latest_metrics |
+-----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| key | varchar(250) | NO | PRI | NULL | |
| value | double | NO | | NULL | |
| timestamp | bigint(20) | YES | | NULL | |
| step | bigint(20) | NO | | NULL | |
| is_nan | tinyint(1) | NO | | NULL | |
| run_uuid | varchar(32) | NO | PRI | NULL | |
+-----------+--------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
| metrics |
+-----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| key | varchar(250) | NO | PRI | NULL | |
| value | double | NO | PRI | NULL | |
| timestamp | bigint(20) | NO | PRI | NULL | |
| run_uuid | varchar(32) | NO | PRI | NULL | |
| step | bigint(20) | NO | PRI | 0 | |
| is_nan | tinyint(1) | NO | PRI | 0 | |
+-----------+--------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
| model_version_tags |
+---------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------------+------+-----+---------+-------+
| key | varchar(250) | NO | PRI | NULL | |
| value | varchar(5000) | YES | | NULL | |
| name | varchar(256) | NO | PRI | NULL | |
| version | int(11) | NO | PRI | NULL | |
+---------+---------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
| model_versions |
+-------------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+---------------+------+-----+---------+-------+
| name | varchar(256) | NO | PRI | NULL | |
| version | int(11) | NO | PRI | NULL | |
| creation_time | bigint(20) | YES | | NULL | |
| last_updated_time | bigint(20) | YES | | NULL | |
| description | varchar(5000) | YES | | NULL | |
| user_id | varchar(256) | YES | | NULL | |
| current_stage | varchar(20) | YES | | NULL | |
| source | varchar(500) | YES | | NULL | |
| run_id | varchar(32) | YES | | NULL | |
| status | varchar(20) | YES | | NULL | |
| status_message | varchar(500) | YES | | NULL | |
| run_link | varchar(500) | YES | | NULL | |
+-------------------+---------------+------+-----+---------+-------+
12 rows in set (0.00 sec)
| params |
+----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| key | varchar(250) | NO | PRI | NULL | |
| value | varchar(500) | NO | | NULL | |
| run_uuid | varchar(32) | NO | PRI | NULL | |
+----------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
| registered_model_tags |
+-------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------------+------+-----+---------+-------+
| key | varchar(250) | NO | PRI | NULL | |
| value | varchar(5000) | YES | | NULL | |
| name | varchar(256) | NO | PRI | NULL | |
+-------+---------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
| registered_models |
+-------------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+---------------+------+-----+---------+-------+
| name | varchar(256) | NO | PRI | NULL | |
| creation_time | bigint(20) | YES | | NULL | |
| last_updated_time | bigint(20) | YES | | NULL | |
| description | varchar(5000) | YES | | NULL | |
+-------------------+---------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
| runs |
+------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| run_uuid | varchar(32) | NO | PRI | NULL | |
| name | varchar(250) | YES | | NULL | |
| source_type | varchar(20) | YES | | NULL | |
| source_name | varchar(500) | YES | | NULL | |
| entry_point_name | varchar(50) | YES | | NULL | |
| user_id | varchar(256) | YES | | NULL | |
| status | varchar(9) | YES | | NULL | |
| start_time | bigint(20) | YES | | NULL | |
| end_time | bigint(20) | YES | | NULL | |
| source_version | varchar(50) | YES | | NULL | |
| lifecycle_stage | varchar(20) | YES | | NULL | |
| artifact_uri | varchar(200) | YES | | NULL | |
| experiment_id | int(11) | YES | MUL | NULL | |
| deleted_time | bigint(20) | YES | | NULL | |
+------------------+--------------+------+-----+---------+-------+
14 rows in set (0.00 sec)
| tags |
+----------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+---------------+------+-----+---------+-------+
| key | varchar(250) | NO | PRI | NULL | |
| value | varchar(5000) | YES | | NULL | |
| run_uuid | varchar(32) | NO | PRI | NULL | |
+----------+---------------+------+-----+---------+-------+
3 rows in set (0.00 sec)