We have an XData/Webcore application that takes care of it's own logins at present. At present we have a server per client (there's only 2 at the moment), but want to convert it to a Multi-Tenant server with each tenant having their own database.
I want to use Sphinx to manage the logins and trying to think of the best way to do this:
A separate Sphinx server: This has advantages that if anyone has access to more than one system, they can select which one
- do I make this multi-tenant and issue login paths https://mysphinx.com/client1?
- not have it multi-tenant but issue a tenant id as the result of a successful login?
Keep the user tables within the client database and use the XData app to also manage the Sphinx elements - in which case it is all multi-tenanted.
Any thoughts? Or better approaches?