Relative Content

Tag Archive for sharding

How can I distribute a unique database already in production?

Let’s assume a successful web Spring application running on a MySQL or PostgreSQL database. The traffic is becoming so high and the amount of data is becoming so big that a distributed database solution needs to be implemented to address scalability issue. Let’s also assume this application is using Hibernate and the data access layer is cleanly separated with DAOs.

A multi tenant data architecture

We are at a planning & redesign stage of our loyalty card application. As it is understood it will be a multi-tenant application. And I need to take your thoughts. Here are the some key points we should take in to account to redesign logical and physical data structure: