Common Errors with Database Sharding in DXP 7.0

This article documents the issues with setting up a sharded database and lists steps to resolve the issue or avoid it altogether.

Resolution

Error: Users are unable to create content specifically on a sharded database in Liferay DXP 7.0.

Summary: Database Sharding settings in the portal-ext.properties are not applied in Liferay DXP 7.0. Database sharding allows users to “cut” their databases for scalability and better management of their content. Users can configure their content to be stored in the corresponding segment.

Common Causes

1. Database sharding has been deprecated in DXP. The property #META-INF/shard-data-source-spring.xml,\ has been removed.

Recommended Solution

1. If the user is adopting Liferay DXP 7.0 for the first time with no prior upgrades but desires to shard their databases, they will be unable to do so for the above stated cause. Consider other options for scalable database management.
2. If the user is upgrading from a legacy version, the settings in the portal-ext.properties will not be applied and may cause errors.

Prevention Tips

1. Before upgrading to Liferay DXP 7.0, consider backing up all data. Once the system has completed the upgrade process, verify that no data has been lost.