topic Re: Difference between embedded Mongo database and User-Managed MongoDB, Pros and Cons in Alteryx Server Discussions

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

Abe_Braham_ — Thu, 05 Mar 2020 23:15:08 GMT

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 🙂

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

ianwhite — Mon, 09 Mar 2020 23:12:43 GMT

Hi Abe,

It'd depend on your use case. I believe most users end up with embedded, at least in the cases I've seen and assisted with. If something were to go wrong with writing to or managing the MongoDB, in a User-Managed situation we'd only be able to help with ensuring there's communication between the two. Re-indexing or manipulating the data is something we couldn't do, from a support perspective.

If you have a database admin on staff, you could consult with them on if that's a move you want to make. If you're just doing a single server/gallery set up then embedded will likely be the easiest solution.

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

Abe_Braham_ — Tue, 10 Mar 2020 16:44:18 GMT

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.

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

ianwhite — Tue, 10 Mar 2020 19:41:11 GMT

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.

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

somervill — Tue, 30 Aug 2022 15:49:53 GMT

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.