Database setup question
Question, I'm setting up a database and i never vetted this thought, so i want a second opinion.
Is it typically better to have service based databases, or application based databases.
IE for example we'll take an mc server, you'd have the service, mc. So everything would go into one big "minecraft" database, which has things like bans, economy information, permissions etc all in different tables.
OR should they all go into their own individual database, so there'd be 1 hardware machine running multiple dbs, say 1 for the admin logs, 1 for the permission managers, 1 for the account status/bans, 1 for economy information etc.
I've always done service based, but i want to know if its best practice or not.
Is it typically better to have service based databases, or application based databases.
IE for example we'll take an mc server, you'd have the service, mc. So everything would go into one big "minecraft" database, which has things like bans, economy information, permissions etc all in different tables.
OR should they all go into their own individual database, so there'd be 1 hardware machine running multiple dbs, say 1 for the admin logs, 1 for the permission managers, 1 for the account status/bans, 1 for economy information etc.
I've always done service based, but i want to know if its best practice or not.
