2 months ago
After upgrading to pro I added a replica on one of my builds. Upon testing the app ran really slow. I looked a the database and can only think that it's latency due to database connection. I read that it's possible to create a cluster as it's not possible to replica the database. Do you have any recommendations?
9 Replies
2 months ago
Hey there! We've found the following might help you get unblocked faster:
If you find the answer from one of these, please let us know by solving the thread!
2 months ago
No, they don't answer my question
2 months 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 brody • 3 months ago
2 months ago
Hey there!
For the database connection are you using the private URL or public?
Public is usually a couple hundred ms slower
2 months ago
Private. We're not talking ms slower. After I deployed the EU replica it was seconds slower
mrgmward
Private. We're not talking ms slower. After I deployed the EU replica it was seconds slower
2 months ago
Hmmm, in your app are you connection pooling or using a single connection?
2 months ago
Single connection. Everything was easy coast. I’m in England. Added Europe, went slow. Deleted Europe, instantly back to speed
2 months ago
So the only thing that changed was region? If you add a replica in the east coast region does it work fine?
Ideally want to pinpoint exactly where its going wrong, whether on replica or just a service in EU, before bringing it up to the team.
2 months ago
In the same location is fine. The only thing I can think is that, I'm in the UK so calling files from the EU which is tapping the database on the East Coast. I can't create an EU replica database as it has a volume attached. Must be latency
2 months ago
The private network is not region aware, please keep all connected services in the same region.