I have mysql-proxy 0.6.1 installed an running for more than a tear on a separate instance. But I think you could/should install it on the app instance so that you have redundancy.
Envoyé de mon iPhone On 12 sept. 2009, at 00:56, kenja <[email protected]> wrote: > > Thanks for clarifying. > > Where would you install Mysql Proxy? On the Master Database? Has > anyone done this that would be willing to share their configuration? > > > > On Sep 10, 10:09 pm, Frederic Sidler <[email protected]> > wrote: >> No scalr does not manage that. You need to manage it at the >> application level or use a proxy. If you want to manage it at the >> application level check wordpress for example. There is a wordpress >> plugin that does that. >> >> Envoyé de mon iPhone >> >> On 11 sept. 2009, at 02:05, kenja <[email protected]> wrote: >> >> >> >> >> >>> Our site is based on Joomla and we want to start sending reads to >>> the >>> mysql slaves and the writes to the master as our traffic goes up. >>> At >>> this point we're only using a master database. I found an old >>> post on >>> this subject that indicated that simply by pointing Joomla's config >>> file to int-mysql.mydomain.com, that the reads would go to the >>> slaves >>> and the writes would go to the master. Then someone followed up by >>> suggesting the use of MySQL Proxy to proxy the requests. >> >>> Can someone clarify this form me? Does scalr already include some >>> form of seamless read/write mysql proxy capability, or do we need to >>> install it via MySQL proxy? If we have to install it, which >>> instance >>> would we install it on? Has anyone done that that could share their >>> experiences? >> >>> Thanks! > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "scalr-discuss" 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/scalr-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
