Yep, even better. Tx Martin.
On Mon, Mar 30, 2009 at 2:54 PM, Martin Westin <martin.westin...@gmail.com> wrote: > > 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 <laww...@gmail.com> > 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 <phil...@wuermli.com> 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 cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---