I am planning to deploy multiple openedx instances running on the same server to save costs. What if those instances connect to the same database (using the same username, password and database name). Is it possible to take advantage of the course_org_filter feature on MFE with tutor?
You can definitely deploy multiple Open edX instances on the same server or on the same Kubernetes cluster to save costs. And they can all use the same MySQL server. However, you should give each instance a separate database name, and separate username/password credentials. Otherwise you will essentially just be running two copies of the same instance, with the same data, but potentially different configuration.
I believe course_org_filter is part of the old sites/microsites feature and isn’t recommended if it even works at all. But I could be wrong. Generally though we now recommend you use fully separate instances if you want separate sites.