Forums

Improved Database performance

Permalink
I was curious if you can configure Concrete5 to use separate databases for read and write functions for improved performance?

For example, have a combination database and web server [A] so the website uses the local database for read data, but if it needs to make any writes it uses another database server [B]. Those write changes from server [B] are then migrated back to [A].

Other thoughts for improved database performance?

Thanks
 
ggn06awu replied on at Permalink Reply
ggn06awu
johnosako, This is a late entry, but I've been looking at this in C5 during this week. It seems as though there is no separation for read/write queries going all the way back into the ADODB library C5 appears to use, thus you'd need to rewrite chunks of the core to achieve this. If you were hoping to look at MySQL master/slave replication then you're on the same journey as me and it's proving fruitless.

I suggest looking into master/master configurations as outlined here:
http://www.neocodesoftware.com/replication/...