How do I get a dump of PaaS environment database to local machine
I want to debug a certain error case on my PaaS environment, therefore I would like to work with this on my local machine. How do I create a dump of the database to be able to use it on my local machine?
Best Answer
-
fsmeier Senior Software Engineer & Developer Enablement Advocate Sprykee Posts: 1,056 โ๏ธ - Guardians (admin)
Heyhey @daniel.gebhard ,
I asked our cloud team and basically there are multiple possibilities:
One is to use mysqldump being connected to the env via respective VPN.
Creds can be found in the AWS ECS -> Task Definitions -> zed\boffice.If it's a live Prod, it makes sense to ask the support to provide the dump because dumping directly from live prod DB will lock it.
And support can do it in two ways:
1) in case there as internally used RO replica, they will dump it instead of the main one
2) they can restore 1h old snapshot and dump it instead of the main one.
And then they can put the dump into S3 where you will just need to download it to the local.Hope this helps :)
All the best,
Florian
2
Answers
-
fsmeier Senior Software Engineer & Developer Enablement Advocate Sprykee Posts: 1,056 โ๏ธ - Guardians (admin)
Heyhey @daniel.gebhard ,
I asked our cloud team and basically there are multiple possibilities:
One is to use mysqldump being connected to the env via respective VPN.
Creds can be found in the AWS ECS -> Task Definitions -> zed\boffice.If it's a live Prod, it makes sense to ask the support to provide the dump because dumping directly from live prod DB will lock it.
And support can do it in two ways:
1) in case there as internally used RO replica, they will dump it instead of the main one
2) they can restore 1h old snapshot and dump it instead of the main one.
And then they can put the dump into S3 where you will just need to download it to the local.Hope this helps :)
All the best,
Florian
2 -
0
Categories
- All Categories
- 42 Getting Started & Guidelines
- 7 Getting Started in the Community
- 8 Additional Resources
- 7 Community Ideas and Feedback
- 69 Spryker News
- 896 Developer Corner
- 758 Spryker Development
- 83 Spryker Dev Environment
- 361 Spryker Releases
- 3 Oryx frontend framework
- 34 Propel ORM
- 68 Community Projects
- 3 Community Ideation Board
- 30 Hackathon
- 3 PHP Bridge
- 6 Gacela Project
- 23 Job Opportunities
- 3.2K ๐ Slack Archives
- 116 Academy
- 5 Business Users
- 370 Docker
- 551 Slack General
- 2K Help
- 75 Knowledge Sharing
- 6 Random Stuff
- 4 Code Testing
- 32 Product & Business Questions
- 68 Spryker Safari Questions
- 50 Random