I have set up a WordPress application on Elastic Beanstalk with S3 for media storage and a separate RDS instance for the site. I followed the guide found here to create this application.
I'm under the impression that my application is stateless in the sense that the application is separated from the database (in RDS) and media files (in S3) and can be easily scaled up and down with beanstalk. I'm having difficulty understanding how to update my application with a test/prod environment now.
My question is in updating the code of my application. Because the data could be updated still on the prod environment (like pages, posts, etc), will my theme/application changes have any difficulty merging in?
I understand that the data changes will be made in RDS and will be available when I point my test environment to that database. My concern is more of: if my updates make changes to the test database, how do I merge those changes into the prod environment?
One tool I saw that looked similar to what I want to do is found here. It gives the ability to copy over specific tables in the database and not others. Letting me copy just the changes that were made. I'm not sure how a tool like this would be used in my setup (perhaps there's a better setup that could be recommended?).