tag:blogger.com,1999:blog-18337119.post1652187169472249760..comments2024-01-22T07:09:30.574-05:00Comments on MySQL Consulting and NoSQL Consulting: MySQL DBA: Michael Arrington Asks Twitter a Few Tough QuestionsUnknownnoreply@blogger.comBlogger5125tag:blogger.com,1999:blog-18337119.post-70621686210207465972008-06-02T11:29:00.000-04:002008-06-02T11:29:00.000-04:00Jay and Mike, I agree with you both.I guess the po...Jay and Mike, I agree with you both.<BR/><BR/>I guess the point I am trying to make is to minimize the impact.<BR/><BR/>Depending on an un-partitioned master will bring down 100% of site down.Frankhttps://www.blogger.com/profile/04086666898806120300noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-89135770715254221762008-06-02T10:28:00.000-04:002008-06-02T10:28:00.000-04:00I agree with Mark. From what I understand, Twitter...I agree with Mark. From what I understand, Twitter's problems seem to stem from write-related issues. I think a partitioned (sharded) solution is their only hope Obi-wan.<BR/><BR/>At least in a sharded solution, if they didn't have failover within the shard, only that shard's users would be affected.<BR/><BR/>-jayAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-42988099226607722232008-06-01T18:24:00.000-04:002008-06-01T18:24:00.000-04:00Will that scale beyond the 2 nodes? Or, if you att...Will that scale beyond the 2 nodes? Or, if you attach slaves to each of the master nodes, can you tolerate loss of half of the slaves when a master fails? If not, then the problem hasn't gone away.Mark Callaghanhttps://www.blogger.com/profile/09590445221922043181noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-61915283371337732442008-06-01T15:50:00.000-04:002008-06-01T15:50:00.000-04:00I agree with your point. How about automatic failo...I agree with your point. How about automatic failover from one master to another in multi-master setup? Sure, it's very difficult, but is it impossible?Frankhttps://www.blogger.com/profile/04086666898806120300noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-89952810760283269632008-06-01T10:47:00.000-04:002008-06-01T10:47:00.000-04:00How do you do auto-failover from one master to one...How do you do auto-failover from one master to one of N slaves without possibly losing the other slaves or skipping transactions or losing transactions? It can be very difficult to determine the correct offset for the slave on the new master.Mark Callaghanhttps://www.blogger.com/profile/09590445221922043181noreply@blogger.com