We are planning to create a read replica on our MySql Database on RDS but we want to manage this on AWS. Does AWS has a solution that manages requests and redirect them if write to the master otherwise to the read replica?
Asked
Active
Viewed 216 times
0
-
Some `SELECTs` are used in support of writes, hence must be on the same server, even in the same transaction. Beware of any tool that "splits" those `SELECTs` out. – Rick James Dec 16 '22 at 22:05
1 Answers
0
I think AWS Aurora for MySQL is your best bet. It's quite flexible, you can have multi-master or read replicas.
Alternate a fairly new feature "RDS MySQL multi-az with two readable standbys" which you can see here and here.
Your question is fairly high level. If it had more detail I may have been able to refine the answer a bit more.
Tim
- 31,888
- 7
- 52
- 78