Hello,I am new to server management and deployment stuff..
My question is whether I should deploy a different droplet for database or should I install the database software in the same droplet where cam running my application backend..
Thank You
Welcome to the wonderful (sometimes head banging) world of doing cool server stuff!
There's unfortunately no easy answer to your question other than "it depends".
The old Unix philosophy is "do one thing and do it well". This certainly can be applied to servers and infrastructure (e.g. a server dedicated to your database).
You can totally get by with everything on a single server but depending on your requirements and expected usage/growth you might want to roll out a distributed solution.
One of the things that I suffered with when I was new to servers was over engineering and premature optimization. Embrace that "done is better than perfect" and go from there!
Using something like block storage for your database data will easily let you move it to another server in the future.
Ohh That was really helpful thanks a lot for ur answer I shall move as u said :-)