Fórum

Database Scheme Changes

thumbnail
Lisa Simpson, modificado 14 Anos atrás.

Database Scheme Changes

Liferay Legend Postagens: 2034 Data de Entrada: 05/03/09 Postagens Recentes
1) There should be one schema per Liferay instance. It should contain the stuff required to operate Liferay the application and no more.

2) There should be another schema for each portal instance (ala the control panel) with a unique identifier. In my case, that would be:

www.website.com
www.mydomain.com
www.blinkythings.com
www.roundthings.com



Splitting this up in to things that are application-wide in a given Liferay instance and for each virtual host should allow for enormous flexibility and portability (ability to move from one physical host to another). It would also make it easier to set up settings that were unique to a given portal instance.
thumbnail
Amos Fong, modificado 14 Anos atrás.

RE: Database Scheme Changes

Liferay Legend Postagens: 2047 Data de Entrada: 07/10/08 Postagens Recentes
Hi Lisa,

Have you looked into sharding? It think it does what you want:

http://www.liferay.com/web/alexander.chow/blog/-/blogs/sharding-databases-an-unorthodoxed-design