Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
my site i down please see http://www.cheri3a.com/ Question Question
How do I get a SSL certificate for my WSGI Flask server so it can send data over HTTPS? Question Question

Question

API Gateway & Database (Postgresql)

Posted October 31, 2020 463 views
NginxPHPPostgreSQL

I have a API gateway that is running on top of NGINX(openresty)+php+phpFPM. Based on the current load, I do believe the basic droplet will suffice.

I also need a database (postgresql) that the API gateway will be connecting to.

My question is:

  1. Will I be able getting static IP for each of the instance?
  2. The traffic between the API gateway and database count towards the ‘Transfer’ limit?
  3. Will I be able to combine the 2 instance’s 'Transfer’? let say both instance comes with 1TB 'Transfer’, since there is only outbound/inbound to the internet on the API gateway, will I only get 1TB of 'Transfer’ or 2TB?
  4. Is there any requirements for 'Managed Database’?
  5. I’m assuming Digital Ocean will be responsible for loading all the required software? If not, what is the procedure?

Thanks

Add a comment
scottychiao
By:
scottychiao

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
my site i down please see http://www.cheri3a.com/ Question Question
How do I get a SSL certificate for my WSGI Flask server so it can send data over HTTPS? Question Question

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer
bobbyiliev November 1, 2020

Hi there @scottychiao,

Here are my thoughts on all of your questions

  1. You get a static IP address with each Droplet and Managed Database cluster
  2. If you are using a VPC, the bandwidth doesn’t count against your monthly usage.
  3. If you are connecting to your database server from your web server via the VPC, you would barely use any bandwidth. For more information on bandwidth, I would recommend checking this bandwidth tool here.
  4. I’m not sure exactly what you have in mind here, but there aren’t any specific requirements, you can spin up a new database cluster directly via your DigitalOcean control panel with just a click of a button. For more information on how to get started, you can take a look at the official documentation here.
  5. If you go for a Managed PostgreSQL Database Cluster, you would not need to worry about the server management, you would get your database connection string details like the hostname, the port, your database username and password. Then you can use those details to connect your application with your database.

Regards,
Bobby

Reply Report
  • scottychiao November 3, 2020

    Bobby,

    Thanks for the info.

    So if I start with a non-managed postgresql database, what are the steps to make it a managed database?

    What if I need to build a custom package/different flavor, let’s say Nginx? and what if the package is not available in the control panel?

    Regards,

    Thanks

    Reply Report

Related

Looking for something else?

Ask a new question Search for more help