Related

App Platform: Run PHP apps without managing servers Product

my site i down please see http://www.cheri3a.com/

How do I get a SSL certificate for my WSGI Flask server so it can send data over HTTPS?

Question

API Gateway & Database (Postgresql)

Posted October 31, 2020 270

Nginx PHP PostgreSQL

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:

Will I be able getting static IP for each of the instance?
The traffic between the API gateway and database count towards the ‘Transfer’ limit?
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?
Is there any requirements for 'Managed Database’?
I’m assuming Digital Ocean will be responsible for loading all the required software? If not, what is the procedure?

Thanks

By:

scottychiao

Related

App Platform: Run PHP apps without managing servers Product

my site i down please see http://www.cheri3a.com/

How do I get a SSL certificate for my WSGI Flask server so it can send data over HTTPS?

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.

×

1 answer

bobbyiliev November 1, 2020

Hi there @scottychiao,

Here are my thoughts on all of your questions

You get a static IP address with each Droplet and Managed Database cluster
If you are using a VPC, the bandwidth doesn’t count against your monthly usage.
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.
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.
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
- bobbyiliev November 4, 2020
  
  Hey there @scottychiao,
  
  For more information on how managed databases work, I strongly recommend going through this tutorial:
  
  https://www.digitalocean.com/community/tutorials/understanding-managed-databases
  
  If you spin up a Droplet, you can install any packages like Nginx and etc. that you need as you will have root access to the server.
  
  Regards,
  Bobby
  
  Understanding Managed Databases
  by Mark Drake
  Managed databases were developed to reduce the pain points commonly associated with database administration. This conceptual article outlines what managed databases are, how they can be beneficial to development teams, and some practical considerations one should make before building an application on top of one.
  
  Reply Report

Submit an Answer

Looking for something else?

Ask a new question Search for more help