I’m using DigitalOcean’s managed databases for Postgres and MySQL including read replicas. Is there any way to configure write forwarding (or any similar concept) for those read replicas to prevent needing heavy application changes to take advantage of read replicas? Specifically interested in anything like AWS RDS write forwarding (link).
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hey @jackfischer,
I believe that there isn’t anything like this out of the box but this is a great idea, sounds like it’d be super useful!
The best thing to do to get your voice heard regarding this would be to head over to our Product Ideas board and post a new idea, including as much information as possible for what you’d like to see implemented.
In the meantime, you could use a tool like ProxySQL or Arca:
https://marketplace.digitalocean.com/apps/acra
Hope that helps! - Bobby.