Uploaded image for project: 'PUBLIC - Liferay Documentation'
  1. PUBLIC - Liferay Documentation
  2. LRDOCS-681

Properties Missing From Read-write database configuration

    Details

      Description

      Hi,

      A customer indicated that after setting up the read-write they experienced exceptions. During the investigation and discussions we found that in addition to the settings in the official documentation further properties also needs to be applied:
      The correct configuration is to set the 'jdbc.default' properties as well as 'jdbc.read' and 'jdbc.write' properties and it should be pointing to the same database as defined in the 'jdbc.write' properties.

      The reason for this is that in case the portal.properties settings are used for configuring the database connections, a separated connection pool is used for the Counter table which doesn't use the read/write configuration but the default one. This is because of performance reasons.

      Another configuration option is to add the following entry to the portal-ext.properties file:
      counter.jdbc.prefix=jdbc.write.

      Please find further information on the following links:
      http://issues.liferay.com/browse/LPS-12802?focusedCommentId=240292&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-240292
      https://in.liferay.com/web/global-services/wiki/-/wiki/Main/dynamic-read-write#section-dynamic-read-write-In+portal-ext.properties

      Could this be included in the documentation about how the read-write database configuration can be set up?

      Thanks for your help!

        Attachments

          Activity

            People

            Assignee:
            richard.sezov Rich Sezov
            Reporter:
            laszlo.hudak Laszlo Hudak (Inactive)
            Participants of an Issue:
            Votes:
            1 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved:

                Packages

                Version Package
                6.2.x
                7.0.x