You're viewing help content for version:

About DSRP

When AEM Communities is configured to use a relational database as its common store, user generated content (UGC) is accessible from all author and publish instances without the need for synchronization nor replication.

See also Characteristics of SRP Options and Recommended Topologies.


Relational Database Configuration

MySQL Configuration

A MySQL installation may be shared between enablement features and common store (DSRP) within the same connections pool by using different database (schema) names and also different connections (server:port).

For installation and configuration details, see MySQL Configuration for DSRP.

Solr Configuration

A Solr installation may be shared between the node store (Oak) and common store (SRP) by using different collections.

If both the Oak and SRP collections are used intensively, a second Solr may be installed for performance reasons.

For production environments, SolrCloud mode provides improved performance over standalone mode (a single, local Solr setup).

For installation and configuration details, see Solr Configuration for SRP.

Select DSRP

The Storage Configuration console allows for the selection of the default storage configuration, which identifies which implementation of SRP to use.

On author, to access the Storage Configuration console

  • select Database Storage Resource Provider (DSRP)
  • Database Configuration
    • JDBC datasource name
      name given to MySQL connection
      must be the same as entered in JDBC OSGi configuration
      default : communities
    • Database name
      name given to schema in init_schema.sql script
      default : communities
  • SolrConfiguration
    • Zookeeper Host
      Leave this value blank if running Solr using the internal ZooKeeper. Else, when running in SolrCloud mode with an external ZooKeeper, set this value to the URI for the ZooKeeper, such as
      default :  <blank>
    • Solr URL
      default :
    • Solr Collection
      default : collection1
  • select Submit

Publishing the Configuration

DSRP must be identified as the common store on all author and publish instances.

To make the identical configuration available in the publish environment :

  • on author :
    • navigate from main menu to Tools > Operations > Replication
    • select Activate Tree
    • Start Path :
      • browse to /etc/socialconfig/srpc/
    • select Activate

Managing User Data

For information regarding users, user profiles and user groups, often entered in the publish environment, visit