Jump to content

Read replica for asyncspc.php only

Recommended Posts

My site runs highly distributed in 15+ locations around the world. (Primary in Germany, read replicas in X other locations)

This results in great performance for the dynamic HTML (80ms from US West coast to regional replica), however all my asyncspc.php request still go to Germany (463ms to Germany)

I understand Revive Adserver needs Primary/Primary for full replication to work.

I wonder if I can go for a setup which ONLY sends asyncspc.php to many global (read-only) replicas. Any other request which reads/writes (eg. lg.php would go to the primary)


- Make asyncspc.php as fast as possible (any delay here results in ads being shown later)
- Ignore the speed of lg.php, when this requests take a bit longer is not really important


Does you know if such a setup will work as expected; or will there be hidden "writes" which are triggered by asyncspc.php?

Edited by Tim Vereecke
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...