I'm interested in the potential read performance increase of having a "Read replica" of my amazon RDS. Before I try, I'd like to be clearer on a few things.
- After creating a read replica, how does this effect my app? Do the benefits happen behind the scenes at aws or do I need to write logic for my application to know that it can read from this new replica instance?
- It mentions a "Brief I/O interruption" that can last up to a minute here Does that mean my production app is 'dead in the water' for up to a minute? Has anyone experienced anything longer than that?
- Any other risk I should be aware of?
Thanks for the help.