So we are close to wanting to start creating our production environment.
We’ll be using a Docker Machine on AWS - I want to create the project correctly the first time so looking for some advice as I’ve had constant challenges with setting up DB’s if they are external to the docker DB, and utilizing the DB Manager in Wappler (which I want to use, and be able to merge changes).
Go to targets - name the new target as Production
Create new docker machine in the AWS region of choice - choose server etc. and create.
Once created go back to targets and select it.
Choose NodeJS etc.
I then create a new RDS MySql DB in AWS.
for Database - should I put this as ‘none’ ?
And then in DB Manager - would I create a new DB with the new AWS RDS DB details? Or, would I just change the connection parameters of the pre-existing DB that will display in the DB manager that is there from the other targets to the new dB settings?
I assume I can’t deploy DB changes to the external DB so instead I would copy the schema from the staging DB and add to the new DB via SQL Workbench?