Planning on using a graphic card to transcode 4k 2 or 3 videos per time. Just want something out of the box that doesn’t have to be configured.
This is contradictory. If you want to use a graphics card for transcoding, you must first configure it. As a starting point, you may want to review the documentation:
https://jellyfin.org/docs/general/administration/hardware-acceleration/
It’s really hard to tell, and the devil is in the details.
On bare metal, a single server containing both the front-end application and the DB may be faster (no networking overhead), but only to a point. As load increases, a split system (front-end on one machine, DB on another, or even on a cluster) becomes more attractive.
When everything is virtualized and machines talk to each other over virtual interfaces, I would think a single database server usable by multiple front-end applications would be a good idea. This way, you have only one DB server overhead. Also, maintenance is more straightforward; you look after a single database server, even though it contains multiple databases.
It’s probably a good idea to pair each application with a dedicated database (within the same database server) and assign each application a unique user name with rights only for that database.