a month ago
I have a database which is used by multiple services(10+) via public url. Each service is connected to a different database. Sometimes when traffic is high on any service, the database service RAM consumption goes up 5GB+ and egress(750GB+) cost also added up.
Now I wanted to optimise costs & performance using
- Private networking (NO Ingress/Egress Costs)
- Low RAM Consumption for each service
- Better performance on peak times
So, is there any way I can copy database service to other projects so that I can use private networking?
Doing this manually, especially data migration is a big task. So any advice o, better approach or suggestion will be very helpful.
Pinned Solution
a month ago
Copy of a service from one project to another is not possible. But here is the best approach for your use case:-
- Deploy database from templates i.e. Mongodb, Postgres etc.
- Use DB migration template to copy data from previous to new DB. Template Links: Mongodb Copy Data and Postgres Copy Data . In these template you need to add source and destination urls and deploy. Once completed you can delete these migration services.
- Do above steps for all of your services and then you can delete unwanted databases via its client tool i.e. mongodb compass etc. (Optional)
Using this approach you can have database for each service connect via its private url. This approach just includes deploying from template and adding source/destination urls.
Hope this helps!
2 Replies
a month ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open sam-a • 28 days ago
a month ago
Currently, it's not possible to transfer a service to another project. Your best approach is:
1. Backup your database.
2. Create a new database in your new project.
3. Restore the backup to the new database.
a month ago
Copy of a service from one project to another is not possible. But here is the best approach for your use case:-
- Deploy database from templates i.e. Mongodb, Postgres etc.
- Use DB migration template to copy data from previous to new DB. Template Links: Mongodb Copy Data and Postgres Copy Data . In these template you need to add source and destination urls and deploy. Once completed you can delete these migration services.
- Do above steps for all of your services and then you can delete unwanted databases via its client tool i.e. mongodb compass etc. (Optional)
Using this approach you can have database for each service connect via its private url. This approach just includes deploying from template and adding source/destination urls.
Hope this helps!
Status changed to Solved brody • 27 days ago