I need a backend for a mobile app. PHP+MySql. The tasks are quite simple, I don’t expect more than around 10 queries per user session.
My idea is Ubuntu but I have no much experience with it and I will be using it sporadically, probably I will need the expertise when there’s something urgent to fix. To leverage this I am thinking on some Control Panel, so far I am seeing VestaCP, Ajenti and Server Pilot (or at least they look like CPs to me at first glance :-) I don’t need the web server that seems to be the core of most of the CPs.
Do you have any suggestion about this (even the OS, it may be any the simpler as far as it supports PHP+mySql). Oh, and secure!
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!
Accepted Answer
If you’re going to be running PHP, then you’ll need a web server to handle the requests unless you plan on using PHP’s Built-In web server (not advised as it’s not meant for production).
VestaCP will setup NGINX, PHP-FPM, and MySQL/MariaDB for you during it’s setup, so if you go with it, there’s very little configuration needed unless you need very specific configuration for your server blocks (which would require you to edit the server blocks by hand).
For VestaCP, I’d advise running Ubuntu 16.04 64bit.
Alternatively, you can manually setup everything by hand by either using the package manager or by compiling from source. This gives you more control, though it does take a little more time to do (even more so if you compile from source).
When it comes to security, that’s something you’d have to figure out in terms of what you need. Most CP’s will install a Firewall but that’s about it. You’d need to setup SSH Keys, a Sudo user, etc on your own as most automated solutions won’t factor in much security as it’s impossible to know what each person will use the software for. Security is really purpose and application dependent and you’d need to figure out what you need the most and lock down the rest.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.