Content Comparison

Initial Setup:

1. TODO Add instructions for installing aws-cli

2. TODO How to get AWS Secret Key

3. Configure your AWS profile:

aws configure --profile sunwave-dev

4. Log into

...

4. AWS docker registry

...

4. :

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

5. 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

6. Verify the

...

6. MySQL database container is up and running: docker logs sunwave-mysql-8.0.16

Update to newest version:

1. Stop the existing container:

docker stop sunwave-mysql-8.0.16

2. Remove the container:

docker rm sunwave-mysql-8.0.16

3. Remove the docker image:

docker rmi 517729021141.dkr.ecr.us-east-1.amazonaws.com/sunwave-mysql-8:

...

8.0.

...

16

4. 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

5. 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

6. Make sure it’s running: docker logs sunwave-mysql-8.0.16 Note the initial setup up will take a few minutes:

   Image ModifiedImage Modified

Update the data.

1. 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

2. This example is for

...

2. AWS docker image. The key to use ”--skip-extended-insert”

3. Pull out the table you need to update: cat sunwave3-insert-statements.sql | grep sw_timeline_task > insert_sw_timeline_task.sql

4. Modify the sql file by copy the existing insert statement and modifying to suit your needs.

5. Run locally: docker exec -i sunwave-mysql sh -c "exec mysql --force -uroot -pWelcome1 sunwave3" < insert_sw_timeline_task.sql The --force ignores any duplication errors while telling which statements are duplicates.

6. Remove duplicates.

7. Update https://github.com/sunwavehealth/devops/blob/develop/database/docker/

...

2. 4_data.sql file with your new statements.

3. Reinstall the docker image see https://sunwavehealth.atlassian.net/wiki/spaces/~63696606d60bd2b365f87223/pages/61865999/wack-o-mole+database+usage#Update-to-newest-version%3A

4. Rerun your integration test.

Update the database structure.

...