Forums

Read / Write separation

Permalink
Does anyone know whether it's possible to separate read/write queries in Concrete5 and send them to different mysql instances?

I want to see what Amazon Web Services RDS read replicas can do to help scaling.
ggn06awu
 
Mainio replied on at Permalink Best Answer Reply
Mainio
Not really possible out of the box.

I think the easiest solution (workaround) would be to hack the adodb database class (ADOConnection) and do some detection in the Query() function whether it's a read or write query and then separate the calls between the different servers accordingly.