java saas技术架构,Java Web应用程序-如何使用多模式架构实现Saas?

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.