[Building Sakai] Split Database read and write queries using HAProxy

Abdul khader akhader at gmail.com
Thu Jun 3 13:23:56 PDT 2010


Dear All,
I am pretty new to Sakai. I am trying to see if there is any way of telling
sakai to send Database read requests to say DB server "A" and write requests
to DB server "B".

I am using HAproxy infront of the 2 Database servers. So, sakai server will
hit a virtual IP to access the database access.

I am trying to achieve something like below.



Read Request

|-------------------------------------------------> DB Server A
Sakai Server ------------------------> Virtual IP of HAProxy
--------------------------------------------------------|

|-------------------------------------------------> DB server B

Write Request

Any help would is greatly appreciated.


Many Thanks
Abdul Khader
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100604/7eb7eee5/attachment.html 


More information about the sakai-dev mailing list