Hi guys, is anyone using a shared database for multiple environments and multiple hosts per environment?

@User May I suggest “folks” instead of "guys"? We use gender inclusive language in this Discord 😀

You mean as in a standard Umbraco formally load-balanced production setup? Not for development purposes?

- I have ONE database for development staging and production - not using load balancing - using blue green deployment by switching azure app service slots - using multiple hostnames because my site is multi language this setup worked fine until umbraco version 14 since v14 we have a problem with openiddict / redirect uri when logging in/out in backend for ref:https://github.com/umbraco/Umbraco-CMS/issues/16807

The** same literal database** for dev/staging/production?

yes

> is anyone using a shared database for multiple environments and multiple hosts per environment? I've been working with Umbraco for over a decade now and worked on all kinds of projects. No, I have never heard of anyone attempting this... until now. The thought of the developer experience makes me shudder, but hey, if it works for you 🤷 This is certainly not a scenario that's officially supported, and is quite an edge case - i.e. this setup could break, and for all kinds of reasons, at the drop of a hat.

Hey Jason, thanks for your reply, we will rethink our strategy.

I think we used a shared development database at some point in the past, but uSync + Model Builder has worked perfectly for us since at least v8. If you setup uSync + Model Builder correctly, you will have all the "advantages" of a shared database (except, of course, having fewer databases) and none of the drawbacks.