FTP on droplet with private IP and some other stuffs
I have a issue that I'm trying to solve. I already looked on the tutoriais and I didn't find a 100% answer for my issue.
So I have this droplet above, it's a small configuration but now I'm worried about my traffic and usage of my resources.
I make a lot of calls to an API and the data that is returned from this API is huge so it is consuming too much resources from my server and by consequence the applications gets slows. I setted a CRON job to make this API call every 90 minutes.
I came up with this possible solution but I may need you help. I'm thinking to create a new droplet with more resources just for mySQL and some PHP code that will make this calls to API. So on this new droplet I'll set the CRON to run every 90 minutes this PHP script that will make the calls and process the data. With this I'll isolate the processing and my application that will be on a separated droplet will not get slow.
The server that will have the mySQL and the PHP script I'll use a private IP.
And this is my question: I know with Private IP I can communicate my APP server with my DB server but on my DB server with the Private IP can I use FTP to upload my PHP script? Can I make a remote connection to mySQL from DB IDE? Can I run the PHP script to make the API calls as well?