Comments on: Tip of the Day — What MySQL Version to Use http://www.paragon-cs.com/wordpress/?p=106 Just another WordPress weblog Wed, 21 Oct 2009 14:10:28 +0000 hourly 1 http://wordpress.org/?v=3.0.1 By: Norbert Tretkowski http://www.paragon-cs.com/wordpress/?p=106&cpage=1#comment-1147 Norbert Tretkowski Wed, 19 Mar 2008 16:33:14 +0000 http://www.paragon-cs.com/wordpress/?p=106#comment-1147 Sheeri, of course the MySQL version number in Debian correlates with MySQL versions. It's a MySQL version x and some (important) patches, e.g. the official patch from 5.0.52 for MySQL bug #30666, which is fixed 5.0.51a-1 from Debian, but not in the latest community release of MySQL. Sheeri, of course the MySQL version number in Debian correlates with MySQL versions. It’s a MySQL version x and some (important) patches, e.g. the official patch from 5.0.52 for MySQL bug #30666, which is fixed 5.0.51a-1 from Debian, but not in the latest community release of MySQL.

]]> By: Sheeri http://www.paragon-cs.com/wordpress/?p=106&cpage=1#comment-1143 Sheeri Sat, 15 Mar 2008 17:19:07 +0000 http://www.paragon-cs.com/wordpress/?p=106#comment-1143 the problem with vendor packaging is that often the version numbers do not correlate with MySQL versions, and vendors don't bother to change the version # of the original version they patched. So it might say 5.1.22 Debian but you have no idea what's in there -- you have to look at the manual for the change notes in 5.1.22 and then whatever changenotes Debian may or may not have. the problem with vendor packaging is that often the version numbers do not correlate with MySQL versions, and vendors don’t bother to change the version # of the original version they patched. So it might say 5.1.22 Debian but you have no idea what’s in there — you have to look at the manual for the change notes in 5.1.22 and then whatever changenotes Debian may or may not have.

]]> By: Log Buffer #88: a Carnival of the Vanities for DBAs http://www.paragon-cs.com/wordpress/?p=106&cpage=1#comment-1144 Log Buffer #88: a Carnival of the Vanities for DBAs Fri, 14 Mar 2008 16:57:56 +0000 http://www.paragon-cs.com/wordpress/?p=106#comment-1144 [...] Murphy’s Diamond Notes has a tip on what MySQL version to use if you’re running Linux. The tip and its comments sheds some light on different distributions, package managers, and [...] [...] Murphy’s Diamond Notes has a tip on what MySQL version to use if you’re running Linux. The tip and its comments sheds some light on different distributions, package managers, and [...]

]]> By: Norbert Tretkowski http://www.paragon-cs.com/wordpress/?p=106&cpage=1#comment-1152 Norbert Tretkowski Wed, 12 Mar 2008 11:00:17 +0000 http://www.paragon-cs.com/wordpress/?p=106#comment-1152 Just for the record... The Debian MySQL maintainers provide an up-to-date version of MySQL from Debian testing (currently 5.0.51a) for stable on http://backports.org/ as well. You don't need to stick with 5.0.32 when running etch. Just for the record… The Debian MySQL maintainers provide an up-to-date version of MySQL from Debian testing (currently 5.0.51a) for stable on http://backports.org/ as well. You don’t need to stick with 5.0.32 when running etch.

]]> By: Peter Zaitsev http://www.paragon-cs.com/wordpress/?p=106&cpage=1#comment-1151 Peter Zaitsev Wed, 12 Mar 2008 05:17:01 +0000 http://www.paragon-cs.com/wordpress/?p=106#comment-1151 I think for say 95% of users the version which is shipped with operating system is good enough. It works so you might not want touch it. I tend to make people to upgrade when there are reasons - something does not working well or some features or performance improvements in new versions are desired. Note especially with RPM based distributions there is the chance you will break something by installing versions from mysql.com - they are quite commonly not built the same way and have different package naming. I think for say 95% of users the version which is shipped with operating system is good enough. It works so you might not want touch it.

I tend to make people to upgrade when there are reasons – something does not working well or some features or performance improvements in new versions are desired.

Note especially with RPM based distributions there is the chance you will break something by installing versions from mysql.com – they are quite commonly not built the same way and have different package naming.

]]> By: admin http://www.paragon-cs.com/wordpress/?p=106&cpage=1#comment-1146 admin Wed, 12 Mar 2008 01:06:21 +0000 http://www.paragon-cs.com/wordpress/?p=106#comment-1146 Arjen, Very insightful about security patches. While I had no crystal-clear thought of this somewhere in the murky depths this is what I was thinking. And I know the debate is going back and forth within MySQL about the Community vs Enterprise and patches and so forth. I weigh very heavily on the side that we on the Community side of things should have access to the code if not before Enterprise certainly at the same time. If for no other reason than the the MANY more Community users will help to uncover problems and get them fixed quicker. I really think that the Enterprise license should buy you two things: * direct access to the MySQL Engineers with bugs * more functionality possibly ????? I am actually very uncomfortable with this, but at least in the case of MySQL Workbench it seems to be working well * NOT different codebases I could be wrong about this. Been before...will be again!! I just think it is interesting how MySQL employees have publicly said that they don't agree with the current setup. Arjen,

Very insightful about security patches. While I had no crystal-clear thought of this somewhere in the murky depths this is what I was thinking. And I know the debate is going back and forth within MySQL about the Community vs Enterprise and patches and so forth. I weigh very heavily on the side that we on the Community side of things should have access to the code if not before Enterprise certainly at the same time. If for no other reason than the the MANY more Community users will help to uncover problems and get them fixed quicker. I really think that the Enterprise license should buy you two things:

* direct access to the MySQL Engineers with bugs
* more functionality possibly ????? I am actually very uncomfortable with this, but at least in the case of MySQL Workbench it seems to be working well
* NOT different codebases

I could be wrong about this. Been before…will be again!! I just think it is interesting how MySQL employees have publicly said that they don’t agree with the current setup.

]]> By: Arjen Lentz http://www.paragon-cs.com/wordpress/?p=106&cpage=1#comment-1145 Arjen Lentz Tue, 11 Mar 2008 22:03:53 +0000 http://www.paragon-cs.com/wordpress/?p=106#comment-1145 I think that generally, security patches are not the issue for production servers, since they have no direct external exposure. Fixes for functional problems are much more relevant as they direct affect the application. You'd want to make sure your replication is as stable as possible, even if you have not yet been bitten by a problem that others have reported. Right now, a key issue lies with the fact that community builds by Sun-MySQL are only periodic whereas if you want the latest patches you need to subscribe to MySQL Enterprise or gets the enterprise builds from elsewhere. Is "speed of patches for production use" something that should be charged, or should bugfixes be available quickly to all who use the software? An interesting debate. While you can make a valid case for the former, I think I lean towards the latter. It's not just about providing extra value, it's about the perceived quality of the product and for that the community is vital. Putting the quality behind a pricetag makes it problematic. That's not added value, but pricing something that the community feels should be theirs anyway. Not that the community is always right in what it feels it should be able to get, but in this case I reckon they may have a point. I think that generally, security patches are not the issue for production servers, since they have no direct external exposure. Fixes for functional problems are much more relevant as they direct affect the application. You’d want to make sure your replication is as stable as possible, even if you have not yet been bitten by a problem that others have reported.
Right now, a key issue lies with the fact that community builds by Sun-MySQL are only periodic whereas if you want the latest patches you need to subscribe to MySQL Enterprise or gets the enterprise builds from elsewhere. Is “speed of patches for production use” something that should be charged, or should bugfixes be available quickly to all who use the software? An interesting debate.
While you can make a valid case for the former, I think I lean towards the latter. It’s not just about providing extra value, it’s about the perceived quality of the product and for that the community is vital. Putting the quality behind a pricetag makes it problematic. That’s not added value, but pricing something that the community feels should be theirs anyway.
Not that the community is always right in what it feels it should be able to get, but in this case I reckon they may have a point.

]]> By: Pavel http://www.paragon-cs.com/wordpress/?p=106&cpage=1#comment-1149 Pavel Tue, 11 Mar 2008 21:42:47 +0000 http://www.paragon-cs.com/wordpress/?p=106#comment-1149 Exactly for this reason (not only with mysql) we started to look into gentoo. After about a year of painful testing and tweaking we are close to deploying it in production to replace redhat on some 10 boxes... Exactly for this reason (not only with mysql) we started to look into gentoo. After about a year of painful testing and tweaking we are close to deploying it in production to replace redhat on some 10 boxes…

]]> By: admin http://www.paragon-cs.com/wordpress/?p=106&cpage=1#comment-1148 admin Tue, 11 Mar 2008 20:42:39 +0000 http://www.paragon-cs.com/wordpress/?p=106#comment-1148 See I knew this would generate some fun! I didn't say this is in the post .. but we use Debian Etch on our servers. They generally are good about security patches. However, they are also packaging 5.0.32. No thanks!! See I knew this would generate some fun! I didn’t say this is in the post .. but we use Debian Etch on our servers. They generally are good about security patches. However, they are also packaging 5.0.32.

No thanks!!

]]> By: Norbert Tretkowski http://www.paragon-cs.com/wordpress/?p=106&cpage=1#comment-1150 Norbert Tretkowski Tue, 11 Mar 2008 18:58:58 +0000 http://www.paragon-cs.com/wordpress/?p=106#comment-1150 In Debian it's not just theoretically possible that a security problem is fixed before MySQL releases a new version, it's the common practise. In Debian it’s not just theoretically possible that a security problem is fixed before MySQL releases a new version, it’s the common practise.

]]>