tag:blogger.com,1999:blog-16959946.post5368199688548121870..comments2023-12-09T16:44:47.897+01:00Comments on The Data Charmer: Who's afraid of MySQL forks?Giuseppe Maxiahttp://www.blogger.com/profile/15801583338057324813noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-16959946.post-57705890773275247862012-02-06T19:14:10.466+01:002012-02-06T19:14:10.466+01:00A comparative of the different MySQL forks:
http:/...A comparative of the different MySQL forks:<br />http://investigacionit.com.ar/2012/02/forks-de-mysql/Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-16959946.post-4822185378302112502010-12-08T05:41:50.407+01:002010-12-08T05:41:50.407+01:00It's interesting to note that the last change ...It's interesting to note that the last change to the 5.5 repository on launchpad was four weeks ago.Stewart Smithhttps://www.blogger.com/profile/00989044306462002000noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-74065037610616973582010-12-08T05:40:43.814+01:002010-12-08T05:40:43.814+01:00All the changes up to 5.5.6 are in Drizzle right n...All the changes up to 5.5.6 are in Drizzle right now. A merge request is up there now for 5.5.7, so Drizzle will be completely up to date with the MySQL 5.5 improvements.<br /><br />It will be interesting to see the next batch of improvements to InnoDB too.Stewart Smithhttps://www.blogger.com/profile/00989044306462002000noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-61795170562436042902010-12-07T20:47:35.549+01:002010-12-07T20:47:35.549+01:00I have a hard time keeping up with the many good c...I have a hard time keeping up with the many good changes that are new in InnoDB. The <a href="http://dev.mysql.com/doc/innodb-plugin/1.1/en/innodb-performance.html" rel="nofollow">features from 5.5</a> include multiple buffer pool instances to reduce mutex contention on the buffer pool mutex, multiple rollback segments to reduce contention on the rollback segment mutex and allow for more than 1023 concurrent transactions, an option to move purge to a separate thread to let it keep up with IO intensive loads, changes to reduce contention on the transaction log (log sys) mutex and use of a separate mutex for the flush list to reduce contention on the buffer pool mutex.Mark Callaghanhttps://www.blogger.com/profile/09590445221922043181noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-64013678295694830582010-12-07T19:46:03.469+01:002010-12-07T19:46:03.469+01:00Hi!
While Drizzle does use Innodb, we are pretty ...Hi!<br /><br />While Drizzle does use Innodb, we are pretty much at the end of what we will be taking from Oracle. Between HailDB and the fact that we aren't finding much progress being done with Innodb, we will only be making use a few more of their patches before breaking away from it entirely.<br /><br />I am not really sure what you mean by a business case. We do have companies support that support Drizzle, and while we are certainly not as MySQL how downloads and usage continue to grow (despite us being in Beta).<br /><br />Drizzle is not the one shop model that exists for MySQL/others. We much refer the Linux route, and encourage multiple vendors. I believe you would agree that long ago the "we need a single business entity" model was proven to be false.<br /><br />Cheers,<br /> -BrianBrian Akerhttps://www.blogger.com/profile/10779939131479683690noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-50445050257581606382010-12-07T01:58:54.909+01:002010-12-07T01:58:54.909+01:00Those who wish that third parties would "keep...Those who wish that third parties would "keep out of the coding" would do well to ponder how fast progress on InnoDB was moving before third-parties got frustrated with the snail's pace, and started releasing improvements that made the official InnoDB look less attractive.<br /><br />Progress does not happen in a vacuum.Baronhttps://www.blogger.com/profile/01621441847303652718noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-18298629326331043652010-12-04T07:18:36.480+01:002010-12-04T07:18:36.480+01:00"The Data Charmer" Thanks for charming t..."The Data Charmer" Thanks for charming the topic; really a good read.<br /><br />@Morgan: I completely agree with the "(2)Diagnostics/Usability enhancements." argument.<br />[ Shameless "plugged": I'm attending :)]Kedarhttp://kedar.nitty-witty.com/blognoreply@blogger.comtag:blogger.com,1999:blog-16959946.post-612806128659564942010-12-04T02:17:24.857+01:002010-12-04T02:17:24.857+01:00As for outside code contributions, it's pretty...As for outside code contributions, it's pretty clear that Drizzle is the widest collaboration of individuals and companies. i.e. we're a more spread out development organisation - which means that we're going to be rather resilient.Stewart Smithhttps://www.blogger.com/profile/00989044306462002000noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-35912154362957650212010-12-03T23:54:50.756+01:002010-12-03T23:54:50.756+01:00So we have a couple of species of dolphin and a tu...So we have a couple of species of dolphin and a tuna. <br /><br />As the MySQL Fan Boy. I'm wounding why we are still talking about this. I'm not worried where MySQL is going. I use the office (Oracle) version at work, MariaDB at home and I'd like to consult with Percona but can't afford it.<br /><br />Code progress is being made. <br /><br />I'm not so sure one team/party/distrubution is the right way. Fresh ideas and people willing to code them is the Open Source way. <br /><br />I also like corporations distributing and supporting the code. I just wish they would keep out of the coding. A perfect world might be where Oracle takes code from and gives money too the other projects. Not to take them over or even make them dependent. Just enough to say thanks. <br /><br />Wouldn't it be nice if Oracle through a party every two years and flew in, at their expense, all the people who donated the top 50% of code to any MySQL distribution.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-16959946.post-76163625898112870972010-12-03T17:07:53.507+01:002010-12-03T17:07:53.507+01:00I agree with what you say as well - though in my p...I agree with what you say as well - though in <a href="http://worldgonemad.com/blogs/pantoniades/2010/03/mysql-spins-and-forks/" rel="nofollow">my post</a> I said there was only one actual fork (drizzle). But I buy your "pluto" argument too. <br><br />As an Oracle guy (and classic dolphin), I also take this as a tacit acceptance of Oracle's stewardship of MySQL. Oracle's been a good home to InnoDB for years, and MySQL Engineering is still awesome and growing.Philiphttp://worldgonemad.com/blogs/noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-24151277744420151452010-12-03T17:07:23.347+01:002010-12-03T17:07:23.347+01:00What most observers also miss is that while the co...What most observers also miss is that while the code may be freely available under GPL, the documentation is not, and could go away tomorrow.Unknownhttps://www.blogger.com/profile/15838043061740482896noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-54658054967836665012010-12-03T14:14:19.548+01:002010-12-03T14:14:19.548+01:00I agree with almost everything you said, and I esp...I agree with almost everything you said, and I especially like the way you described Linux vendors as forks as well. In the case of Percona Server, my last check showed that 20K lines are changed out of 2-3 million. Not many.<br /><br />Regarding your "five types of arguments in favor of a MySQL fork", I am not sure if this is granular enough. The 'features' really fall in two categories:<br /><br />1) Performance<br />2) Diagnostics/Usability enhancements.<br /><br />Many people get excited about (1), but the real reason they should be switching is (2). Most people are already not getting the performance they are entitled to, and the reason is that a default MySQL release is not instrumented enough.<br /><br />I'm talking about things like "Waiting on query cache mutex" in the processlist, or being able to see statistics on which indexes are used/unused.<br /><br />( Shameless plug: I'm holding a webinar on this next week - http://www.percona.com/webinars/2010-12-08-introduction-to-percona-server-xtradb-xtrabackup/ )Morgan Tockerhttps://www.blogger.com/profile/07820955267400574921noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-63863798152398627982010-12-03T12:23:09.005+01:002010-12-03T12:23:09.005+01:00Excellent status report. I've been thinking of...Excellent status report. I've been thinking of a similar spirited post myself - I'll do it over the weekend so we can compare.hingohttps://www.blogger.com/profile/09201666166374161923noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-24266418138022018232010-12-03T10:46:10.107+01:002010-12-03T10:46:10.107+01:00In Drizzle, we also have PBXT in the tree as a tra...In Drizzle, we also have PBXT in the tree as a transactional engine... and are always open to merging others.<br /><br />As for dependence on Oracle for InnoDB... while we're certainly merging improvements from upstream, we're not completely helpless when it comes to fixing and improving InnoDB.Stewart Smithhttps://www.blogger.com/profile/00989044306462002000noreply@blogger.com