Databases Reference
In-Depth Information
We have configured Media Library to use
AdvancedFileSystemStore
, and also
provided a networked location where the Portal should store the Media Library
content. Both the Portal nodes will store content in the same filesystem location.
To use this option, we need to make sure the SAN appliance supports file locking,
as multiple nodes will access the filesystem at the same time. As this option requires
specialized hardware like SAN or NFS, it will add additional cost to the solution.
Database storage using the JCR store
Liferay Portal provides an option to store the Media Library content to the database
using the JCR store. Liferay Portal uses Apache Jackrabbit as JCR implementation.
Jackrabbit provides both filesystem- and database-based storage for the content. By
default, the Jackrabbit configuration uses filesystem-based storage. Another option is
to configure Jackrabbit to use the database for the Media Library content. Let's learn
how to configure Media Library using the JCR store.
1.
Stop both the Liferay Portal nodes if they are already running.
2.
Edit
portal-ext.properties
of both the nodes and add the
following configuration:
dl.store.impl=com.liferay.portlet.documentlibrary.store.JCRStore
3.
Now edit
node-01\liferay-portal-6.1.1-ce-ga2\data\jackrabbit\
repository.xml
and make the following changes:
1.
Comment the following lines from the file:
<FileSystem class="org.apache.jackrabbit.core.fs.local.
LocalFileSystem">
<param name="path" value="${rep.home}/repository" />
</FileSystem>
2.
Uncomment the following lines and change the values as given in
the following code snippet. Make sure you provide the correct IP,
username, and password of the MySQL database:
<FileSystem class="org.apache.jackrabbit.core.fs.db.
DbFileSystem">
<param name="driver" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://
{IP of MySQL Database
Server}
/lportal"/>
<param name="schema" value="mysql"/>
<param name="user" value="
{Database User Id}
"/>
<param name="password" value="
{Database Password}
"/>
<param name="schemaObjectPrefix" value="J_R_FS_"/>
</FileSystem>
