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?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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.
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Click below to sign up and get $100 of credit to try our products over 60 days!