Re: Useing different database for the different actions

Great, Thanks! I guess was searching for the wrong terms.

On 30 Mrz., 20:57, Alfredo Quiroga-Villamil <laww...@gmail.com> wrote:
> 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-mast...
>
> > 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+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---