The question is whether scalr detects that the mysql master INSTANCE is down and promotes the slave or the actual mysql PROCESS. In the first option bringing the mysql down for whatever maintenance would not result in promoting any slave...
What is actually being checked? 2009/6/2 Frédéric Sidler <[email protected]> > 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 -~----------~----~----~----~------~----~------~--~---
