Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Should I have my site's ASP.NET Identity database separate from my site's "other data" database?

I'm creating a website that uses ASP.NET's Identity framework for the authentication/etc. Should I keep the Identity database separate, and create another database that contains my websites's other information?
I ask because that's all I've experienced (seen in my job) so far, and I want to make sure that it is "best" practice.
My assumption is that there's no need to keep them in separate databases. Is that correct?

Thanks for any help.

like image 883
Marcus Avatar asked Dec 29 '25 12:12

Marcus


1 Answers

Not necessary. For simple website, no, there are no advantages to separate both.

But this is a trick question! Do you intend to have more than 1.000.000 user online in the same time?

If yes, you’ll probably would like to have some geo-replication and have separate databases for clients. In this case, have a big fat database only for authentication makes all sense

like image 168
Jurion Avatar answered Jan 01 '26 03:01

Jurion



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!