: How to handle Database Latency in Cross Region? AWS I am working on a project with below setup The users from USA are receiving much faster response, but for the users from INDIA/China, it

I am working on a project with below setup

The users from USA are receiving much faster response,
but for the users from INDIA/China, it takes more time to Load.

How can this issue be addressed?
Based on my search, some suggest it was due to database latency, since
Server from China has to contact RDS in USA and render result.

But i am not sure if that's the real cause.
Please suggest.

Note : I am using Amazon RDS as database and PHP as backend.

10.01% popularity Vote Up Vote Down

: Site: search gives indication of page strength? I was curious if you do a site search, you will usually get your home page and navbar links first...right? Thus my question, when you move

@Yeniel560

Posted in: #Content #Google #Seo

1 Comments

: Can one or two links from popular sites with great reputation cause my site to rank noticably better in Google? Maybe this is a question which stems admittedly out of lack of proper knowledge

@Yeniel560

Posted in: #Backlinks #Ranking #Seo #Serps

1 Comments

: When is eliminating render-blocking CSS worth it? We wanted to follow the PageSpeed Insights CSS recommendations and separate critical and deferred CSS. To that end we read lots of posts and

@Yeniel560

Posted in: #Css #GooglePagespeed #PageSpeed #Seo

1 Comments

: What are the friendly/rich URLs in Google Search result snippets called? When searching content on Google, I sometimes see a neatly organized location of the document, instead of the regular URLs

@Yeniel560

Posted in: #GoogleSearch #Serps #Url

2 Comments

Login to post a comment!

1 Comments

Sorted by latest first Latest Oldest Best

@LarsenBagley505

The issue you have identified (database latency) is most definitely the issue. Some people assume that because AWS is a cloud provider all data and services is available across the whole world, but its not quite like that. RDS (Relational Database Service) is region specific. What that means is that your database is hosted within a single data center in a single geographic region. There is however a way to resolve this issue and it is called Cross-Region Read Replicas.

Cross region read replicas are good for disaster recovery, migrating between regions, and scaling out globally. In your instance it resolved number 3 (scale out globally). You will be unable to handle database writes from the read replica and it will require a slight change to your code to ensure database read requests go to the local instance and write requests go to the master instance (USA).
aws.amazon.com/blogs/aws/cross-region-read-replicas-for-amazon-rds-for-mysql/

10% popularity Vote Up Vote Down

Feed

: How to handle Database Latency in Cross Region? AWS I am working on a project with below setup The users from USA are receiving much faster response, but for the users from INDIA/China, it

More posts by @Yeniel560

: Site: search gives indication of page strength? I was curious if you do a site search, you will usually get your home page and navbar links first...right? Thus my question, when you move

: Can one or two links from popular sites with great reputation cause my site to rank noticably better in Google? Maybe this is a question which stems admittedly out of lack of proper knowledge

: When is eliminating render-blocking CSS worth it? We wanted to follow the PageSpeed Insights CSS recommendations and separate critical and deferred CSS. To that end we read lots of posts and

: What are the friendly/rich URLs in Google Search result snippets called? When searching content on Google, I sometimes see a neatly organized location of the document, instead of the regular URLs

Login to post a comment!

1 Comments

Back to top | Use Dark Theme