Read queries to DB slave, write queries go master DB
Posted: Wed Dec 21, 2011 8:54 am
I have this Master-Slave replication configuration. The master is the database server of the solution. The slave is the database server of a website in PHP. All of the Website's read queries go to the slave.
I’d like to have the Servoy solution’s read queries go to the slave too. I think that to do that I would have to change the database server at run time every time a find is triggered. Has anybody else done this successfully? Any other approach? Any method sample?
Best,
JC
I’d like to have the Servoy solution’s read queries go to the slave too. I think that to do that I would have to change the database server at run time every time a find is triggered. Has anybody else done this successfully? Any other approach? Any method sample?
Best,
JC