Just wondered if anyone can help me clarify a few things, I’ve been go round in circles for months and still cannot understand.
I’m trying to get my setup so that I can create a local project in wappler then deploy it to a remote AWS server. 've got a trial account on AWS with an EC2 instance running. I created the docker remote in wappler and can deploy however the issue is databases, and this is where I’m confused.
I thought that when you created a local Database instance i.e. MySQL on the local setup, a deployment to AWS via docker would create everything required to run or ‘deploy’ the project locally.
I’ve had no end of error messages, and at one stage managed to deploy, all best with no data.
Is it really this difficult to setup? I’m convinced that my misunderstanding is the issue and I’d really like help clearing it up as I cannot move forward and its frustrating.
Do I need to create a remote DB somewhere i.e. RDS in AWS, and use that as the shared DB between the local and remote, so that when deployed the remote has access to the database?
I’ve even tried setting up an RDS instance, but I’m not given any obvious details to enter into wappler setup, no I’m really confused.
You can choose to deploy the database with docker on the same server, useful for small projects. Easy to use.
If you need more control and reliability as well automatic backups then you can consider managed database on digital ocean or AWS.
In any case you you have a local development database and a final live database. On each deployment you are uploading your new files to your live server and updating the database scheme, if needed with the database manager.
Data in the database is never synchronized between development and live database. This is always kept separate.
