I think this is what you are looking for http://bakery.cakephp.org/articles/view/load-balancing-and-mysql-master-and-slaves-2
On Mar 30, 6:28 pm, Alfredo Quiroga-Villamil <[email protected]> wrote: > Pippo: > > I've never done this or even thought about how to do it; so there > might be a better way to accomplish what you want. Perhaps what I am > about to tell you might not be a valid solution; but one thing that > comes to mind is the following: > > Assuming that what you want is to read from one DB and perform CUD > operations on the other one (Master), you could try to: > > Overwrite the methods related to "select" in AppModel and specify the > DB to use for those cases. Do the same for methods that will be of CUD > type in AppModel and point in this case to the other database you > would like to use (master in this case) > > Everyone, please keep me honest here. > > Regards, > > Alfredo > > On Mon, Mar 30, 2009 at 11:42 AM, Pippo <[email protected]> wrote: > > > Hi > > > We would like to use scalr.net and amazon webservices in order to be > > able to scale if we have more and more users. > > > We would like to use one master Database and some slave Databases. The > > synchronization in between of the different databases will go only in > > one way, from the master to the slaves. This would mean that we need > > to be able to differentiate in between of the actions done to the > > database. All the Select statements (cakephp function find) would need > > to go to the slaves, the Insert and Update statements should go to the > > master database. The different Databases are on different Servers > > (IP). > > > I couldn't find any information how this could be done with cakephp. I > > have seen that I can use different databases by defining useDbConfig > > (http://book.cakephp.org/view/435/useDbConfig) but this would mean > > that it would do all the type of SQL statement to one Database, no > > matter whether it is a SELECT (read data) or an UPDATE or INSERT > > (edit, create data). > > > Did someone have the same issue and does someone have a solution for > > this? > > > Thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
