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 -~----------~----~----~----~------~----~------~--~---
