Hello Avik,
Regarding your first issue that service is going down every few hours and you have to restart the instance to get it working, this might happen if the instance resources are not enough and cannot respond to load accordingly. Did you try to upgrade the Machine type of the instance to a higher Tier to see if this resolves the issue?
About the second issue that your instance does not restart anymore, can you please email your project ID and instance name through the private message. I'll be glad to investigate this issue as soon as I receive this information from you.
Sincerely,