https://community.databricks.com/t5/machine-learning/what-added-advantage-would-using-an-sql-alchemy-database-have/m-p/17679#M961 <P>Thanks for trying to help me @Kaniz Fatma​&nbsp;.</P><P>My question was not to learn how to set up mlflow with postgres. But, to learn what additional advantage would using an sql-alchemy database like postgres would have, instead of storing all the metadata to files. that is, what advantage would I have, if I use an sql-alchemy for backend and not use one. please note that, the mlflow server will not be in '--artifacts-only' mode?</P> Thu, 23 Jun 2022 13:09:16 GMT naveen_marthala 2022-06-23T13:09:16Z https://community.databricks.com/t5/machine-learning/what-added-advantage-would-using-an-sql-alchemy-database-have/m-p/17677#M959 <P>I am setting up mlflow server with Postgres and S3 on AWS ECS(or AWS EC2) for personal usage. I would like to know if using Postgres would actually give me any benefit?</P><P></P><P>as shown in <A href="https://www.mlflow.org/docs/latest/tracking.html#scenario-5-mlflow-tracking-server-enabled-with-proxied-artifact-storage-access=" alt="https://www.mlflow.org/docs/latest/tracking.html#scenario-5-mlflow-tracking-server-enabled-with-proxied-artifact-storage-access=" target="_blank">scenario 5 </A>in docs, I would like to set up server with proxied artifact storage, but without postgres in AWS RDS and also not in `--artifacts-only` and `--artifacts-only` modes as shown in <A href="https://www.mlflow.org/docs/latest/tracking.html#scenario-6-mlflow-tracking-server-used-exclusively-as-proxied-access-host-for-artifact-storage-access=" alt="https://www.mlflow.org/docs/latest/tracking.html#scenario-6-mlflow-tracking-server-used-exclusively-as-proxied-access-host-for-artifact-storage-access=" target="_blank">scenario 6</A> in docs. So, if i launch a mlflow tracking server like this, will all the metadata that usually gets saved to an SQLAlchemy database(postgres in my case) be saved to the location of attribute `--artifacts-destination` as files?</P><P></P><P>I would like to do this to save costs from AWS RDS that runs Postgres.</P><P></P><P><I>If you aren't familiar with AWS ECS, it is a fully managed service (a simpler version of kubernetes) that runs container base applications. and EC2 is just user managed machines or servers.</I></P> Wed, 15 Jun 2022 06:47:27 GMT https://community.databricks.com/t5/machine-learning/what-added-advantage-would-using-an-sql-alchemy-database-have/m-p/17677#M959 naveen_marthala 2022-06-15T06:47:27Z https://community.databricks.com/t5/machine-learning/what-added-advantage-would-using-an-sql-alchemy-database-have/m-p/17679#M961 <P>Thanks for trying to help me @Kaniz Fatma​&nbsp;.</P><P>My question was not to learn how to set up mlflow with postgres. But, to learn what additional advantage would using an sql-alchemy database like postgres would have, instead of storing all the metadata to files. that is, what advantage would I have, if I use an sql-alchemy for backend and not use one. please note that, the mlflow server will not be in '--artifacts-only' mode?</P> Thu, 23 Jun 2022 13:09:16 GMT https://community.databricks.com/t5/machine-learning/what-added-advantage-would-using-an-sql-alchemy-database-have/m-p/17679#M961 naveen_marthala 2022-06-23T13:09:16Z