tag:blogger.com,1999:blog-768233104244702633.post6791807547638633260..comments2023-11-16T03:16:54.746-08:00Comments on The Scale-Out Blog: Virtual IP Addresses and Their Discontents for Database AvailabilityRobert Hodgeshttp://www.blogger.com/profile/05379726998057344092noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-768233104244702633.post-75601570929284744332014-07-18T03:00:09.676-07:002014-07-18T03:00:09.676-07:00Nice article :) i have a doubt.. whether virtual I...Nice article :) i have a doubt.. whether virtual IP work across different network switches? will it be a gud solution when the two nodes(master and slave) are wide apart in terms of distanceAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-768233104244702633.post-70913892074551353342013-02-21T18:23:32.995-08:002013-02-21T18:23:32.995-08:00Great post. Thank you very much good sir.Great post. Thank you very much good sir.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-768233104244702633.post-74132045272681438702012-07-04T15:53:01.556-07:002012-07-04T15:53:01.556-07:00Very good post !Very good post !Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-768233104244702633.post-50219228547122924902012-05-25T13:31:40.513-07:002012-05-25T13:31:40.513-07:00Thanks for the article. I was looking for this kin...Thanks for the article. I was looking for this kind of article to undestand VIP as we are going to use VIP for our PostgreSQL database failover.Vivekhttp://www.bharattutors.comnoreply@blogger.comtag:blogger.com,1999:blog-768233104244702633.post-80587943637941607812011-02-02T02:38:41.630-08:002011-02-02T02:38:41.630-08:00Excellent writeup, Robert. Much appreciated! You c...Excellent writeup, Robert. Much appreciated! You covered a lot of the nasty gotchas that I blissfully glossed over in my MySQL HA talk :) Added to the MySQL Librarian!LenZhttp://www.lenzg.net/noreply@blogger.comtag:blogger.com,1999:blog-768233104244702633.post-75882938926137372822011-02-01T20:20:45.035-08:002011-02-01T20:20:45.035-08:00@Giorgio. You can go still further and not to use...@Giorgio. You can go still further and not to use VIPs at all. We have done a lot of work with intelligent SQL proxies. In additional to avoiding ARP weirdness they allow you to do cool things like seamless switch (e.g., flipping a master/slave pair) and load-balancing reads safely onto replicas. I hope to post more extensively in the near future but in the meantime you can look at Tungsten Connector documentation for a sense of the approach (http://www.continuent.com/images/stories/pdfs/tungsten-connector-guide.pdf).Robert Hodgeshttps://www.blogger.com/profile/05379726998057344092noreply@blogger.comtag:blogger.com,1999:blog-768233104244702633.post-32902358319414753082011-02-01T07:03:16.768-08:002011-02-01T07:03:16.768-08:00This is where a true hardware based vip like the o...This is where a true hardware based vip like the one found in Alteon load balancers would help (just an example, I have no stake in Alteon :) ).<br /><br />The mac address of the VIP doesn't change, no need for ARP monkeying, drawback is that all communication goes through the load balancer that can become a bottleneck in extreme cases.<br /><br />I wonder if something like that is doable using the linux iptables stack.Giorgiohttp://blog.zanopia.orgnoreply@blogger.comtag:blogger.com,1999:blog-768233104244702633.post-29706835356183966912011-01-31T10:04:02.836-08:002011-01-31T10:04:02.836-08:00@Ronald and others! Thanks, glad you liked the ar...@Ronald and others! Thanks, glad you liked the article. I hope to dig into cluster manager behavior more fully in a future article.Robert Hodgeshttps://www.blogger.com/profile/05379726998057344092noreply@blogger.comtag:blogger.com,1999:blog-768233104244702633.post-81707330330693834812011-01-31T09:51:30.731-08:002011-01-31T09:51:30.731-08:00Great detail. I've got to re-read it again in ...Great detail. I've got to re-read it again in detail but it is a good reference for me to describe to clients some of the technical details and issues around VIP'sRonald Bradfordhttp://ronaldbradford.comnoreply@blogger.comtag:blogger.com,1999:blog-768233104244702633.post-31183763617260686852011-01-31T07:50:23.093-08:002011-01-31T07:50:23.093-08:00The VRRP part of keepalived is also a common way t...The VRRP part of keepalived is also a common way to handle VIPs on Linux.Martin Barryhttp://about.me/supinenoreply@blogger.comtag:blogger.com,1999:blog-768233104244702633.post-68947311573694651742011-01-31T07:20:53.775-08:002011-01-31T07:20:53.775-08:00@Vivek, I didn't mention CARP but I have seen ...@Vivek, I didn't mention CARP but I have seen this used and it generally seems good. The basic point is you need *some* kind of cluster manager to manage VIPs. Our own Tungsten product has a fairly sophisticated scheme for VIP management. I have also used Heartbeat, which is quite similar. Heartbeat is integrated into PaceMaker, which is mentioned in the article.Robert Hodgeshttps://www.blogger.com/profile/05379726998057344092noreply@blogger.comtag:blogger.com,1999:blog-768233104244702633.post-57283940472418559192011-01-31T06:32:27.029-08:002011-01-31T06:32:27.029-08:00It seems to me you would want to use a proper virt...It seems to me you would want to use a proper virtual address sharing mechanism, such as CARP in FreeBSD, that will ensure exactly one server will respond to the IP at a time.Vivekhttps://www.blogger.com/profile/08301048894634214933noreply@blogger.comtag:blogger.com,1999:blog-768233104244702633.post-7948562603195888572011-01-30T23:47:42.113-08:002011-01-30T23:47:42.113-08:00Thanks for this article...
Really good explainatio...Thanks for this article...<br />Really good explaination.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-768233104244702633.post-47343706673814672582011-01-30T23:03:22.321-08:002011-01-30T23:03:22.321-08:00awesome post! thanks.awesome post! thanks.Anonymousnoreply@blogger.com