{"id":1294,"date":"2009-01-30T03:32:52","date_gmt":"2009-01-30T08:32:52","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=1294"},"modified":"2009-01-30T03:32:52","modified_gmt":"2009-01-30T08:32:52","slug":"mysql-51-a-hot-skill-for-2009","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2009\/01\/30\/mysql-51-a-hot-skill-for-2009","title":{"rendered":"MySQL 5.1: a hot skill for 2009"},"content":{"rendered":"<p>Today Giuseppe pointed me to <a href=\"http:\/\/www.computerweekly.com\/Articles\/2009\/01\/22\/234369\/hot-skils-mysql-5.1.htm\">Hot skills: MySQL 5.1<\/a>, an article in ComputerWeekly.com.<\/p>\n<p>The takeaway from the Gartner report quoted?<\/p>\n<ul>\n<li>Gartner published a report titled &#8220;The Growing Maturity of Open-Source Database Management Systems&#8221; in November 2008, and found that there was a 50% increase from 2007 to 2008 in the usage of open source DBMS&#8217;s in production.<\/li>\n<li><i>&#8220;Gartner says the major open source DBMSs are now available for installation as packages, without involving the source code, and include tools to help support administrators and managers.&#8221;<\/i> I&#8217;d like to state that, MySQL has always been available in packaged format, and you don&#8217;t need to fudge with the source code if you do not want to. In fact, its available on all your distributions as well.<\/li>\n<li><i>&#8220;Gartner still has reservations: open source DBMSs should be used &#8220;primarily for non-mission-critical applications and those that do not require high availability&#8221;. However, they add, &#8220;If the technical capabilities of the staff are strong, use of an open-source DBMS in mission-critical environments is possible now&#8221;.&#8221;<\/i> I&#8217;d like to affirm that its being used in mission critical environments daily, and no one worries otherwise. <a href=\"http:\/\/mysql.com\/customers\">Customers<\/a> from  <a href=\"http:\/\/mysql.com\/customers\/customer.php?id=75\">Google<\/a> right to Cisco, Nokia, and more, use MySQL, without hiccups.<\/li>\n<\/ul>\n<p>The report states that MySQL DBA&#8217;s pull in around \u00a330,000 to \u00a340,000 a year. The recommendation for training, is:<\/p>\n<blockquote><p>\nStart with Sun&#8217;s aptly named &#8220;Getting Started with MySQL&#8221; and the <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/tutorial.html\">MySQL tutorial<\/a>, or search for free independent online tutorials.\n<\/p><\/blockquote>\n<table border=0>\n<tr>\n<td>\n<iframe src=\"http:\/\/rcm.amazon.com\/e\/cm?t=colincharles-20&#038;o=1&#038;p=8&#038;l=as1&#038;asins=0672328127&#038;md=10FE9736YVPPT7A0FBG2&#038;fc1=000000&#038;IS2=1&#038;lt1=_blank&#038;m=amazon&#038;lc1=0000FF&#038;bc1=000000&#038;bg1=FFFFFF&#038;f=ifr\" style=\"width:120px;height:240px;\" scrolling=\"no\" marginwidth=\"0\" marginheight=\"0\" frameborder=\"0\"><\/iframe>\n<\/td>\n<td>\nI can highly recommend attending a <a href=\"http:\/\/mysql.com\/training\/\">training<\/a> session (<a href=\"http:\/\/mysql.com\/training\/schedule.php?class=5200\">MySQL for Database Administrators<\/a> or <a href=\"http:\/\/mysql.com\/training\/schedule.php?class=5100\">MySQL for Developers<\/a>), and then focusing on getting <a href=\"http:\/\/mysql.com\/certification\/\">certified<\/a>. Of course, the book on the left, the <a href=\"http:\/\/www.amazon.com\/gp\/product\/0672328127?ie=UTF8&#038;tag=colincharles-20&#038;linkCode=as2&#038;camp=1789&#038;creative=390957&#038;creativeASIN=0672328127\">MySQL 5.0 Certification Study Guide (MySQL Press)<\/a><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/www.assoc-amazon.com\/e\/ir?t=colincharles-20&#038;l=as2&#038;o=1&#038;a=0672328127\" width=\"1\" height=\"1\" border=\"0\" alt=\"\" style=\"border:none !important; margin:0px !important;\" \/> is also invaluable.\n<\/td>\n<\/tr>\n<\/table>\n<p>Good luck in becoming MySQL certified, and prosper with your hot skill for 2009!<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20MySQL%205.1%3A%20a%20hot%20skill%20for%202009&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2009%2F01%2F30%2Fmysql-51-a-hot-skill-for-2009&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"bd2556af8b\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/01\/30\/mysql-51-a-hot-skill-for-2009?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-1294\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/01\/30\/mysql-51-a-hot-skill-for-2009?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-1294\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/01\/30\/mysql-51-a-hot-skill-for-2009?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-1294\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/01\/30\/mysql-51-a-hot-skill-for-2009?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Today Giuseppe pointed me to Hot skills: MySQL 5.1, an article in ComputerWeekly.com. The takeaway from the Gartner report quoted? Gartner published a report titled &#8220;The Growing Maturity of Open-Source Database Management Systems&#8221; in November 2008, and found that there was a 50% increase from 2007 to 2008 in the usage of open source DBMS&#8217;s [&hellip;]<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20MySQL%205.1%3A%20a%20hot%20skill%20for%202009&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2009%2F01%2F30%2Fmysql-51-a-hot-skill-for-2009&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"bd2556af8b\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/01\/30\/mysql-51-a-hot-skill-for-2009?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-1294\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/01\/30\/mysql-51-a-hot-skill-for-2009?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-1294\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/01\/30\/mysql-51-a-hot-skill-for-2009?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-1294\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/01\/30\/mysql-51-a-hot-skill-for-2009?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_options":[]},"categories":[23],"tags":[699,1775,30],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-kS","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1576,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2009\/08\/23\/mysql-labs","url_meta":{"origin":1294,"position":0},"title":"MySQL Labs","date":"23\/8\/2009","format":false,"excerpt":"Who remembers snaps? This is the place to go, when you wanted nightly source code snapshots of stuff that comes out of MySQL AbSun Microsystems build systems, that is related to the MySQL product line. There you can get all the snapshots for GA releases, as well as archives; (albeit\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":791,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/15\/mysql-full-text-search-by-alex-rubin","url_meta":{"origin":1294,"position":1},"title":"MySQL Full Text Search by Alex Rubin","date":"15\/4\/2008","format":false,"excerpt":"Download the PDF: http:\/\/www.mysqlfulltextsearch.com\/full_text.pdfDefault search by relevance, default sort is by relevanceBoolean search is also popular. cats AND dogs. No default sorting, so you need to order the results yourselfPhrase searchMySQL Full Text Index, only available with MyISAM, and it supports natural language and Boolean search. ft_min_word_len - 4 characters\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":781,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/14\/my-favourite-bugfix-in-mysql-5124-rc","url_meta":{"origin":1294,"position":2},"title":"My favourite bugfix in MySQL 5.1.24-rc","date":"14\/4\/2008","format":false,"excerpt":"I've been using MySQL 5.1 a lot more of late. Also, as of about a month ago, I'm now a Mac OS X user, so tend to use MySQL on OS X Leopard 10.5 a lot more for testing. I've found a rather annoying bug (in 5.1.23-rc) that is fixed\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":375,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2006\/03\/05\/mysql-51-ipod-nano-giveaway-winner-1","url_meta":{"origin":1294,"position":3},"title":"MySQL 5.1 iPod Nano giveaway, winner #1","date":"5\/3\/2006","format":false,"excerpt":"Congratulations to Giuseppe Maxia, who's won himself an iPod Nano! Giuseppe has been actively submitting bug reports for MySQL 5.1, plus he's got an interesting blog (syndicated at Planet MySQL), mentioning new features that are available in MySQL 5.1. Of interest, is your performance related post on Partitioning. To add\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":787,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/15\/winners-for-2008-at-the-mysql-conference","url_meta":{"origin":1294,"position":4},"title":"Winners for 2008 at the MySQL Conference","date":"15\/4\/2008","format":false,"excerpt":"2008 MySQL Application of the YearSocial Network - MySQL powered with over 70 million active users (Facebook)Mobile operator - Highly available LAMP platform at the heart of SMS, mobile and CRM applications (Virgin Mobile France)eCommerce site - Built caching tier using MySQL for 4 billion transactions per day (eBay)2008 MySQL\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1193,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/12\/05\/mysql-51-is-released","url_meta":{"origin":1294,"position":5},"title":"MySQL 5.1 is released","date":"5\/12\/2008","format":false,"excerpt":"There has been a lot of hoopla with regards to the GA release of MySQL 5.1. I've been using it on and off for quite a number of things, and during all my demonstrations, I make extensive use of it. My advice? Test it. If something's not right, report a\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"MySQL 5.1","src":"https:\/\/i0.wp.com\/farm4.static.flickr.com\/3205\/3074211148_b299a8203e.jpg?resize=350%2C200","width":350,"height":200},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1294"}],"collection":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=1294"}],"version-history":[{"count":1,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1294\/revisions"}],"predecessor-version":[{"id":1295,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1294\/revisions\/1295"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=1294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=1294"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=1294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}