Liferay is a Gartner Magic Quadrant Leader for the Sixth Year! Find out why
« Torna a Database...

Database Sharding

Introduction #

Database sharding is a way of scaling your database horizontally. For a given table or set of tables, you split up the data that is stored and fetched based on a given hash or something like that. Google, Facebook, and Wikipedia all use database sharding.

Benefits #

  • One database does not get overloaded
  • Smaller queries (since each table has less data now)
  • Better overall throughput under load because all your IO is not going through one database server.

Sharded Portal Instances #

At present, sharding exists in Liferay from version 5.2.3+ for handling data across multiple portal instances. Here's what you do to get it up.

  1. After you have a normally working development environment, make sure your hosts file is setup to allow virtual hosting (for our convenience, I will call the hosts abc1.com, abc2.com, abc3.com, etc.).
  2. Use the create-minimal SQL script (from our Downloads section) to create and populate three database schemas: lportal, lportal1, and lportal2. Be careful and use the scripts for your liferay portal version, otherwise, it won't work. In 6.0, if you simply create several empty database schemas manually, when Liferay starts up with sharding enabled, it will automatically populate the schemas.
    1. Note: By default, the configuration files are setup for three schemas called default, one and two, but you can configure it for more. All this configuration is set up in the file portal-impl/src/META-INF/shard-data-source-spring.xml . As you will see, we will include this file in the property spring.configs in the next step. In case we want to modify it we just should write our own file in the Extension Environment and include it in this property instead of the default one.
  3. In your portal-ext.properties, you will need to set the following:
    1. Enable
      META-INF/shard-data-source-spring.xml and bunch of other spring configs (refer to "Additional Settings" section below)
       under
      spring.configs
      .
    2. Configure the jdbc schema settings for
      jdbc.default.*
      ,
      jdbc.one.*
      , and
      jdbc.two.*
      .
    3. Enable the shard names:
      shard.available.names=default,one,two
  4. Don't forget to set the appropriate username and password for each schema.
  5. Startup the server and create several (2-3) portal instances (e.g., abc1.com, abc2.com, abc3.com).
  6. Using your favorite database browser, do a query on each of your schemas for the User_ table, and you will notice that the data is now distributed across different schemas. That's it!

Additional Settings #

Remember that default, one, and two are default values defined in portal-impl/src/META-INF/shard-data-source-spring.xml and portal-ext.properties. If you want to change it, make sure to propagate the changes to the spring XML file as well as portal-ext.properties.

  • If you want to manually select the shard (via the GUI when creating portal instances), you need to enable in your portal-ext.properties file:
    shard.selector=com.liferay.portal.dao.shard.ManualShardSelector
    . Otherwise, the shard for the data will be chosen using a round robin technique.
  • Due to the nature of sharding across multiple data sources, it does not support transaction management by itself. In order to enable proper transaction management, you will need to configure JTA/XA. For example, see JTA-XA on Tomcat.
  • Following spring configs also need to be added to portal-ext.properties in 6.1 version ..
    spring.configs= \META-INF/base-spring.xml,   \META-INF/hibernate-spring.xml,  \META-INFinfrastructure-spring.xml,  \META-INF/management-spring.xml,  \META-INF/util-spring.xml,  \META-INF/jpa-spring.xml,  \META-INF/executor-spring.xml,  \META-INF/audit-spring.xml,  \META-INF/cluster-spring.xml,  \META-INF/editor-spring.xml,  \META-INF/executor-spring.xml,  \META-INF/jcr-spring.xml,  \META-INF/ldap-spring.xml,  \META-INF/messaging-core-spring.xml,  \META-INF/messaging-misc-spring.xml,  \META-INF/mobile-device-spring.xml,  \META-INF/notifications-spring.xml,  \META-INF/poller-spring.xml,  \META-INF/rules-spring.xml,  \META-INF/scheduler-spring.xml,  \META-INF/scripting-spring.xml,  \META-INF/search-spring.xml,  \META-INF/workflow-spring.xml,  \META-INF/counter-spring.xml,  \META-INF/document-library-spring.xml,  \META-INF/mail-spring.xml,  \META-INF/portal-spring.xml,  \META-INF/portlet-container-spring.xml,  \META-INF/shard-data-source-spring.xml,  \META-INF/ext-spring.xml

Please note that for 6.0 version of the Liferay portal the following spring configs should be added to portal-ext.properties instead of the above mentioned ones:

spring.configs=\META-INF/base-spring.xml,
META-INF/hibernate-spring.xml,\META-INF/infrastructure-spring.xml,\META-INF/management-spring.xml,
META-INF/util-spring.xml,
META-INF/editor-spring.xml,\META-INF/jcr-spring.xml,\META-INF/messaging-spring.xml,\META-INF/scheduler-spring.xml,\META-INF/search-spring.xml,
META-INF/counter-spring.xml,\META-INF/document-library-spring.xml,\META-INF/lock-spring.xml,\META-INF/mail-spring.xml,\META-INF/portal-spring.xml,\META-INF/portlet-container-spring.xml,\META-INF/wsrp-spring.xml,
META-INF/mirage-spring.xml,
\META-INF/shard-data-source-spring.xml
0 Allegati
64907 Visualizzazioni
Media (5 Voti)
La media del punteggio è 4.4 stelle su 5.
Commenti
Commenti Autore Data
I´ll try it right now. Will comment soon Aritz Galdos 20 luglio 2009 0.32
Great!! It simply works!! Aritz Galdos 20 luglio 2009 1.22
Very good feature! Jonas Yuan 25 luglio 2009 7.48
Dear Alex, It would be really nice if a new... Ahamed Hasan 2 dicembre 2009 9.53
Is Sharding works fine with 5.2.3 - it is... Faisal K 19 febbraio 2010 8.48
Its great.. definitely will try on 6.0.x ... Ravi Kumar Gupta 17 novembre 2010 3.57
It works fine with Liferay 6.1 Kiran Kanaparthi 17 gennaio 2012 0.24
More neat details at ... Raja Nagendra Kumar 15 giugno 2012 17.38
There is a reference to the Extension... Danny Stevens 30 luglio 2012 17.10
Because users of sharding a probably always... Danny Stevens 30 luglio 2012 17.17
Hi all any one had the same problem with... Suresh Nimmakayala 4 agosto 2013 20.31
Added a section in "Additional Settings"... Abhay Chaware 28 agosto 2013 23.40
I'm working with sharing on Liferay portal 6.2... Nelson Aguayo 1 luglio 2014 13.16
*sharding Nelson Aguayo 1 luglio 2014 13.41
*sharding Nelson Aguayo 1 luglio 2014 13.41
Check folowing link for database sharding ... Mitul Khamar 21 maggio 2015 6.03

I´ll try it right now. Will comment soon
Inviato il 20/07/09 0.32.
Great!! It simply works!!
Inviato il 20/07/09 1.22.
Inviato il 25/07/09 7.48.
Dear Alex,

It would be really nice if a new database schema is created when the adminstrator creates an instance, so that we need not have to do all configuration in properties and xml files and re-start the server.
Inviato il 02/12/09 9.53.
Is Sharding works fine with 5.2.3 - it is mentioned 5.2.3+, I am getting Exception like this
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferayTransactionManager' defined in class path resource [META-INF/hibernate-spring.xml]: Cannot resolve reference to bean 'liferayHibernateSessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferayHibernateSessionFactory' defined in class path resource [META-INF/shard-data-source-spring.xml]: Cannot resolve reference to bean 'shardSessionFactoryTargetSource' while setting bean property 'targetSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'shardSessionFactoryTargetSource' defined in class path resource [META-INF/shard-data-source-spring.xml]: Cannot create inner bean 'com.liferay.portal.spring.hibernate.PortalHibernateConfiguration#88d319' of type [com.liferay.portal.spring.hibernate.PortalHibernateConfiguration] while setting bean property 'sessionFactories' with key [TypedStringValue: value , target type ]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.liferay.portal.spring.hibernate.PortalHibernateConfiguration#88d319' defined in class path resource [META-INF/shard-data-source-spring.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveRef­erence(BeanDefinitionValueResolver.java:275)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveVal­ueIfNecessary(BeanDefinitionValueResolver.java:104)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.app­lyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.pop­ulateBean(AbstractAutowireCapableBeanFactory.java:1010)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doC­reateBean(AbstractAutowireCapableBeanFactory.java:472)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.r­un(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre­ateBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstra­ctBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingle­ton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract­BeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe­anFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe­anFactory.java:164)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveRef­erence(BeanDefinitionValueResolver.java:269)
... 43 more
Inviato il 19/02/10 8.48.
Its great.. definitely will try on 6.0.x

Thanks for sharing.
Inviato il 17/11/10 3.57.
It works fine with Liferay 6.1
Inviato il 17/01/12 0.24.
More neat details at

http://www.liferay.com/documentation/liferay-portal/6.1/user-guide/-/ai/lifera­y-clusteri-2
Inviato il 15/06/12 17.38.
There is a reference to the Extension Environment in this article which is obsolete. I beleive it should now reference the Ext Plugin instead.
Inviato il 30/07/12 17.10 in risposta a Raja Nagendra Kumar.
Because users of sharding a probably always going to want to change shard-data-source-spring.xml a detailed example of best practice for doing this would be very useful here.
Inviato il 30/07/12 17.17 in risposta a Danny Stevens.
Hi all any one had the same problem with shrding, please help what i need to do

i got 6.0eesp2 lportal , database upgraded from prev version, i want to use Database Sharding.
followed steps

jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/lportal?useUnicode=true&characterEncodin­g=UTF-8&useFastDateParsing=false&zeroDateTimeBehavior=convertToNull
jdbc.default.username=xxx
jdbc.default.password=xxxxx

jdbc.one.driverClassName=com.mysql.jdbc.Driver
jdbc.one.url=jdbc:mysql://localhost/lportal1?useUnicode=true&characterEncoding=U­TF-8&useFastDateParsing=false&zeroDateTimeBehavior=convertToNull
jdbc.one.username=xxx
jdbc.one.password=xxxx

jdbc.two.driverClassName=com.mysql.jdbc.Driver
jdbc.two.url=jdbc:mysql://localhost/lportal2?useUnicode=true&characterEncoding=U­TF-8&useFastDateParsing=false&zeroDateTimeBehavior=convertToNull
jdbc.two.username=xxx
jdbc.two.password=xxxxx


shard.selector=com.liferay.portal.dao.shard.ManualShardSelector
shard.available.names=default,one,two
shard.default.name=default



##
## Spring
##

#
# Input a list of comma delimited Spring configurations. These will be
# loaded after the bean definitions specified in the contextConfigLocation
# parameter in web.xml.
#
# Note that there is a special case for hibernate-spring.xml and
# jpa-spring.xml. Even though both files are specified, only one will
# actually load at runtime based on the property "persistence.provider".
#
spring.configs=\
META-INF/base-spring.xml,\
\
META-INF/hibernate-spring.xml,\
META-INF/infrastructure-spring.xml,\
META-INF/management-spring.xml,\
\
META-INF/util-spring.xml,\
\
META-INF/jpa-spring.xml,\
\
META-INF/audit-spring.xml,\
META-INF/cluster-spring.xml,\
META-INF/editor-spring.xml,\
META-INF/executor-spring.xml,\
META-INF/jcr-spring.xml,\
META-INF/ldap-spring.xml,\
META-INF/messaging-core-spring.xml,\
META-INF/messaging-misc-spring.xml,\
META-INF/mobile-device-spring.xml,\
META-INF/notifications-spring.xml,\
META-INF/poller-spring.xml,\
META-INF/rules-spring.xml,\
META-INF/scheduler-spring.xml,\
META-INF/scripting-spring.xml,\
META-INF/search-spring.xml,\
META-INF/workflow-spring.xml,\
\
META-INF/counter-spring.xml,\
META-INF/mail-spring.xml,\
META-INF/portal-spring.xml,\
META-INF/portlet-container-spring.xml,\
META-INF/staging-spring.xml,\
META-INF/virtual-layouts-spring.xml,\
\
#META-INF/dynamic-data-source-spring.xml,\
META-INF/shard-data-source-spring.xml,\
#META-INF/memcached-spring.xml,\
#META-INF/monitoring-spring.xml,\
\
META-INF/ext-spring.xml


created lportal1 and lportal2 with create-minimal-mysql

i have a problem to make up and running
----------------
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.liferay.portlet.messageboards.service.MBThreadLocalService' defined in class path resource [META-INF/portal-spring.xml]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.liferay.portlet.messageboards.service.MBThreadService' defined in class path resource [META-INF/portal-spring.xml]: Initialization of bean failed; nested exception is com.liferay.portal.kernel.bean.BeanLocatorException: BeanFactory could not find bean: org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'com.liferay.documentlibrary.service.DLLocalService' is defined

and PortalBeanLocator failed with: BeanLocator has not been set
... 1024 more
Caused by: com.liferay.portal.kernel.bean.BeanLocatorException: BeanFactory could not find bean: org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'com.liferay.documentlibrary.service.DLLocalService' is defined
at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefi­nition(DefaultListableBeanFactory.java:527)
at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBean­Definition(AbstractBeanFactory.java:1083)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract­BeanFactory.java:274)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe­anFactory.java:190)
at com.liferay.portal.spring.bean.BeanReferenceAnnotationBeanPostProcessor._autoInj­ect(BeanReferenceAnnotationBeanPostProcessor.java:135)
at com.liferay.portal.spring.bean.BeanReferenceAnnotationBeanPostProcessor._autoInj­ect(BeanReferenceAnnotationBeanPostProcessor.java:177)
at com.liferay.portal.spring.bean.BeanReferenceAnnotationBeanPostProcessor.postProc­essBeforeInitialization(BeanReferenceAnnotationBeanPostProcessor.java:75)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.app­lyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java­:394)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.ini­tializeBean(AbstractAutowireCapableBeanFactory.java:1413)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doC­reateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre­ateBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstra­ctBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingle­ton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract­BeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe­anFactory.java:190)
at com.liferay.portal.spring.bean.BeanReferenceAnnotationBeanPostProcessor._autoInj­ect(BeanReferenceAnnotationBeanPostProcessor.java:135)
at com.liferay.portal.spring.bean.BeanReferenceAnnotationBeanPostProcessor._autoInj­ect(BeanReferenceAnnotationBeanPostProcessor.java:177)
at com.liferay.portal.spring.bean.BeanReferenceAnnotationBeanPostProcessor.postProc­essBeforeInitialization(BeanReferenceAnnotationBeanPostProcessor.java:75)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.app­lyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java­:394)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.ini­tializeBean(AbstractAutowireCapableBeanFactory.java:1413)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doC­reateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre­ateBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstra­ctBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingle­ton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract­BeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe­anFactory.java:190)
and PortalBeanLocator failed with: BeanLocator has not been set
... 1024 more
Caused by: com.liferay.portal.kernel.bean.BeanLocatorException: BeanFactory could not find bean: org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'com.liferay.documentlibrary.service.DLLocalService' is defined
at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefi­nition(DefaultListableBeanFactory.java:527)
at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBean­Definition(AbstractBeanFactory.java:1083)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract­BeanFactory.java:274)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe­anFactory.java:190)
at com.liferay.portal.spring.bean.BeanReferenceAnnotationBeanPostProcessor._autoInj­ect(BeanReferenceAnnotationBeanPostProcessor.java:135)
at com.liferay.portal.spring.bean.BeanReferenceAnnotationBeanPostProcessor._autoInj­ect(BeanReferenceAnnotationBeanPostProcessor.java:177)
at com.liferay.portal.spring.bean.BeanReferenceAnnotationBeanPostProcessor.postProc­essBeforeInitialization(BeanReferenceAnnotationBeanPostProcessor.java:75)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.app­lyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java­:394)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.ini­tializeBean(AbstractAutowireCapableBeanFactory.java:1413)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doC­reateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre­ateBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstra­ctBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingle­ton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract­BeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe­anFactory.java:190)
at com.liferay.portal.spring.bean.BeanReferenceAnnotationBeanPostProcessor._autoInj­ect(BeanReferenceAnnotationBeanPostProcessor.java:135)
at com.liferay.portal.spring.bean.BeanReferenceAnnotationBeanPostProcessor._autoInj­ect(BeanReferenceAnnotationBeanPostProcessor.java:177)
at com.liferay.portal.spring.bean.BeanReferenceAnnotationBeanPostProcessor.postProc­essBeforeInitialization(BeanReferenceAnnotationBeanPostProcessor.java:75)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.app­lyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java­:394)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.ini­tializeBean(AbstractAutowireCapableBeanFactory.java:1413)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doC­reateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre­ateBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstra­ctBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingle­ton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract­BeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe­anFactory.java:190)

and PortalBeanLocator failed with: BeanLocator has not been set
... 1024 more
Caused by: com.liferay.portal.kernel.bean.BeanLocatorException: BeanFactory could not find bean: org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'com.liferay.documentlibrary.service.DLLocalService' is defined
at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefi­nition(DefaultListableBeanFactory.java:527)
at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBean­Definition(AbstractBeanFactory.java:1083)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract­BeanFactory.java:274)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe­anFactory.java:190)
at com.liferay.portal.spring.bean.BeanReferenceAnnotationBeanPostProcessor._autoInj­ect(BeanReferenceAnnotationBeanPostProcessor.java:135)
at com.liferay.portal.spring.bean.BeanReferenceAnnotationBeanPostProcessor._autoInj­ect(BeanReferenceAnnotationBeanPostProcessor.java:177)
at com.liferay.portal.spring.bean.BeanReferenceAnnotationBeanPostProcessor.postProc­essBeforeInitialization(BeanReferenceAnnotationBeanPostProcessor.java:75)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.app­lyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java­:394)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.ini­tializeBean(AbstractAutowireCapableBeanFactory.java:1413)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doC­reateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre­ateBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstra­ctBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingle­ton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract­BeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe­anFactory.java:190)
at com.liferay.portal.spring.bean.BeanReferenceAnnotationBeanPostProcessor._autoInj­ect(BeanReferenceAnnotationBeanPostProcessor.java:135)
at com.liferay.portal.spring.bean.BeanReferenceAnnotationBeanPostProcessor._autoInj­ect(BeanReferenceAnnotationBeanPostProcessor.java:177)
at com.liferay.portal.spring.bean.BeanReferenceAnnotationBeanPostProcessor.postProc­essBeforeInitialization(BeanReferenceAnnotationBeanPostProcessor.java:75)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.app­lyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java­:394)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.ini­tializeBean(AbstractAutowireCapableBeanFactory.java:1413)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doC­reateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre­ateBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstra­ctBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingle­ton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract­BeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe­anFactory.java:190)
Inviato il 04/08/13 20.31 in risposta a Danny Stevens.
Added a section in "Additional Settings" listing bunch of spring configs that need to be added to portal-ext.properties for liferay-portal-6.1.1-ce-ga2.
Inviato il 28/08/13 23.40.
I'm working with sharing on Liferay portal 6.2 EE ga1, the best way is copy the spring section from portal.properties, then paste in portal-ext.properties and finally uncomment
#META-INF/shard-data-source-spring.xml

my comment is complementary to the section: Additional Settings
Inviato il 01/07/14 13.16.
Inviato il 01/07/14 13.41 in risposta a Nelson Aguayo.
Inviato il 01/07/14 13.41 in risposta a Nelson Aguayo.
Check folowing link for database sharding

http://mitulkhamar.blogspot.in/2015/05/database-sharding.html
Inviato il 21/05/15 6.03.