Re: Useing different database for the different actions

Yep, even better.

Tx Martin.

On Mon, Mar 30, 2009 at 2:54 PM, Martin Westin
<martin.westin.gc@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+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---