This article documents the issues with setting up a sharded database and lists steps to resolve the issue or avoid it altogether.
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.
- Database sharding has been deprecated in DXP. The property
#META-INF/shard-data-source-spring.xml,\ has been removed.
- 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.
- If the user is upgrading from a legacy version, the settings in the
portal-ext.propertieswill not be applied and may cause errors.
- 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.