Sharding is a type of database partitioning that separates very large databases the into smaller, faster, more easily managed parts called datashards. The word shard means a small part of a whole
Steps for liferay sharding :
1) Initially add JNDI entries in portal-ext.properties and root.xml file as follows
root.xml:
<Resource
name="jdbc/LiferayPool"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.
url="jdbc:mysql://localhost/
username="root"
password="root"
maxActive="150"
maxIdle="30"
maxWait="10000"
/>
Start the liferay server .
2) Add the site , users , pages ,webcontent , documents form admin console .
3) Now stop the sever .
4) Enable instance specific properties
we need to add -Dcompany-id-properties=true in your java arguments . set them to JAVA_OPS in bin/setevn.bat.
Add the below property in portal-ext.properties file
include-and-override=portal-<
5) Add JNDI entries for shard in portal-ext.properties and root.xml
Portal-ext.properties: jdbc.one.jndi.name=jdbc/
Root.xml :
<Resource
name="jdbc/LiferayPoolSherd"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.
url="jdbc:mysql://localhost/
username="root"
password="root"
maxActive="150"
maxIdle="30"
maxWait="10000"
/>
6) Add spring specific properties for supporting shard.
spring.configs=\
META-INF/base-spring.xml,\
\
META-INF/hibernate-spring.xml,
META-INF/infrastructure-
META-INF/management-spring.
\
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/jcr-spring.xml,\
META-INF/ldap-spring.xml,\
META-INF/messaging-core-
META-INF/messaging-misc-
META-INF/mobile-device-spring.
META-INF/notifications-spring.
META-INF/poller-spring.xml,\
META-INF/rules-spring.xml,\
META-INF/scheduler-spring.xml,
META-INF/search-spring.xml,\
META-INF/workflow-spring.xml,\
\
META-INF/counter-spring.xml,\
META-INF/document-library-
META-INF/mail-spring.xml,\
META-INF/portal-spring.xml,\
META-INF/portlet-container-
META-INF/staging-spring.xml,\
META-INF/virtual-layouts-
\
META-INF/monitoring-spring.
\
#META-INF/dynamic-data-source-
META-INF/shard-data-source-
#META-INF/memcached-spring.
\
classpath*:META-INF/ext-
7) Create the file by name portal-<web-id>.properties and place in the same folder as of portal-ext.properties .
8) By using this sharding works properly, but there is some issues
Like for some portlet like custom or calender the table is not created on both instance DB.
So, for this we need to add following property at once:
Like for some portlet like custom or calender the table is not created on both instance DB.
So, for this we need to add following property at once:
Add the below entries in portal-<web-id>.properties
verify.frequency=-1
verify.processes=com.liferay.
9) Finally root.xml should look as below .
<Context path="" crossContext="true">
<Resource
name="jdbc/LiferayPool"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.
url="jdbc:mysql://localhost/
username="root"
password="root"
maxActive="150"
maxIdle="30"
maxWait="10000"
/>
<Resource
name="jdbc/LiferayPoolSherd"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.
url="jdbc:mysql://localhost/
username="root"
password="root"
maxActive="150"
maxIdle="30"
maxWait="10000"
/>
</Context>
And portal-ext.properties file should look like below
jdbc.default.jndi.name=jdbc/
jdbc.one.jndi.name=jdbc/
shard.selector=com.liferay.
include-and-override=portal-
#
# 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-
META-INF/management-spring.
\
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/jcr-spring.xml,\
META-INF/ldap-spring.xml,\
META-INF/messaging-core-
META-INF/messaging-misc-
META-INF/mobile-device-spring.
META-INF/notifications-spring.
META-INF/poller-spring.xml,\
META-INF/rules-spring.xml,\
META-INF/scheduler-spring.
META-INF/search-spring.xml,\
META-INF/workflow-spring.xml,\
\
META-INF/counter-spring.xml,\
META-INF/document-library-
META-INF/mail-spring.xml,\
META-INF/portal-spring.xml,\
META-INF/portlet-container-
META-INF/staging-spring.xml,\
META-INF/virtual-layouts-
\
META-INF/monitoring-spring.
\
#META-INF/dynamic-data-source-
META-INF/shard-data-source-
#META-INF/memcached-spring.
\
classpath*:META-INF/ext-
Start the server.
Login with as admin .
Go to control-panel , then go to server administration .
Execute the button with lable
“Verify database tables of all plugins. “
Create the new instance with name domain2.com.
Now go to url
Domain2.com:8080/
Use the default user email id test@domain2.com and test is the password
No comments:
Post a Comment