We are having a web application developed j2ee/Spring.
We are planning to implement SaaS model by using different schema for each customer.
Please suggest the best way to do it.
We are blank how to start the process ? How can we map different customer to different DB ?
Thanks
解决方案
For using different schema for each customer you need to come up with an identifier(s) that can be used to uniquely identify the customer schema or the tenant schema. It is usually a tenant identifier key.
Neil's answer has provided useful links on actually making connections to different tenant databases.
Below is a link to one of my posts that talks about the db architecture and related items.