Difference between embedded Mongo database and User-Managed MongoDB, Pros and Cons

Question

Hello Alteryx colleagues!,

We are setting up all the alteryx sever, but is not clear for us what are the advantages  or disadvantages of select a User-Managed Mongo DB configuration against the standard option. In your experience, is it a good idea to manually mange the MongoDB or is it better to let Alteryx do the work?.

thank you 🙂

somervill · Answer

Hey Ian, do you know why when I try to save the setting of user managed DB in the system setting while I cannot save the change properly.

ianwhite · Answer

unless you've got in the 6 digits of workflows, you probably won't notice a performance difference. I think it's just more if you have a database admin that wants to manage it yourself or have some specific needs as an organization for it to be a distributed set up.

Most performance changes from my experience come from running the actual workflows vs the storage of them.

Abe_Braham_ · Answer

Hello Ian,

Thank you so much for your reply. So basically the Alteryx support will be limited if we choose the "User-Managed" option, right?.  Talking about performance, is it any difference if we follow the "User-Managed" option? Does something change ?,or at the end we will have the same performance ?, I guess the embedded data base is optimized as per Alteryx requirements.

What is your opinion?.

Thank you.