Amazon RDS FAQs stated that it is up my application to distribute traffic to the read replica.
My websites have mostly visitors - non-logged in users. So, I suppose most database activities are read. I am supposed to set the MySQL database connection to the read replica for non-logged in users and the source RDS instance for logged-in ones?
My single RDS instance which power several websites just went bottleneck so I'm a little panicking and don't know where to start right now.
If the direction I'm going is not correct, kindly point me to the correct path then