Didn't work for me - but some kind folks but together a lovely datasource driver that does exactly that - for any one looking for it, try:
https://github.com/primeminister/cake-master-slave-setup On May 6, 3:30 pm, majna <majna...@gmail.com> wrote: > http://cakephp.1045679.n5.nabble.com/Replication-load-balancing-suppo... > > On May 6, 3:18 pm, Shaz <shazam...@gmail.com> wrote: > > > > > > > > > Just wanted to ask if anyone knows how best to do this - essentially I > > want to be able to send all the cakephp mysql selects (read) to a read- > > replica database and all the inserts/deletes/updates (writes) to the > > master database. > > > For a bit of background - I've been tasked to build a site that will > > handle a large number of sessions, data and traffic, and I have done > > all the other optimisations I can think of (loadbalancing on the > > server, containable and fields on all find(), memchached, mysql > > indexes for acl and pretty much everything in the db, using innodb as > > well). > > > Thanks! -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. 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