CODEWITHSUNDEEP
mysqldatabasedatabase-design
Amarjit Singh
Amarjit Singh

Reputation: 2154

Should I use multiple databases for single project

I am working on a site which provides coupons for online shopping sites. It provides discount coupons for shopping sites in India. But now the client wants to provide coupons for USA stores also. But offers available for Indian users are not useful for the USA users and vice versa.

Therefore there will be two versions of the site. One is for the Indian users and other is for the USA users.

But if a user from India searches for an offer which is not available in India but is available in the USA. Then it should appear in search results.

Now I am thinking of creating a new database for the USA users with exact same schema as that of the database for current users(Indian users).

But I would like to get advice from an expert.

Upvotes: 2

Views: 1182

Answers (2)

Aman
Aman

Reputation: 370

Creating a separate database or a separate table (by adding _usa to table name) for that matter does not make sense.. because the same can be achieved by creating a mapping table which maps offers/coupons to the country/countries for which it is valid and is more scalable as well.

Here is what I suggest:

countries: id, name

coupons: id, name, discount

coupon_country_mapping: id, country_id, coupon_id, is_active

Upvotes: 1

Taha Tariq
Taha Tariq

Reputation: 218

In the long run you might want to add more countries so I would do it by adding a country table kind of thing and something like offer_valid for offerid country id which would make a single offer valid for one country or more. Creating multiple databases would make the maintenance hectic.

Upvotes: 5

Related Questions