autonomic-cooperative/nextload
0
0
Fork 0
Code Issues 11 Pull Requests Packages Projects Releases Wiki Activity

Find a way of syncing prod/dev db's #4

New Issue
Open
opened 2024-06-19 16:56:10 +00:00 by tma · 2 comments
tma commented 2024-06-19 16:56:10 +00:00
Owner
Copy Link
No description provided.
tma added the
infrastructure
 label 2024-06-19 16:56:10 +00:00
3wordchant commented 2024-07-11 19:26:24 +00:00
Owner
Copy Link

It's possible to make a dump of the remote DB with something like:

(export DOCKER_CONTEXT=swarm-demo.autonomic.zone; docker exec -it $(docker ps -q -f name=nextload-demo_autonomic_zone_mongo) bash)
cd /tmp
mongodump -u mongo -p $(cat /run/secrets/mongo_password)

How we've handled syncing for Wordpress is to have a makefile target which fetches this from the running server, then loads it into the local database instance. If that seems like a reasonable approach, we could reproduce that with mongo; questions include:

  1. How to make this a 1-liner, given that the password lookup likely should happen remotely in the container
  2. How to load a dump into a running Mongo instance, ideally dropping existing content first
  3. Whether there are any changes which need to be made to the data during or after loading
It's possible to make a dump of the remote DB with something like: ``` (export DOCKER_CONTEXT=swarm-demo.autonomic.zone; docker exec -it $(docker ps -q -f name=nextload-demo_autonomic_zone_mongo) bash) cd /tmp mongodump -u mongo -p $(cat /run/secrets/mongo_password) ``` How we've handled syncing for Wordpress is to have a `makefile` target which fetches this from the running server, then loads it into the local database instance. If that seems like a reasonable approach, we could reproduce that with mongo; questions include: 1. How to make this a 1-liner, given that the password lookup likely should happen remotely in the container 2. How to load a dump into a running Mongo instance, ideally dropping existing content first 3. Whether there are any changes which need to be made to the data during or after loading
tma commented 2024-07-16 13:35:31 +00:00
Author
Owner
Copy Link

Got pretty far on this one. sync_db and sync_media both work, but only initially. Think some intermediate step needs to have it's files removed but I'm not seeing it right now

Got pretty far on this one. sync_db and sync_media both work, but only initially. Think some intermediate step needs to have it's files removed but I'm not seeing it right now
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels   
backend

   
frontend

   
infrastructure
No Label
backend
frontend
infrastructure
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
2 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: autonomic-cooperative/nextload#4
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?