> So, how can I utilize my CakePHP app with multiple slaves or multiple > masters? Or would multiple masters not make sense if I'm not writing a > lot?
As Nate says in the post you mention. You can define many connections, and switch between them on the fly (using the models callbacks). Having many masters isn't a common scenario, and isn't supported in the majority of the databases engines. > Can I have CakePHP decide which db config to use (assuming a bunch of > slaves) for reading based on a specific load on the databases? Is > there some sort of way to have a load balancer say "ok you use this, > and you use that, and you can use yet another slave over there" ?? I think you need a proxy for this, there are many depending on the database being used. I only know this, http://forge.mysql.com/wiki/MySQL_Proxy . > Thanks. > (PS - new to the whole DB cluster stuff, was a real treat getting a > master - slave setup! but I'm getting the hang of it real quick and > I'm loving it) > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
