...
TODO Add instructions for installing aws-cli
TODO How to get AWS Secret Key
Configure your AWS profile:
aws configure --profile sunwave-dev
Log into
...
AWS docker registry
...
:
aws ecr get-login-password
--region us-east-1
--profile sunwave-dev
| docker login --username AWS --password-stdin 517729021141.dkr.ecr.us-east-1.amazonaws.com
Pull and run the wack-o-mole image:
docker run
--platform linux/amd64 -p 3306:3306
--name sunwave-mysql-8.0.16
--network sunwave -e MYSQL_ROOT_PASSWORD=Welcome1
-d 517729021141.dkr.ecr.us-east-1.amazonaws.com/sunwave-mysql-8:
...
8.0.
...
16
-
...
-
...
lower_case_table_names=1
Verify the
...
MySQL database container is up and running:
docker logs sunwave-mysql-8.0.16
Update to newest version:
Stop the existing container:
docker stop sunwave-mysql-8.0.16
Remove the container:
docker rm sunwave-mysql-8.0.16
Remove the docker image:
docker rmi 517729021141.dkr.ecr.us-east-1.amazonaws.com/sunwave-mysql-8:
...
8.0.
...
16
Login into our aws docker registry:
aws ecr get-login-password
--region us-east-1
--profile sunwave-dev | docker login --username AWS --password-stdin 517729021141.dkr.ecr.us-east-1.amazonaws.com
Pull the new image, create the container
,and run it:
docker run
--platform linux/amd64 -p 3306:3306
--name sunwave-mysql-8.0.16
--network sunwave
-e MYSQL_ROOT_PASSWORD=Welcome1
-d 517729021141.dkr.ecr.us-east-1.amazonaws.com/sunwave-mysql-8:
...
8.0.
...
16
-
...
-
...
lower_case_table_names=1
Make sure it’s running:
docker logs sunwave-mysql-8.0.16Note the initial setup up will take a few minutes:
Update the data.
Get a dump of insert statements of your existing database:
docker exec -i sunwave-mysql-8.0.16 sh -c "mysqldump -u root -p'Welcome1' --skip-extended-insert sunwave3" > sunwave3-insert-statements.sql
This example is for
...
AWS docker image. The key to use ”--skip-extended-insert”
Pull out the table you need to update:
cat sunwave3-insert-statements.sql | grep sw_timeline_task > insert_sw_timeline_task.sqlModify the sql file by copy the existing insert statement and modifying to suit your needs.
Run locally:
docker exec -i sunwave-mysql sh -c "exec mysql --force -uroot -pWelcome1 sunwave3" < insert_sw_timeline_task.sqlThe--forceignores any duplication errors while telling which statements are duplicates.Remove duplicates.
Update https://github.com/sunwavehealth/devops/blob/develop/database/docker/4_data.sql file with your new statements.
Reinstall the docker image see https://sunwavehealth.atlassian.net/wiki/spaces/~63696606d60bd2b365f87223/pages/61865999/wack-o-mole+database+usage#Update-to-newest-version%3A
Rerun your integration test.
Update the database structure.
...