I'm pleased to see that there are some other mysql-proxy player here. First I really would like to know how mysql-proxy can reconfigure itself. I tried to do it, but could achieve that. I really would like to know which version or svn revision you use, because the only version that worked for me was 0.6.0. Later version just couldn't distinct when a mysql node was down.
Regarding your point when you stop mysql. First why would you stop the master? If the master is stopped like you mentionned, I thought scalr would detect that the server was not responding after X seconds. In this case, the slave would become master and scalr would start a new slave based on this master. Maybe we could talk about your mysql-proxy install separately, because my installation is based on a particular instance that hosts mysql-proxy. And I need to start/stop the proxy every time my farm is reconfigured. Any help on that is greatly appreciated. On Mon, Jun 1, 2009 at 5:35 PM, Joe <[email protected]> wrote: > > Ho to all, I'm new on scalr. > > I'm still playing with hosts, and I build some farms. > The last farm, is based on www,app and mysql. I installed also on app > mysql-proxy, because my application is unable to split the read/write > on several db, so this was "the" solution. > > Looks like that everything works fine, but I discover some issues: for > example, if I start 2 or more mysql the first is master, the second > and others are slaves. Mysql-proxy feel all the mysql* hosts and > thanks to the /etc/aws/hosts files can reconfigure himself. But what's > about if the master falls? Thanks the smart system, the slave become > master, and mysql-proxy reconfigure himself. > > But... What's if I manally stop the mysql master (mysql stop, like a > mysql crash)? The application hangs. There is nothing that tell "Hey, > I'm live but I dont' work!". > > Hope that this can be useful to someone. > > Regards, > JS > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
