Liferay 7 db sharding!

[PANAGIOTIS NIKOLAKEAS, geändert vor 6 Jahren.]

Unfortunately, Liferay 7 does not offer database sharding!

How am I supposed to address potential issues related with the single database approach?

Please advice. Please give insights.

Thanks in advance

[Samuel Kong, geändert vor 6 Jahren.]

Move your database to a better/faster server? What is your concern?

[Jorge Díaz, geändert vor 6 Jahren.]

Hi Panagiotis,

About logical data partitioning, in both Liferay 6.2 and Liferay 7.0, you can create different Liferay Instances in order to logically distribute data in different isolate instances (also known as 'Companies', with a companyId) inside a same database

About physical data partitioning:
- In Liferay 6.2 there was a out of the box functionality that allowed to store each instance in a different database (sharding at application level) that sharding was very limited, for example, you wasn't able to configure advanced sharding algorithms.
In the other hand you wasn't able to configure data sharding at database level because 'companyId' column didn't exist in every table.

- In Liferay 7.0 the 'companyId' column has been added to every Liferay table, so now it is possible to configure data sharding at database level, configuring 'companyId' as partition_key. In the other side, out of the box sharding functionality was removed, but you can continue configuring it at database level.

More info about database sharding:

• https://medium.com/@jeeyoungk/how-sharding-works-b4dec46b3f6
• https://severalnines.com/blog/database-sharding-how-does-it-work
• https://en.wikipedia.org/wiki/Shard_(database_architecture)
• Postgresql: http://www.craigkerstiens.com/2016/02/28/Hands-on-postgres-sharding/
• Mysql: https://dev.mysql.com/doc/mysql-utilities/1.5/en/fabric-quick-start-sharding-scenario.html