In my case, I don't use docker.
I have a few $6 droplets on digital ocean, all with sftp, regular like a standar server.
Node/Nginx/Mysql, others with PHP/Apache/Mysql..
I don’t use resource manager either..
Very confortable but the truth is that is another learning curve if you come from shared hosting, things about firewalls, ssh, user permissions, remember those first days, felt like new whole world for me..
Now it feels like I can do whatever I want with that, also using ZeroSSL so those IP's goes with https...
100% recommend to start learning about it
So Keith, you are telling me I can host two domains, three subdomains (one of which is node) and a shared database for each without using docker for $6/month? All projects are very low traffic.
I'm not sure Wappler supports virtualhosts, so if you're asking whether you can host all the projects on the same app server. I don't know if that's supported, but it is possible. That's typically where cPanel or Virtualmin/Cloudmin are helpful.
As for hosting all of those projects from one database server. Whether you use the managed database option from a cloud provider -- which makes life much easier because you don't have to worry about applying patches or ensuring the db is running -- or create a droplet and then install MySQL or Postgres on it. All of those projects could use the same database server.
Here's an example where I have my development and production databases running in the same DO-managed database.
Your connection string is what tells the RDBMS what DB to connect to. In the example below the connection string is connecting to the brightyard_dev database
I'm using CloudPanel software on a VPS. Before I've tested Wappler Docker and it's not something I'd personally use (it's fun, but when you want to customize something it quickly turns into a nightmare, and Traefik is overcomplicated)
In response to some of the queries regarding multiple database schemas and multiple website projects on a single DO / Vultr / Linode VPS instance, can it be done?
A short answer is, Yes.
I have 2 instances, $6/month each - one is hosting multiple MySQL database schemas, and another is hosting multiple web projects. These have been setup through Wappler's Resources Manager interface and Docker deployments.
I'm primarily using these two instances for staging databases and web projects. However, in case of low traffic websites, the projects can be hosted on a single instance even in a production environment.
The databases and websites have been setup with Docker. This is the only method I know that Resources Manager uses to deploy and manage. For multiple websites, Traefik handles the SSL certificates and internal routing to the correct domain names.
That is for a cluster @brad. You can add multiple databases to it. All are encrypted at rest and backed up for you (and include SSL connectivity)... Well worth the money and we can not rate their services highly enough! We switched all of our Clients over to them we were so happy with the service (and believe me they had no idea of how many Clients we had so didn't treat us in any special way). Regardless of your scale their support is superb.
So apparently, I already have a DO account. Must have tried it and gave up. I must say the UI and documentation is horrible. Unless you have a computer science degree, it's totally unusable.
I tried finding some basic documentation on even getting started and came up with nothing.
DO, Vultr, Linode - all offer good UI to deploy and manage remote instances.
If you already have a DO account, then give it another try with Wappler's Resources Manager. If you need any assistance, then I'm happy to provide steps / information on how to do it.
Yes, multiple projects can be hosted on the same droplet. Remember to create (if not already done) and upload the SSH public key (available in the user home SSH directory) to the DO instances for all the projects to have access to the same DO instance. There's no need to use a managed database server.
I recommend setting up a separate instance to host the database. You can then also use this instance to host database schemas for other projects. In my case, one instance has 5-6 database schemas for different projects.
I highly recommend using Resources Manager and Docker deployments for both database and web server. Wappler's RM acts as a central repository of all your remote servers and deployments. Wappler team has greatly improved and streamlined the setup of remote target, cloud database servers and docker deployments via RM.
All my projects are using NodeJS. I'm not familiar with Docker deployments for PHP projects.
I got a DO droplet up and working with no issues yesterday. The integration with Wappler makes it all so easy. I lost my free SSL certificate moving off of Orangehost, but I followed @George's excellent tutorial on using Traefik for this and it's working great. Using Custom Domains and SSL with Let's Encrypt and Traefik
With Orangehost, I had to keep changing mysql2 to mysql in the db connection file and my mailers wouldn't work on Orangehost when they would work fine on localhost. Now with DO, I just upload everything and it all works without having to "hack" files.
I guess the big question which @brad seems to be asking is:
Can he host multiple sites on a single droplet WITHOUT using docker but via their dashboard and upload by traditional ftp?
Their node_modules setup and mapping is fundementally wrong but they wont accept that.
I have told them what is wrong and how to fix it but they just blame Wappler. Irony is this is part of the pre Wappler installation process, wappler is not even installed at that stage.
Yes they would just wash their hands of anything to do with supporting node. They are not a good company for developers like us, they are catering to Wordpress "developers" who don't dig deep like us. And yes, the fact that I had to copy the package.json file to another location other than the root showed their config is messed up. I hope you at least made a few pence off me using your affiliate link haha.
