Separating read / write queries on different databases in prestashop

[TheLousyCoder]

I am trying to reduce the load on master database by separating queries.

I have my huge shop having almost 1200 categories. I have currently two database servers, a Master and a Slave.

I need to allocate read queries (select, explain, describe )  to slave db and write queries (update, delete, insert etc ) to Master database. 

I am new to prestashop and your help doing this, any help will greatly appreciated.

 

Edit: running version 1.5.6

Thanks in advance.

Edited February 4, 2015 by TheLousyCoder (see edit history)